thirdeye Posted February 9, 2006 Share Posted February 9, 2006 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.RegardsThird Eye Link to comment https://forums.phpfreaks.com/topic/3361-connecting-to-a-remote-mysql-server/ Share on other sites More sharing options...
wickning1 Posted February 9, 2006 Share Posted February 9, 2006 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. Link to comment https://forums.phpfreaks.com/topic/3361-connecting-to-a-remote-mysql-server/#findComment-11500 Share on other sites More sharing options...
fenway Posted February 9, 2006 Share Posted February 9, 2006 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. Link to comment https://forums.phpfreaks.com/topic/3361-connecting-to-a-remote-mysql-server/#findComment-11503 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.