mysql命令行给用户授权_Mysql新增用户并授权（通过命令行新增数据库账号）

1)进入mysql终端

2、创建账号 istester ，密码 isTester@321

create user istester identified by 'isTester@321';

3、新建两个数据库 idoxu 和 istester

mysql> create database idoxu;

Query OK, 1 row affected (0.00 sec)

mysql> create database istester;

Query OK, 1 row affected (0.00 sec)

4、把这两个数据库，授予istester用户

授权命令格式：grant privilegesCode on dbName.tableName to username@host identified by "password";

比如 ，

把这两个数据库的所有权限，都授予给istester用户，并允许远程登录；

mysql> grant all privileges on istester.* to istester@'%' identified by 'isTester@321';

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> grant select,update on idoxu.* to istester@'%' identified by 'isTester@321';

Query OK, 0 rows affected, 1 warning (0.00 sec)

5、查看权限授予的情况

mysql> show grants for istester;

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

| Grants for istester@%                                  |

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

| GRANT USAGE ON *.* TO 'istester'@'%'                   |

| GRANT ALL PRIVILEGES ON `istester`.* TO 'istester'@'%' |

| GRANT SELECT, UPDATE ON `idoxu`.* TO 'istester'@'%'    |

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

3 rows in set (0.00 sec)

6、用客户端，连接看看

7、搞定