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

This article will explain in detail how to enable remote access in MySQL. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have some understanding of the relevant knowledge after reading this article.

Implement remote connection (authorization law)

Changing the value of the host field to% means that you can log in to the mysql server as a root user on any client machine, and it is recommended to set it to% at development time.

Update user set host ='% 'where user =' root'

Change permissions to ALL PRIVILEGES

Shell > mysql-uroot-paired MySQL > grant all privileges on *. * to root@'%' identified by "root"; Query OK, 0 rows affected (0.00 sec) mysql > flush privileges;Query OK, 0 rows affected (0.00 sec)

So much for sharing about how to enable remote access in MySQL. I hope the above content can be of some help 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.