Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: Yes)
This prompt is a password error. If you forget your password, you can use this method to reset your password
* * 1. * * the first step to reset your password is to skip the password authentication process of MySQL
modify the MySQL configuration file
and find it in the directory of C:// program files/MySQL/MySQL server 5.7 my.cnf/my .ini/my- default.ini One of the three is modified
in [mysqld] skip-grant-tables
**2 * * restart MySQL service
net start mysql
If this command reports an error and cannot start MySQL service, run it as an administrator cmd.exe ( cmd.exe In the directory of C: Windows: system32
**3. * * implementation again
mysql -u root -p
You don’t need to enter a password. Press enter to enter mysql
**4 * * Change Password
update user set Password=PASSWORD('888888') where User='root';
FLUSH PRIVILEGES;
Use 888888 to login next time
5. If 4 reports error 1820 (HY000): you must set password before executing this statement, execute the code
SET PASSWORD = PASSWORD('123456');
or SET PASSWORD = '123456';
Then prompt query OK, 0 rows affected (0.00 sec)
and you can log in with 123456 password
Read More:
- [Solved] 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‘
- Mysql5.7.18.1 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
- [Solved] ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
- [Solved] Error 1044: Access denied for user ‘syz-remote‘@‘%‘ to database ‘webapp‘
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- 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
- [Solved] mysql 2003 remote access failed mysql8 configure remote access
- [Solved] Navicat Connect MySQL error: Authentication plugin ‘caching_sha2_password‘ cannot be loaded
- Docker mysql8 modify password
- [Solved] mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this opera
- MySQL Change password failure prompt: ERROR 1064(42000):You have an error in your SQL syntax: check the corresponds to your M
- [Solved]Error 1054 (42s22): unknown column ‘password’ in ‘field list’ how to modify the password
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- [Solved] there are special symbols in the initial password for installing MySQL in Hadoop, and an error is reported