Solution to the problem that Linux VPS cannot connect to the MYSQL database

Snail was just tossing about the inability to provide comment email reminder functions in WordPress. The problem has not been solved, but some problems have been encountered. I use this article to sort out the problems I encountered and I don’t know how to name this blog post. Because WordPress cannot connect to the database during the upgrade and installation component process, I will use this title for now.

The problem is this. I saw an article on the Internet saying that sendmail was not installed. Since I was using debian, I was going to use apt-get install sendmail-bin and apt-get install sendmail to install the components. Then it was said Can achieve the effect of sending email reminders. But I got an "apt-get isntall" error message during the installation process, so I looked for information on the Internet and said that "apt-get –fix-broken install" can solve the problem.

The problem arises here. First of all, Snail wants to explain that I am not very clear about the so-called commands above. I just wanted to follow the tutorial. Unexpectedly, a prompt of Snail blog database connection error appeared at this time, and then When I originally wanted to enter phpmyadmin, I couldn't connect.

By the way, let me insert a picture. This picture appeared during the previous installation process. I don’t know what it means. It seems to mean resetting the MYSQL password?

That’s when I pressed Enter, and then I couldn’t connect to the database. When I restarted the mysql database\\"/etc/init.d/mysql restart\\", an error message like this appeared\\"Checking for corrupt, not cleanly closed and upgrade needing tables\\".

Maybe there is a version compatibility issue with the database? I'll try to repair it first.

myisamchk /var/lib/mysql/mysql/*.MYImyisamchk --recover /var/lib/mysql/mysql/*.MYI

Use the above two commands to check the database and repair all tables. Then the problem can be solved.

In summary, it’s all my fault first. I didn't use the experimental VPS for testing before using it in actual combat. Fortunately, the problem was solved, otherwise I don't know if I would have to reinstall the system. In the future, you still need to test the VPS first and then use it. Even if you write tutorials in the future, you cannot use live targets directly. terrible.

Recommended site search: server rental US high defense, network registration, mainland China proxy ip, Hong Kong server recommendation, foreign free website server, buy server high defense, Hong Kong space, independent ip host, telecommunications ip agent, foreign domain name application< /p>