The time conversion in SQL Drip 43-mysql

LAN connection mysql error:
ERROR 1130:host ' 192.168.0.220 ' isn't allowed to connect to this MySQL server

Workaround:

The account may not be allowed to log in remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host" item, from "localhost" to "%" or add a user as "%".

To allow all the machines on the LAN to connect to the MySQL database , start the remote connection for MySQL and execute the mysql command on the MySQL server console:

Grant all privileges on * * to [e-mail protected] "%" identified by ' ABC ' with GRANT option;
Flush privileges;

The above two lines of code means that the user named Root, which is connected from any IP address, is given all permissions by the user with the password of ABC. Where the "%" is any IP address, if you want to set a specific value can also be set to a specific value (the contents of the wildcard% increase the host/IP address, you can also directly increase the IP address).

After doing this, the MySQL server within the LAN can be accessed.

The time conversion in SQL Drip 43-mysql