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

The following is mainly to bring you MySQL database password after the flash back problem solution, I hope MySQL database password after the flash back problem solution can bring you practical use, this is also the main purpose of my editing this article. Okay, no more nonsense, let's go straight to the following.

1 Case Description

Recently, I have been demonstrating basic functions with MySQL database, but a problem suddenly appeared in the past two days, that is, after starting MySQL server and entering password, there is a flashback phenomenon. After that, I searched the Internet and found that this problem is very common. Most of the reasons may be that when we use security software, we accidentally close MySQL service. In addition, if MySQL service has been started, but there is still a flashback phenomenon, then there may be a problem with MySQL configuration. In this article, we will teach you how to enter the MySQL database password and then flash back.

2 solutions

When the above problems occur, we first have to check whether the MySQL service is started. If the MySQL service is not started, then in most cases, when we manually start the MySQL service, the above problems can be solved; if the MySQL service has been started, but there is still a flashback phenomenon, this requires us to modify the relevant configuration!

Next, follow the steps below (click in turn) to enter the service management page:

My computer;

Management;

Services and applications;

Services.

As shown above, here we can check the status of MySQL services!

Case 1: MySQL service is not started

Cough cough, this is easy, right click or click the button shown in the red arrow below to start MySQL service.

After clicking Start, let's restart MySQL server, enter password, and test:

As shown above, our problem has obviously been solved.

Case 2: MySQL service is started

In the case of MySQL service startup, there is a flashback problem, which may be a problem with MySQL configuration. Further, there may be a problem with the my.ini file in C:\ProgramFiles\MySQL\MySQL Server X.X (under the installation path). For this question:

Method 1: First enter cmd into MySQL installation directory, then enter bin directory, enter mysqld-nt--skip-grant-tables command. Then, do not close this cmd window, open another window to log in MySQL or directly open MySQL CommandLine Client and enter the correct password.

Method 2: Find out how to run win+R. In this DOS form, cd to the bin directory of MySQL Server X.X, and then enter mysql -u root -p command, and then enter the password.

Method 3: If the login prompts mysql: unknown variable 'character-set-server= gbk', the solution: modify the my.ini file under the MySQL installation directory, comment or delete the default-character-set=gbk inside, and restart the MySQL service in the service.

For the above solution to the flashback problem after entering the password for MySQL database, do you think it is very helpful? If you need to know more, please continue to pay attention to our industry information, I believe you will like these contents.

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.