Jump to content

Archived

This topic is now archived and is closed to further replies.

thirdeye

Connecting to a remote mysql server

Recommended Posts

Hi All,

It would be great if somebody could give me a solution for this problem.

I need to connect to a remote mysql server using my local phpmyadmin tool.

I added the HOST parameter from localhost to the remote server name.

It uses a root username without any password to connect locally in the remote machine.

But it is not able to connect to the desired server.

Please help.

Regards
Third Eye

Share this post


Link to post
Share on other sites
MySQL restricts access to certain username@IPAddress combinations, just trying to log in as root is not enough.

You probably need to create a user on the remote server for root@yourIPAddress and grant it privileges.

Share this post


Link to post
Share on other sites
It's also possible that the remote system simply doesn't allow non-localhost connections, in which case it doesn't matter what the grant tables say.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.