Linux Learning record-------MySQL authorized remote connection

Linux to turn on MySQL remote connection setup steps.

MySQL default root user only local access, cannot remotely connect to manage MySQL database, then how to open MySQL remote connection under Linux?

The setup steps are as follows:

1. Log in to MySQL

2. Execute command authorization: Grant all privileges on * * to 'user'@ '%' identified by 'password' with GRANT OPTION;

User: Username

%: Represents all IPs, can be replaced by specified IP,

Password: password

The user is authorized to login on the specified IP password password

3. Flush privileges to make authorization effective

------------------can complete remote connection, pro-test effective!

Linux Learning record-------MySQL authorized remote connection