ErrorCode
1045
Access denied for user ' root ' @ ' localhost ' (using Password:yes) The workaround is to reset the root user password in the Windows platform under the following steps: 1, log on to the system as a system administrator, 2, if the MySQL server is running, stop it. If the server is running as a Windows service, go to Service Manager: Start menu, Control Panel, administrative tools, services if the server is not running as a service, you might need to use Task Manager to force it to stop. 3. Create 1 text files and place the following command in a single line: 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 DOS command prompt: Start menu, run-cmd assume that you have installed MySQL to C:\mysql. If you installed MySQL in a different location, please adjust the following commands accordingly. At the DOS command prompt, execute the command: c:\> C:\mysql\bin\mysqld-nt--init-file=c:\mysql-init.txt When the server starts, it is executed by the "--init-file" option (as Change the root user password by using the contents of a file named after the SQL command is read from the specified file at startup. When the server starts successfully, you should remove C:\mysql-init.txt. 5. Stop the MySQL server and restart it in normal mode. If you are running 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. Attached: Other methods
method One:
#/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 newly set password newpassword>
Mysql>
Method Two:
Use the user name and password provided directly in the [client] section of the/etc/mysql/debian.cnf file:
# mysql-udebian-sys-maint-p
Enter Password: < Enter the password for the [client] section >
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
# mysql-uroot-p
Enter Password: < Enter the newly set password newpassword>
Mysql>
Content from: Scripting House www.jb51.net
Another method
Windows:
1. Admin login system, stop MySQL service or end mysqld-nt process
2. Go to the command line and come to the MySQL installation directory. Assuming that 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 check of permissions
4. Run d:\mysql\bin\mysqladmin-u root flush-privileges password "newpassword" Reset root password
5. Restart the MySQL service
Solution for MySQL error code 1045