MySQL connection statement in LAN

We all know the statements used to connect to MySQL in the LAN are jdbc: MySQL: // localhost: 3306/database, but when you want to connect to mysql on other machines, it is useless to change the localhost of the preceding statement to the corresponding ip address, because the connection permission opened by Mysql is localhost by default. When you need to connect to other machines, mySQL on other machines must have the permission to enable ip connections other than local.
To connect to MySQL in a LAN, you must first enable the remote connection function for MySQL. on the MySQL server, run the following command on the MySQL command line: www.2cto.com SQL code grant all privileges on *. * to root @ "%" identified by '000000' with grant option; flush privileges; it means to give the user name connected from any IP address as root, all permissions are granted to users with a password of 123. "%" Indicates any IP address. If you want to set it to a specific value, you can also set it to a specific value. After the statement is executed, the user can access the host from another machine with root: 123.