Several ways to allow MySQL remote access in Fedora

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

Mysql>use MySQL;

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