20180601_ setting up MySQL allows external IP connections

Set up MySQL to allow external IP connections

After the MySQL installation is successful, the MySQL database can be accessed locally by default. If other computers need access to the MySQL database, they need to be granted access.

Operation Steps:

--Using MySQL Database Use MySQL;

--See if you only allow native access to MySQL Select User,host from user;

--Authorization to specify IP access to MySQL --Grant all privileges on * * to ' username ' @ ' IP address ' identified by ' password ' with GRANT OPTION; --Flush privileges;

--Authorize all IP access to MySQL GRANT all privileges on * * to ' root ' @ '% ' identified by ' root ' with GRANT OPTION; Flush privileges;

20180601_ setting up MySQL allows external IP connections