#2 How to Access Remote MySQL Databases Using Local phpMyAdmin | phpMyAdmin Tips and Troubleshooting

In this tutorial I’ll show you how to connect remote MySQL database using local phpMyAdmin as you know MySQL was one of the first open-source database and remains so to this day. MySQL is typically used in conjunction with PHP and Apache Web Server. So people are using MySQL in different server for different application & to manage all remote database no need to connect individual server, you can manage all remote MySQL DB using phpmyAdmin software.

Error covered:
mysqli_real_connect(): (HY000/1045): Access denied for user @'localhost' (using password: YES)
Error Code: 200
SET lc_messages = ‘en_US’;
#1193 - Unknown system variable 'lc_messages'

Our Social Links-

#connectMySQLdatabase #connectRemoteDatabase #phpMyAdmin

[davidalcock]

Great video but PLESASE remove the music! It is never needed and really makes it hard to hear and understand what you are saying.

[CloudLearning]

I a using it with nginx server, however, after adding the code to file still only can see local host remote server is not coming up.

any suggestion.

[monsieurabeille]

Hi there, How to connect to a remote localhost mysql database in phpmyadmin if the computer containing localhost database and remote computer are connected by RJ45 (Ethernet) cable and have internet access?

[restyobina.]

Is this gonna work if not same network?

[neilalvinservidad]

I want to make my local mysql database accessible in different location, Is it possible?

[samiulhaq]

sir its not working in my case, is there any other solution? thanks and great

[ebtntw]

how can i host a database and then it can be access from a different computer from a different location.

[theonewhowas]

why is it always a robot sounding person that absolutly cannot speak english.. good god

[mrlloydval]

hey my man. you are talking in english with a thick accent. i'm sure you know that you have an accent.
that's fine. there is nothing wrong with having an accent.

surely you can acknowledge that you ALSO have a low quality microphone, which makes it more difficult to hear you clearly?

so why would you ALSO play music at an equal volume to your speaking voice, making it EVEN MORE difficult to hear you clearly?

[promalin]

what is this stupid "background" music good for?

[rakeshaahir]

what if ip address is not available in host