1. Find the my.ini file in the MySQL installation directory, and add a line of skip grant tables.
2. Press win, then enter CMD, and right-click to run in administrator mode.
3. Enter the command: net stop Mysql to stop the service first. Next, enter net start Mysql to start the service.
4. After MySQL – uroot – P, enter directly, and then enter.
5. Use MySQL select the MySQL library and execute it. Update user set password = password (“123456”) where user = ‘root’;
6. After the above operations are successful, find the my.ini file in the MySQL installation directory, and then delete skip grant tables.
7. After the above operations are completed, enter the command: net stop Mysql to stop the service first. Next, enter net start Mysql to start the service.
Read More:
- MYSQL Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: Yes)
- [Solved] Caused by: java.sql.SQLException: Access denied for user ‘root‘@‘hadoop102‘ (using password: YES)
- After installing mysql5.7 on centos7, an error 1045 (28000) is reported: access denied for user ‘root’ @’localhost ‘(using PAS)
- Mysqldump: Got error: 1045: Access denied for user ‘root‘@‘localhost‘
- [Solved] pymysql.err.OperationalError: (1045, “Access denied for user ‘root‘@‘192.168.118.44‘
- [Solved] ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘
- [Solved] Error 1044: Access denied for user ‘syz-remote‘@‘%‘ to database ‘webapp‘
- Mysql5.7.18.1 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
- [Solved] mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this opera
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- [Solved]Error 1054 (42s22): unknown column ‘password’ in ‘field list’ how to modify the password
- MYSQL Use cmd to change root password error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual tha
- [Solved] There is a problem with mysql8.0 without password in Navicat connection
- Docker mysql8 modify password
- [Solved] mysql 2003 remote access failed mysql8 configure remote access
- [Solved] there are special symbols in the initial password for installing MySQL in Hadoop, and an error is reported
- [Solved] Navicat Connect MySQL error: Authentication plugin ‘caching_sha2_password‘ cannot be loaded
- ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’ (Fixed)
- [Solved] ERROR 1054 (42S22): Unknown column ‘password‘ in ‘field list‘