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、搞定