help with no connection allowed mysql

revolution · 02-06-2006, 05:32 PM

i keep getting this error on a new dedicated server with mysql

Code:

mysql_connect(): Host 'localhost.localdomain' is not allowed to connect to this MySQL server

can anyone give me a clue on how to fix that. Ive tried editing /etc/hosts and the error just changes depending on what is changed. I

sde · 02-06-2006, 08:46 PM

wow look who it is

long time no see!

have you logged into mysql as root and tried a grant statement for the user?

Code:

$ mysql -uroot -pmypass
> GRANT ALL PRIVILEGES ON *.* TO myuser@localhost.localdomain IDENTIFIED BY 'somepass';
> exit;

DJMaze · 02-07-2006, 08:40 AM

I do hope you're using MySQL 4.0.x else you need to screw around with OLD_PASSWORD or something

revolution · 02-10-2006, 01:37 AM

thanks SDE, that worked, although i may have screwed something up, im not sure what it is, but something just doesnt feel right.

Glad to see everyone again

sde · 02-10-2006, 07:43 AM

You just need to use that with whatever user and hostname you're from. usually it would just be 'localhost' instead of 'localdomain.localhost', but if you were getting an error like that, then mysql is recognizing the long hostname first.