MySQL Forums
Forum List  »  Security

ERROR 1045 (28000): Access denied for user 'root'@'server-name
Posted by: Paul Gardner
Date: October 20, 2013 11:29PM

Server: RHEL 5.6
2 Instances of mysql running

1. Default install (yum installed) running on port 3306

2. New, install - Bitnami Wordpress stack - mysql running on 3307


mysql (connecting to default port 3306) - works fine
mysql -P3307 - connects, but to WRONG instance - it assumes localhost/3306 socket

mysql -h service-name (i.e. NOT localhost) -P3307 -u root -p FAILS with error -
ERROR 1045 (28000): Access denied for user 'root'@'server-name'

Any ideas - I've been trying to fix this for 2 days....


Options: ReplyQuote

Written By
ERROR 1045 (28000): Access denied for user 'root'@'server-name
October 20, 2013 11:29PM

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.