Solve the problem that other MySQL machines cannot be connected

To solve the problem that other MySQL machines cannot connect to mysql, we recently encountered various problems during MySQL configuration. Let's summarize them. After installing www.2cto.com mysql, the local machine can be connected, but other machines cannot be connected because of the following reasons: 1. permission problems: grant can be used to assign permissions to a user, for example, for localhost/Some IP addresses, you can search for "mysql grant". There are a lot of materials, so there is no firewall problem 2 here. The RHEL system firewall is enabled by default during installation, so that other machines will be denied to connect to this mysql instance. The simplest way is to disable the firewall. (Switch to the root user, enter setup, enter the server configuration interface, select "Firewall configuration", remove the asterisks of Firewall: Enabled, save, and exit) 3 bind an ip address. For mysql installed on Ubuntu server. the cnf configuration file contains a bind ip option. If the bind ip address is 127.0.0.1 or the ip address here is different from the ip address of your current machine, mysql cannot be connected by other machines, the solution is to comment out the bind ip line or write the ip address correctly. > Mysql-u username-p mysql> grant all privileges on *. * TO 'username' @ '%' identified by 'xxxxx' with grant option; Query OK, 0 rows affected (0.01 sec) mysql>