MySQL Forums
Forum List  »  Security

Re: ERROR 1045 (28000): Access denied for user 'root'@'server-name
Posted by: Georgi Kodinov
Date: November 22, 2013 12:10AM

When you use something else but localhost the client uses a different network interface to connect to the server.
For localhost it is using unix sockets and for host names tcp/ip.
And in the mysql privilege system these are two different login names, as the server always authenticates the user and host combination and not just the user name.
Thus please check if your grants allow logins from your host name and they are the same as the ones allowed for localhost. Or use wildcards for host names when granting privileges.

Options: ReplyQuote

Written By
Re: ERROR 1045 (28000): Access denied for user 'root'@'server-name
November 22, 2013 12:10AM

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.