Connection to Database failed

[technobia]

Keep getting the error message when trying to connect to a MySQL database:

"Connection to Database failed
Host 'MYSERVER' is not allowed to connect to this MySQL server"

I can sucessfully create and view the database, I can sucessfully login to the MySQL Command Line Monitor AND the MySQL Administrator using the 'root' user so I know my password is good. I have given the IUSR_MYSERVER Internet Guest Account read, write & modinfy privelages to the database folders.

What might be going on here?
Thanks - Jody

 

[audiopro]

What are you connecting from?
What syntax does your connection attempt use?


Keith

http://www.studiosoft.co.uk

 

[technobia]

Hi audiopro - Well I got the issue resolved. It was a password authentication issue. Even thought I could login in via MySQL administrator and the command line monitor, I had to use the SET PASSWORD command. I am not sure if it was to reset the password or register it somehow as the person that suggeesteded it to me did not explain why. In any case I can connect now. The application trying to connect from is Zen Cart eCommerce PHP application and it has a wizard so I am not sure what the code syntax is.

Thanks - Jody

 

[andrewxie]

try this: SET password for 'user'@'localhost'=old_password('yourpassword');