Access denied for user ' root ' @ ' localhost ' (using Password:yes)
ERROR 1045:access denied for user: ' [email protected] ' (Using password:yes)
The first two days also occasionally appear this error, also did not care, because I re-modify the root password of MySQL again can use, but yesterday but not, I put the root password modified later although can use, once re-enter on can not use, but my password clearly not wrong ah? Today finally found the reason, is the authority problem, we can refer to the following two articles to see: http://topic.csdn.net/t/20060117/15/4521496.html# http://doc.99net.net/doc/ Database/1076488199/1076549732.html because has never encountered this situation before, so the solution is recorded in this, so that the future of their own inspection, the specific method is you change the root password when you add a sentence to the rights of the statement:
Grant all on mysql.* to ' root ' @ ' localhost ' identified by ' password ';
The last password is the password of the root user you want to change.
Just started using MySQL to give me a horse, the last few days after the completion of the database installation manual modified the root user password, and then the root user login is all OK. However, the 1045 error code is reported on the landing today. Error code 1045
Access denied for user ' root ' @ ' localhost ' (using Password:yes)
My workaround is to reset the root user password, under the Windows platform, the following steps:
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:\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, if the start MySQL server error, the process Mysqld-nt.exe shutdown. Then restart it, OK.
6, or stop the MySQL server, and then 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.
You should be able to connect using the new password.
Django remote database MySQL migrate failure report error 1045 Solutions
