MySQL Forums
Forum List  »  Security

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost'
Posted by: Georgi Kodinov
Date: February 07, 2014 09:38AM

There's little I can suggest based on the above information.

Note that the mysql command line client that you seem to be using, when given both a host/port AND an unix socket path does ALWAYS prefer the socket.

So the following are equivalent and will always connect to the same server (the one that listens on the /u01/app/mysql/admin/mq01wldb01/data/mq01wldb01.sock socket) :
mysql -uroot -p -P3306 -hlocalhost -S/u01/app/mysql/admin/mq01wldb01/data/mq01wldb01.sock
mysql -uroot -p -P3307 -hlocalhost -S/u01/app/mysql/admin/mq01wldb01/data/mq01wldb01.sock
mysql -uroot -p -P1 -hlocalhost -S/u01/app/mysql/admin/mq01wldb01/data/mq01wldb01.sock
mysql -uroot -p -P22200 -hlocalhost -S/u01/app/mysql/admin/mq01wldb01/data/mq01wldb01.sock

So you either need to drop the host (-h) and port (-P) options or you need to drop the socket (-S) option.

note also that, as an optimization, even if you don't specify a socket, mysql will always try to use the unix sockets if you specify "-h localhost".
To avoid this you should use your host's real ipv4 address instead.

Options: ReplyQuote

Written By
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost'
February 07, 2014 09:38AM

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.