Set the remote access corner after MySQL installation is complete

First, the method:

Log on to MySQL to install the MySQL machine,

Perform:

GRANT  All Privileges  on *. *  to ' Root '@ '%' by'password001! '  with GRANT OPTION;

Refresh permissions:

FLUSH Privileges

Second, the method:

Refer to the following: http://www.cnblogs.com/hyzhou/archive/2011/12/06/2278236.html

Method one, log in to MySQL locally, change the "MySQL" Database in the "User"Host" in the table, change "localhost" to "%"#mysql-U root-Prootmysql> UseMysql;mysql>Update User SetHost= '%' where User = 'Root'; MySQL>SelectHostUser  from User; method two, direct authorization (recommended) to use the root user from any host, password: youpassword (your root password) to connect to the MySQL server: # mysql-U root-proot MySQL>GRANT  All Privileges  on *.*  to 'Root'@'%'Identified by 'Youpassword'  with GRANT OPTIONafter the operation, remember to perform the following command refresh Permissions flushPrivileges 

Set the remote access corner after MySQL installation is complete