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

This article mainly explains "what to do if mysql restart fails due to the modification of Linux hostname". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "what to do if mysql restart fails due to the modification of the Linux host name"!

If mysql uses a script to start, Linux modifying the host name will cause mysql to fail

Today, it was found that the hostname of the production environment had been modified.

Now check the MySQL status and report an error:

[root@db02 ~] # service mysqld status

MySQL is running but PID file could not be found [FAILED]

Stop mysql also reported an error:

[root@db02 ~] # service mysqld stop

MySQL server PID file could not be found! [FAILED]

Restarting mysql also reported an error.

If you want to restart mysql, you can manually kill the mysql process. Then start the database with service mysqld start.

If the startup is unsuccessful, you can view the newly modified hostname .err file to see the specific error.

Modifying the hostname using mysql data started by mysqld_safe does not cause a restart

At this point, I believe you have a deeper understanding of "what to do when mysql restart fails due to the modification of Linux hostname". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.