1、进入mysql

2、使用某个数据库

use mysql；

3、查看已有的用户

select user from user;

4、创建用户

mysql> create user benben identified by '123456';

Query OK, 0 rows affected (0.01 sec)

mysql> select user from user;

+------------------+

| user            |

+------------------+

| benben          |

| mysql.infoschema |

| mysql.session    |

| mysql.sys        |

| root            |

+------------------+

5 rows in set (0.00 sec)

5、用新建的用户登录

6、查看数据库，只有一个库

show databases;

7、给新增的用户授予权限

8.0以后的版本

grant all privileges on mysql.* to benben@'%' with grant option;

Query OK, 0 rows affected (0.01 sec)

8.0以前的版本

grant privilegesCode on dbName.tableName to username@host identified by "password";

grant all privileges on istester.* to benben@'%' identified by '123456';

grant select,update on istester.* to benben@'%' identified by '123456';

查看权限授予情况