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;