Phpstudy allow remote access to MySQL Database Setup method

This article mainly share with you phpstudy allow remote access to MySQL database Setup method, hope to help everyone.

1, first in the server through the command line (open Phpstudy interface, the lower right corner of the other menu options->mysql Tools->mysql command line)

Login mysql:mysql-u root-p Password (if MySQL initial account and password are root)

2, execute use MySQL;
3. Execute grant all privileges on * * to
root@ '% ' identified by ' password ';

4, implementation of flush privileges;

After these steps have been set up, we can use the MySQL management tools, such as NAVICAT, for connection testing, if the connection is unsuccessful, we need to open port 3306 on the security group.