Step 1: open my.cnf configuration file and add skip-gran-tables
. CNF cannot be found, so you can edit a
by yourself in /etc. Step 2: restart mysql
step 3: after login, leave the password empty and modify it. Otherwise, an error will be reported
Update User Set Authentication_string = ‘” Where user=’ root ‘;
ALTER USER ‘root’ @’ localhost ‘IDENTIFIED WITH mysql_native_password BY’ password ‘;
ALTER USER ‘root’ @’ localhost ‘IDENTIFIED WITH mysql_native_password BY’ password ‘
Read More:
- [MySQL] error 1396 (HY000): Operation create user failed for ‘MySQL’ @’localhost ‘
- Error 1045 (28000): solution to access denied for user ‘root’ @’localhost ‘(using password: no)
- Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: no)
- MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))
- Solve MySQL error 1698 (28000): access denied for user ‘root’ @’localhost ‘
- Error 1045 (28000) access denied for user ‘root’ @’localhost ‘appears in MySQL under Windows system
- MySQL connection error access denied for user ‘root’ @ ‘localhost‘
- ERROR 1045 (28000): Access denied for user’ODBC’@localhost (using password: NO)209150;’211503;’
- ER_ACCESS_DENIED_ERROR: Access denied for user ‘root‘@‘localhost‘ (using password: NO)
- How to Fix failed to Connect to MySQL at localhost:3306 with user root
- Error 1396 (HY000): Operation create user failed for ‘xxx’ @’xxx ‘
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- MySQL forgot the root password
- Linux (error 1819 (HY000): your password does not satisfy the current policy requirements)
- Error code 1045, state 28000, Java sql.SQLException :Access denied for user ‘root’@’localhost’
- MYSQL login error: mysqladmin: connect to server at’localhost’ failed
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- MYSQL:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ERROR 2002 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
- MySQL Workbench Failed to Connect to MySQL at 127.0.0.1:3306 with user root Bad handshake