Copy Code code as follows:
Error code 1045
Access denied for user ' root ' @ ' localhost ' (using Password:yes)
The workaround is to reset the root password by following the steps in the Windows platform:
1, as a system administrator login to the system;
2, if the MySQL server is running, stop it.
If it is a server running as a Windows service, go to Service Manager: Start menu-> Control Panel-> management tools-> Services
If the server is not running as a service, you may need to use Task Manager to force it to stop.
3. Create 1 text files and place the following commands on a single line:
Copy Code code as follows:
SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Mynewpassword ');
Save the file with any name. In this case, the file is C:\mysql-init.txt.
4, enter the DOS command prompt: Start menu-> run-> cmd
Assume that you have installed MySQL to C:\mysql. If you have MySQL installed in another location, please adjust the following command accordingly.
At the DOS command prompt, execute the command:
Copy Code code as follows:
C:\> C:\mysql\bin\mysqld-nt--init-file=c:\mysql-init.txt
When the server starts, executes the contents of the file named by the "--init-file" option, which reads the SQL command from the specified file at startup, and changes the root user password. After the server has successfully started, you should delete the C:\mysql-init.txt.
5, stop the MySQL server, and then restart it in normal mode. If you run the server as a service, you should start it from the Windows Services window. If you start the server manually, you can use the command as you normally would.
Additional methods are attached:
Method One:
Copy Code code as follows:
#/etc/init.d/mysql Stop
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
#/etc/init.d/mysql Restart
# mysql-uroot-p
Enter Password: < Enter the new password newpassword>
Mysql>
Method Two:
Use the username and password provided directly in the [client] section of the/etc/mysql/debian.cnf file:
Copy Code code as follows:
# mysql-udebian-sys-maint-p
Enter Password: < Enter the password for [client] section >
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
# mysql-uroot-p
Enter Password: < Enter the new password newpassword>
Mysql>
Another method
Windows:
1. Admin login system, stop MySQL service or end mysqld-nt process
2. Go to the command line and come to MySQL's installation directory. Assuming the installation directory is d:\mysql\, CMD enters the command line
3. Run d:\mysql\bin\mysqld-nt--skip-grant-tables start MySQL, turn off permissions check
4. Run d:\mysql\bin\mysqladmin-u root flush-privileges password "newpassword" Reset root password
5. Restart the MySQL service