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、