MySQL Forums
Forum List  »  Newbie

Remote can login , but localhost can not login
Posted by: eric tang
Date: September 23, 2018 06:52PM

I have a mysql db , when remote access it ( mysql -uuser1 -p -H remote_host ) , it is OK to connect , but when connect from localhost , it is not work

#mysql -uuser -p
ERROR 1045 (28000): Access denied for user 'user1'@'localhost'

I checked the access right by the following command , it seems released to the user , would advise what is wrong to local connect ?

mysql> select user, host from mysql.user;
"
"
| user1 | localhost
"
"

Options: ReplyQuote


Subject
Written By
Posted
Remote can login , but localhost can not login
September 23, 2018 06:52PM


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.