Shulou(Shulou.com)06/01 Report--

This article will explain in detail what to do about mysql2003 errors in linux. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

The solution to the linux mysql2003 error: first enter the mysql directory; then open the my.cnf file, find "bind-address = 127.0.0.1", and precede it with the "#" symbol; finally, add "kip-external..." The code is fine.

Don't say much and go straight to the code.

1. Enter in the console and go to the mysql directory

Sudo su / / enter root permission cd / etc/mysql

two。 Open the my.cnf file and find bind-address = 127.0.0.1 with a # comment in front of it, as follows:

# bind-address = 127.0.0.1

3. Then add the following code; OK.

Skip-external-lockingskip-name-resolve

If you cannot find # bind-address = 127.0.0.1 in the my.cnf file, as shown in the figure:

Then go to the second path / etc/mysql/mysql.conf.d/ folder and open the mysqld.cnf file to modify it.

4. Restart the mysql service

Service mysql restart

By the way, I would like to talk about the solution to the is not allowed to connect to this MySQL server error encountered when connecting.

1. Enter the mysql-uroot-p password in the console to enter the mysql

(2. Enter use mysql; to enter the mysql database

3. Enter update user set host='%' where user='root'; to allow access through ip. Note: the method in parentheses is to allow everyone to connect, and it is easy to be hacked by others, so set the specified IP access. The specific methods are as follows:

Direct input:

GRANT ALL PRIVILEGES ON *. * TO 'root'@' to specify the IP address' IDENTIFIED BY 'set password' WITH GRANT OPTION

You can also update host to% first, and then update host to your own ip through the graphical interface (SqlYog, workbench, etc.).

4. Continue typing flush privileges; and remember that no matter which method you choose above, perform this step to update the database user permissions. Very important!

5. Then reconnect and the problem is solved.

This is the end of what to do about mysql2003 errors in linux. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it 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.