MySQL remote client in Linux cannot connect _ MySQL

The MySQL remote client in Linux cannot be connected. Prerequisites:It should be stated in advance that this is a security benefit. You cannot remotely log on to the initialized MySQL instance. To achieve logon, we strongly recommend that you create a user with a lower permission to log on remotely. Direct use of root users for remote logon poses a great risk. The database may be dropped by hackers every minute.

First, modify the/etc/mysql/my. cnf file. Comment out bind-address = 127.0.0.1. Unbind an address (or bind a fixed address. However, all broadband Internet addresses are randomly allocated and fixed ip addresses are not feasible ).

Then, authorize a user to log on remotely. Execute the following two sentences.

Grant all PRIVILEGES on *. * to user1 @ '%' identified by '000000' with grant option; flush privileges;

Restart the mysql service. Service mysql restart.