mySQL access with SQLyog

55debra · #1 (**permalink**) 03-25-11, 06:51

Hello!
I am trying to connect to my mySQL database utilizing SQLyog instead of the cPanel.

I have entered the MySQL Host Address as 87.117.200.71, and the User Name and Password that I would normally utilize to interact with the database through PHP.

I keep getting an 1045 error (access denied for user) though. I think that I might be incorrectly recognizing the server.

WebMaster · #2 (**permalink**) 03-25-11, 06:56

Hi!
Cpanel does not permit users to connect remotely if users do not tell cpanel which host should be offered to connect from remote location.

Just visit http:// whatismyip.com and write that IP address inside access host section of cpanel's MySQL Server section. This way you can permit your local computer to connect to your database. Fire1

55debra · #3 (**permalink**) 03-25-11, 07:00

Hi!
Excellent - this works now.
Thanks very much. Thanx