### 1.连接数据库
~~~
mysql -uroot -p密码
~~~
### 2.use mysql
~~~
use mysql
select host,user from user;
~~~
+-----------+-----------+
| host | user |
+-----------+-----------+
| localhost | mysql.sys |
| localhost | root |
+-----------+-----------+
### 3-1 将root的host设置成本地IP则实现本机登录
~~~
GRANT ALL PRIVILEGES ON *.* TO 'root'@'IP地址' IDENTIFIED BY '密码'
例如:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'144.0.182.180' IDENTIFIED BY '12345678'
~~~
### 3-2 将root的host设置成%则实现任何电脑都可远登录
~~~
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345678'
~~~
~~~
flush privileges;
~~~