Error 1044, access denied for '@loc

[VeronicaCBurgess]

Error 1044, access denied for '@localhost' to database mysql.

I am very new to MySql and PHP. Could you please help me get past the ERROR 1044. The MySql service seems to be running fine on WinXP but I get the error that won't allow me to log in and create a database. I have tried the MySql website without success.

Thanks

 

[sleipnir214]

MySQL user credentials are not a 2-tuple of username and password. They are a 3-tuple of username, password, and IP from which the user is connecting.

It is possible, for example, for user "foo" using password "bar" to connect from IP 1.2.3.4, but not from localhost.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[VeronicaCBurgess]

THAT WORKED! Thanks

 

[tshot]

localhost means u are using mysql from the m/c where it is installed

if u are using the default mysql installtion then probably u have one row for localhost where value for tuple 'User' is null.

this would match before any user and this entry has no password. hence anonymous user is without passwd

u try with no passwd. alternatively u can

$ mysql -u root mysql
mysql>delete from user where User="" ;
mysql>flush privileges ;

for details see MySql from PaulDuBois (Publisher TechMedia)



[ponder]
----------------
ur feedback is a very welcome desire

 

[lebisol]

some_user@localhost shoould exsits in order to connect...

> need more info?
:: don't click HERE ::

 

[tshot]

the user table has default entry of localhost with balnk in user tuple for anonymous user




----------------
ur feedback is a very welcome desire

 

[lebisol]

hm...then perhpas the rights of "anonymous" to the new DB could be in question?
All the best!

> need more info?
:: don't click HERE ::