error while troubleshooting mysql
 

Hi All,
I installed mysql and i got the results exactly as showed in the document for installation of mysql but while troubleshooting, i am gettign an error.It is like

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)


Can you please help whats wrong. When i went to /etc/init.d and run
mysql start
i am getting same error . Please help.

Did you set a root password during installation?

If so you would start mysql like this:

linux$ mysql -u root -p
Enter password:

If you don't use the -p, the mysql server thinks you want to load mysql without a password, and it won't let you do that if you are root (won't let you do it as anyone else either, unles root has created your user to login without a password).

S

hi
 

Hi system addict,
I tried to do as you said and now its giving different error
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

PLEASE HELP

Did you get the 'Enter password:' prompt?

S

HI
 

ye i got it and then that message.

HI
 

Hi help me out please.

Did you enter a password at the password prompt?

S

You might want to check out how to reset the root password: http://dev.mysql.com/doc/refman/5.0/...rmissions.html (I've never had to try this myself).

S

HI
 

Ya i entered the password and got that different error. Thanks. I don't know what to do.