MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Can connect to database on localhost with root but not with other users
Posted by: Peter Brawley
Date: January 22, 2019 11:31AM

Run ...

mysql -p3306 -uroot -pPWD

mysql -p3307 -uroot -pPWD

mysql -p3308 -uroot -pPWD

... in three cmd windows, in each run ...

select user, host, password from mysql.user;

... for each user compare results of Show Grants; and revise as necessary.




and revis as needed

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Can connect to database on localhost with root but not with other users
Rob Barrett
January 21, 2019 05:30PM
Re: Can connect to database on localhost with root but not with other users
Peter Brawley
January 22, 2019 11:31AM


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.