Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost'
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.
Subject
Views
Written By
Posted
3536
November 26, 2013 11:28PM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost'
2304
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.