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

This article is to share with you about the solutions that can not be accessed by the mysql external network. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The solution that cannot be accessed by the mysql public network: first enter the mysql database and query the user; then execute [update user set host='%' where user = 'root';] and execute the refresh permission [flush privileges].

Solutions that cannot be accessed through the mysql public network:

There may be times when you encounter accessing the project's database through the ip address, but the access fails.

Now here's a solution:

# enter mysql database USE mysql;# to query user SELECT HOST,USER,PASSWORD FROM USER

You can see that if user is root,host and localhost

Indicates that mysql only allows local connections, so the external network and local software clients cannot connect.

# Adjustment method: # execution: update user set host='%' where user = 'root';# perform refresh permission: flush privileges

You can test the external network connection to the mysql server.

Thank you for reading! This is the end of the article on "Solutions that cannot be accessed by mysql". I hope the above content can be of some help to you, so that you can 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.