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

1）进入mysql终端

http://istester.com/mysql/176.html

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、用客户端，连接看看

参考文章  http://istester.com/mysql/401.html

7、搞定