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

This article mainly explains "what do you need to pay attention to in MYSQL installation and maintenance", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn what you need to pay attention to in MYSQL installation and maintenance.

When installing, first use rpm-aq | grep mysql | xargs rpm-e-- allmatch-- nodeps

Delete the Mysql that comes with the system, and then need ps-ef | grep mysql to see if there is a running mysql process, and then kill. You need to check whether / etc/my.cnf already exists, and if so, delete it, otherwise the final installation may report a grant privillege table error. This problem does not seem to be found on mysql 5, all reported by mysql 4.0.27.

This installation also encountered an evil thing, when the server was rebooted. When I got up, I found that ssh could not log in, but luckily there was rsh. Log in to start the ssh service discovery:

@ @ @

WARNING: UNPROTECTED PRIVATE KEY FILE! @

@ @ @

Permissions 0775 for'/ usr/local/etc/ssh_host_dsa_key' are too open.

It is recommended that your private key files are NOT accessible by others.

This private key will be ignored.

Bad permissions: ignore key: / usr/local/etc/ssh_host_dsa_key

Could not load host key: / usr/local/etc/ssh_host_dsa_key

Disabling protocol version 2. Could not load host key

Sshd: no hostkeys available-- exiting.

The solution is:

Chmod 600 / usr/local/etc/ssh_host_rsa_key

/ etc/init.d/sshd start

It seems to be a security issue of file permissions, which is really interesting.

After installing mysql, you also need to configure / etc/my.cnf, firewall policy, and .my.cnf to allow root to log in to mysql without a password. Configure. Mysql_history to ensure historical records.

Pay attention to the above aspects, mysql can basically be used.

At this point, I believe that everyone on the "MYSQL installation and maintenance need to pay attention to what" have a deeper understanding, might as well to the actual operation of it! 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.