Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost'

[Georgi Kodinov]

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.