Shulou(Shulou.com)06/01 Report--

This article mainly introduces mysql how to solve the 1045 error, has a certain reference value, friends in need can refer to. Let's take a look at it with me.

The reason for the 1045 error in MySQL:

1. The problem follows the port.

two。 Wrong user name or password

Solution:

1. If this error occurs, you should check the port first. Because there is a problem with the port, there is no way to reset the password, or there will be this error prompt, and there is no way to reset it. At this time, check the service to see if the port is occupied by both. If it is occupied, turn off mysqla.

two。

How to reset the password:

1. Shut down the service first

two。 Then go to the folder of MySQL to find the file with the suffix .ini, and add skip-grant-tables under [mysqlld].

3. Then open the database, enter mysql-u root-p in the bin directory, and enter.

4. Then enter set password=password ("your new password") where user= "root"

5. Delete skip-grant-tables and OK.

These are the details of how mysql solved the 1045 error, and did you get anything after reading it? If you want to know more about it, welcome to the industry information!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.