使用root登录mysql
mysql -u root -p
Enter password: ****
若提示 ‘mysql’不是内部或外部命令。说明没有配置环境变量,配置 path 变量添加 “……\mysq\MYSQL Server5.7\bin”
选择mysql数据库
use mysql;
查看root用户数据
select Host from user where user='root';
+-----------+
| Host |
+-----------+
| 127.0.0.1 |
| ::1 |
| localhost |
+-----------+
没有通配符的Host的数据
通过给他增加一个root用户,权限与我们之前的root一致。
grant all on *.* to root identified by 'root' with grant option;
Query OK, 0 rows affected (0.00 sec)
刷新权限
flush privileges;
Query OK, 0 rows affected (0.00 sec)
在查询一下用户表信息
select Host from user where user='root';
+-----------+
| Host |
+-----------+
| % |
| 127.0.0.1 |
| ::1 |
| localhost |
+-----------+
4 rows in set (0.00 sec)