MySQL8 database login, my database has been launched, enter the correct password still can't log in, perform mysqld, console, skip - grant - tables - Shared - memory statement skip execution, this how to deal with?

CodePudding user response:

Probably you password to remember wrong - skip - grant - tables parameter is leap authentication, use this parameter starts to change the password again

CodePudding user response:

refer to 1st floor boring pig reply:

probably password you remember wrong, - skip - grant - tables parameter is the leap authentication, use this parameter is starting to change password again after

Not remember the password, the password input the correct,

CodePudding user response:

 select user, host, password from mysql. The user; 

Check whether the different host set up different password, can use 127.0.0.1, to test,

CodePudding user response:

Mysql installation time to remember the username, password, connection name,