mysql> use mysql;
mysql> select Host,User,Password from user;
ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
mysql> select Host,User from user;
+-----------+---------------+
| Host | User |
+-----------+---------------+
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+---------------+
#Host主机,User用户
mysql> grant all privileges on *.* to root@'%' identified by "你的mysql密码";
Query OK, 0 rows affected, 1 warning (0.00 sec)
#%代表所有主机,也可以写ip地址
mysql> flush privileges; #重新加载权限数据
Query OK, 0 rows affected (0.00 sec)