neal wang
asked on
how come I can't login to mysql after restoring a db?
elcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.7.29 MySQL Community Server (GPL)
I was able to login as mysql -u root -p
with the password at that prompt
I also created another user with a password
I restored a db dump with the second user... then i attempted to login to mysql as root but now I'm not able to ... what happened and how do I login back to mysql?
Your MySQL connection id is 12
Server version: 5.7.29 MySQL Community Server (GPL)
I was able to login as mysql -u root -p
with the password at that prompt
I also created another user with a password
I restored a db dump with the second user... then i attempted to login to mysql as root but now I'm not able to ... what happened and how do I login back to mysql?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.