MySql error code 1045 solution _ MySQL

Solution for MySql error code 1045 bitsCN.com
Error code 1045 Access denied for user 'root' @ 'localhost' (using password: YES) the solution is to reset the root user password. the procedure for Windows is as follows: 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 may need to use the Task Manager to forcibly stop it. 3. create a text file and place the following command in a single line: set password for 'root' @ 'localhost' = PASSWORD ('mynewpassword '); save the file with any name. In this example, the file is C:/mysql-init.txt. 4. enter the doscommand prompt: Start menu-> Run-> cmd. assume that you have installed MySQL to C:/mysql. If you install MySQL in another location, adjust the following commands. At the doscommand prompt, execute the command: C:/> C:/mysql/bin/mysqld-nt -- init-file = C:/mysql-init.txt when the server is started, run the "-- init-file" option (function: Read the SQL command from the specified file at startup) to change the root user password. C:/mysql-init.txt should be deleted when the server is successfully started. 5. stop the MySQL server and restart it in normal mode. If you run the server as a service, you should start it from the Windows service window. If the server is started manually, the command can be used as usual. Appendix:
Other methods: (recommended) mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD ('your new password') where USER = 'root '; mysql> flush privileges; mysql> quit
Method 2: directly use the username and password provided in the [client] section of the/etc/mysql/debian. cnf File: # mysql-udebian-sys-maint-p Enter password: <输入[client]节的密码> Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root'; mysql> flush privileges; mysql> quit # mysql-uroot-p Enter password: <输入新设的密码newpassword> Mysql> Content reference:
Another method is Windows: 1. log on to the system as an administrator, stop the mysql service, or end the mysqld-nt process. go to the command line and go to the mysql installation directory. assume that the installation directory is d:/mysql/, and CMD enters command line 3. run d:/mysql/bin/mysqld-nt -- skip-grant-tables to start mysql and disable permission check. run d:/mysql/bin/mysqladmin-u root flush-privileges password "newpassword" to reset the root password 5. restart mysql Service author bjtdeyxbitsCN.com