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. When the server is successfully started, delete the C: \ mysql-init.txt. 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/etc/mysql/debian. the user name and password provided in the [client] section of the cnf file: # mysql-udebian-sys-maint-p Enter password: <enter the Password in 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 new password newpassword> mysql> For details, refer to: script house
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 bjtdeyx