Several ways to allow MySQL remote access in Fedora

There are three ways to allow MySQL remote access in Fedora:
A, change the table.

mysql> usemysql;

mysql>Update user set host = '% ' where user = ' root ';

mysql>Select Host, user from user;

b, Authorization.
For example, you want to use root 123456 from any host to connect to the MySQL server.

Mysql>GRANT All privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT OPTION;
If you want to allow the user jack to connect to the MySQL server from the IP-10.10.50.127 host and use 654321 as the password

Mysql>Grant all privileges on * * to ' jack ' @ ' 10.10.50.127 ' identified by ' 654321 ' with GRANT OPTION;

mysql>FLUSH rivileges

Several ways to allow MySQL remote access in Fedora