MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Posted by: carole ngiamba
Date: August 24, 2006 11:21AM

hi all

i got the same error message , and now i've solve it.

i'm using CentOS.( a Unix system).

In fact in my case the problem was not the Mysql Password.

It was a socket problem.I found that, the /var/lib/mysql/ directory was not

existing in the system.The directory that contains the server's process ID &

the socket to use to connect to the server is :/var/run/mysqld/.

So i looked up to my 'my.cnf' file (located in /etc/) to know which Socket one

required to use , and i discovered that it was the wrong one

the /var/lib/mysql/myqsl.sock.

I changed this socket path with /var/run/mysqld/mysqld.sock;I rebooted :-)

and i succeed to connect using:

#mysql -u root -S /var/run/mysqld/mysqld.sock

I hope Someone satisfied :-)
excuse my english,i'm francophone speaking...

Options: ReplyQuote

Written By
June 27, 2009 08:29PM
December 16, 2007 02:18AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
August 24, 2006 11:21AM
December 27, 2007 02:08PM
January 16, 2011 06:51AM
August 27, 2009 12:22AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.