Jump to content


Photo

Connecting to a remote mysql server


  • Please log in to reply
2 replies to this topic

#1 thirdeye

thirdeye
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 09 February 2006 - 11:45 AM

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

#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 09 February 2006 - 04:52 PM

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.

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 09 February 2006 - 06:32 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users