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.


I also asked the same question in linux-newbie and nobody is able to answer the question and so since it is related to software, i thought it is appropriate to ask in this section.

I've had a lot of trouble executing commands for mysql-admin from the command line. If you look at the Sun docs they list different ways that you can pass in the username and password, and none of them have ever worked for me except the first time I created a root password and set up the database. I know this doesn't really SOLVE the problem, but I'd like to suggest you install phpmyadmin and execute your queries that way. For some reason when I enter the username and password via phpmyadmin I don't have this issue.

Look at the man page for mysql. Your error says that you're not passing it a password, and it's expecting one (indicating you set root up with a password at installation time).

Check the syntax against the man page, but I think that "mysql -u root -p <password>" will work.