Setup Commands for connecting all machines in the LAN to the MySQL database

We wantLanAll machines in can be connectedMySQL databaseFirst, enable the remote connection function for MySQL. On the MySQL server, run the following command on the MySQL command line:

The command code is as follows:

 
 


  
  
Grant all privileges on *. * to root @ "%" identified by 'abc' with grant option;

  
  
 

  
  
Flush privileges;

 
 

The above two lines of code mean to grant all permissions to the user who connects from any IP address as root and the password as abc. "%" Indicates any IP address. If you want to set it to a specific value, you can also set it to a specific value.

After executing the above Code, all machines in the LAN can access the machine as root: abc. This article introduces you here. Thank you for your support!