登录mysql
[root@dbserver bin]# ./mysql -u root -p
选数据库
mysql> use mysql
查看权限
mysql> mysql> user,host,grant_priv from user;
+---------------+-----------+------------+
| user | host | grant_priv |
+---------------+-----------+------------+
| root | localhost | Y |
| mysql.session | localhost | N |
| mysql.sys | localhost | N |
| root | % | N |
| zhoufei | % | N |
| lsj | % | N |
+---------------+-----------+------------+
6 rows in set (0.00 sec)
修改权限
mysql> update user set grant_priv='Y'
-> where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 2 Changed: 1 Warnings: 0
mysql> flush privileges
-> ;
Query OK, 0 rows affected (0.03 sec)
结果
mysql> select user,host,grant_priv from user;
+---------------+-----------+------------+
| user | host | grant_priv |
+---------------+-----------+------------+
| root | localhost | Y |
| mysql.session | localhost | N |
| mysql.sys | localhost | N |
| root | % | Y |
| zhoufei | % | N |
| lsj | % | N |
+---------------+-----------+------------+
6 rows in set (0.00 sec)
查看
现在就能给用户赋予权限了