Allow MySQL to remotely access _ MySQL-mysql tutorial

Allow MySQL to remotely access bitsCN.com

By default, MySQL only supports local access. for remote access, execute the following command in the path of mysql.exe
Mysql> grant all privileges on *. * TO 'root' @ '%' identified by 'rootpasswd' with grant option; /// enter this command and press enter to allow all hosts that use the root user and enter the rootpasswd password to log on to the mysql Server. If '%' is changed to '10. 1.1.1 'only hosts of 10.1.1.1 can log on.
Query OK, 0 rows affected (0.07 sec)
In this way, you can configure the MySQL remote access policy.

BitsCN.com