"Linux" install MySQL set remote access permission

Recently re-installed the cloud host, but also install a variety of things, one of the need to set up MySQL permissions

For learning convenience, I installed on my own cloud host is the Phpstudy integration environment, so to enter the MySQL console can not directly use "Mysql-u Root-ppassword", the following is the command line I changed permissions

I'm using a table-changing method.

/phpstudy/mysql/bin/ mysql-u root-p// Access console usemysql; MySQL>update user set host = '% ' where user = ' root ';    //  mysql>flush  privileges; MySQL // check that '% ' is inserted into the database MySQL>quit

A row with the "%" host value succeeds and the database can be accessed remotely

Linux installs remote access permissions for MySQL setup