MySQL Remote access permission

1. Change the Table method

X:\>mysql-u Root-pvmware

mysql> use MySQL;

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

Mysql> Select Host, user from user;

mysql> flush Privileges;

Note:mysql> flush privileges; Make the changes effective.

2. Authorization Law:

X:\>mysql-u Root-pvmware

mysql> use MySQL;

Mysql> Grant all privileges on * * to ' myuser ' @ '% ' identified by ' MyPassword ' with GRANT OPTION;

Any data table in any database of this instance can be accessed by any host, provided the username is: myuser

The password is mypassword.

Note: Flush privileges; will only take effect.

This article is from the "Record Drip" blog, please be sure to keep this source http://zhuximing.blog.51cto.com/8197583/1704014

MySQL Remote access permission