Shulou(Shulou.com)05/31 Report--

This article will explain in detail what to do about the server5.5 connection in mysql. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Mysql can not be connected to the solution, for your reference, the details are as follows

I used it well yesterday, but suddenly I couldn't connect to the mysql database the next day and reported an error:

After thinking about it carefully, it is likely that the reason is the table corruption caused by inadvertently deleting some data information from mysql's own table, as well as the oracle before.

So don't delete the table information of the system casually.

Enter the service, find mysql, find that the service has been stopped, restart the service, and find that it cannot be restarted, as follows

Unable to restart report 1067

And it is not allowed to enter msyql in the dos command.

Then I went to the transaction manager to check the system log information and found that there was an error in mysql, as follows

Two of the wrong messages are

1. Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

2 、 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

Many solutions found on the Internet are useless, so I'm going to reinstall mysql, but I'm thinking about what to do with the previous database, and I also checked how to import the previous database data, but it's not easy to do it, and I can't find a way, but when I'm ready to reinstall, I have a solution, as follows:

1. Double-click the original installation package and select repair to repair the service.

2. After the repair was completed, a miracle happened that the mysql service was running.

3. Open navicat to connect at this time, and an error is displayed.

Access denied for user 'root'@'localhost' (using password: YES)

The solution to this is everywhere on the Internet, and the editor provides you with a solution:

In the past two days, when I was developing a Web project in MyEclipse, there was a problem connecting to the MYSQL database: Access denied for user 'root'@'localhost' (using password:YES).

After searching for information, it is found that the root account does not open remote access by default, so you need to modify the relevant permissions.

Solution:

1. Open the my.ini file in the MySQL directory, add a line "skip-grant-tables" at the end of the file, save and close the file. (WIN7 is installed by default, and my.ini is installed at C:\ ProgramData\ MySQL\ MySQL Server 5.6)

two。 Restart the MySQL service.

3. Enter the BIN directory of MySQL through the command line, enter "mysql-u root-p" (no password), prompt to enter the password, and enter Enter directly to enter the database. (WIN7 is installed by default, and the BIN directory is C:\ Program Files\ MySQL\ MySQL Server 5.6\ bin)

4. Execute "use mysql;" and use the mysql database.

5. Execute "update user set password=PASSWORD (" 123456 ") where user='root';" (change the password of root)

6. Open the my.ini file in the MySQL directory, delete the "skip-grant-tables" on the last line, save and close the file.

7. Restart the MySQL service.

8. Enter "mysql-u root-p 123456" on the command line to successfully connect to the database.

After completing the above steps, MyEclipse can also successfully connect to MySQL.

Thanks to this netizen for the solution.

At this point, the problem is solved, and I feel much better.

This is the end of the article on "what to do if the server5.5 connection is not connected in mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

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.