mysql开启远程登录方法介绍

mysql -u root -p
mysql> use mysql;
mysql> grant all privileges  on *.* to root@’%’ identified by “root”;
mysql> select host,user,password from user;

+————–+——+——————————————-+
| host         | user | password                                  |
+————–+——+——————————————-+
| localhost    | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| 192.168.1.12 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| %            | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+————–+——+——————————————-+
3 rows in set (0.00 sec)

mysql> flush privileges;

mysql> GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@'192.168.1.3′ IDENTIFIED BY 'mypassword’ WITH GRANT OPTION;