Mysql settings allow external access

Configure the password of an external access account
Log on to mysql locally
Java code mysql-uroot-p execute Java code grant all on *. * to rails @ 'client _ ip' identified by 'Password' with grant option; example: all LAN clients can access the Java code grant all on *. * to root @ '2017. 168.0.% 'identified by 'root' with grant option; example: Set the user boyuJava code grant all on boyu for the boyu database. * to boyu @ '2017. 168.0.% 'identified by 'p4ssword'; app_server_id sets the IP address of the APP server to allow external mysql access to/etc/mysql/my. cnf comment to the following line of Java code bind-address = 127.0.0.1 restart mysql-serverJava code sudo service mysql restart author clark1231