The MySQL database cannot be accessed remotely by a workaround

What do I do if the MySQL database does not allow remote access?

Here are two ways to do this:

1. Table-changing method

MySQL account does not allow remote login, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, the "MySQL" Database in the "User" table "host", from "localhost" renamed "%" can be.

 #mysql - u root - ppwd // mysql root password #mysql  >  Span style= "color: #0000ff;" >use   MySQL; #mysql  >  update  user  set  host =   " %    

2. Authorization Law

If you want users to use USERPWD to connect to the MySQL server from any host:

 #mysql >  grant  all  privileges  on  *. *  to    user   " @"  %    Identified by   userpwd    with  grant  option ; 
 #mysql >flush rivileges; 

 #mysql >  grant  all  privileges  on  *. *  to    user   " @"  192.168.32.220   " identified by   '  userpwd   '  

　　

The MySQL database cannot be accessed remotely by a workaround