Error code 1045
Access denied for user ' root ' @ ' localhost ' (using Password:yes)
The workaround is to reset the root user password by following the steps in the Windows platform:
1. Log in 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, management 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 commands 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, change the root user password by executing the contents of the file named by the "--init-file" option (function: Read the SQL command 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.
Report:
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
MYSQL error Code 1045