success
[caibo @ localhost/]$ firewall-cmd-reload
Systemctl stops firewall d.service # stop.
Systemctl disables the firewall d.service # has been disabled.
After installing mysql, remote connection is allowed, and other servers can connect to the local database.
Whether mysql account does not allow remote connection. If you cannot connect, you can try the following methods:
Mysql -u root -p // login MySQL
Mysql & gt grants all permissions on *. * TO 'root'@'%' with GRANT option; //Any remote host can access the database.
Mysql & gt refresh permission; //An auxiliary command is required for the modification to take effect.
Mysql & gt exit//exit
You can also modify the table to realize remote:
mysql -u root -p
Mysql & gt uses MySQL
Mysql & gt updates the user set host = "%",where user = "root";
Mysql & gt selects hosts and users from users.