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
"
"
Subject
Written By
Posted
Remote can login , but localhost can not login
September 23, 2018 06:52PM
September 23, 2018 07:22PM
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.