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

MySQL how to repair configuration files, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Errors and solutions

Unable to connect to the remote server: first verify the settings of the DNA configuration and confirm the IP address of the local server. Ensure that the remote MySQL server is active and verify the firewall configuration of the remote and local servers.

The SSH port is incorrect: first confirm the SSH port on the remote MySQL server, and then enter the exact SSH port.

Invalid SSH credentials: ensure and verify that the username and password of the remote MySQL server are correct.

When the hostname is not allowed to connect to the MySQL server: user access is granted through # mysql # mysql mysql-snip-mysql > CREATE USER 'user'@'hostname' IDENTIFIED BY' password'; Query OK, 0 rows affected (0.00 sec) mysql > GRANT ALL PRIVILEGES ON *. * TO 'user'@'hostname' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec)

Lose connection to the server: verify and verify that the DNA configuration settings are valid and the latest version.

DNS reverse warning

Before setting up a remote MySQL server, make sure that the remote server can resolve the hostname of the server to your IP address. Log in to the remote server through the SSH port to confirm this feature, and then follow the host command:

Root@server [~] # host 208.77.188.166

166.188.77.208. In-addr.arpa domain name pointer www.example.com

Root @ server [~] #, make sure to add the hostname entry in the / etc / hosts file of the remote server in case there is no reverse DNS entry configured for the hostname.

MySQL root password

For changing the MySQL root password in the WHM interface, you can use the interface itself, WHM > > Home > > SQL services > > MySQL root password. If you are using a MySQL root server, select the remote server as the default server and make sure that the passwords for both the local and remote servers are entered correctly.

After reading the above, have you mastered how to repair the configuration file in MySQL? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.