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

This article mainly introduces how to set up Mysql to allow external network access, which has a certain reference value, and friends who need it can refer to it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Mysql allows the public network to access the settings: first open mysql to enter the password and enter [use mysql]; then create a host and authorize the user; finally, connect to the mysql server with the user root and password pwd.

Mysql allows public network to access settings:

1. Open mysql.exe (MySQL Command Line Client) and enter the password

2. Input: use mysql

3. Query host input: select user,host from user

4. Create a host (skip this step if there is a host value of "%")

If there is no host value of "%", execute the following two sentences:

Mysql > update user set host='%' where user='root';mysql > flush privileges

5. Authorized users

(1) any host connects to the mysql server with user root and password pwd

Mysql > GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' pwd' WITH GRANT OPTION;mysql > flush privileges

(2) specify a host with an IP (such as 192.168.1.100) to connect to the mysql server with user tuser and password tpwd

Mysql > GRANT ALL PRIVILEGES ON *. * TO 'tuser'@'192.168.1.100' IDENTIFIED BY' tpwd' WITH GRANT OPTION; mysql > flush privileges; Thank you for reading this article carefully. I hope it will be helpful for everyone to share how to set up Mysql to allow external network access. At the same time, I also hope you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you 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.