The MySQL remote client in Linux cannot be connected.

Prerequisites: we should make a statement in advance to ensure security. 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.

In Linux, MySQL cannot be remotely connected.

This article permanently updates the link address: