MySQL 8.0.29でロールを作成する方法

2022年5月7日

環境
Ubuntu 22.04 LTS
MySQL 8.0.29

操作方法
1.ロールを作成します

mysql> CREATE ROLE 'cft';

Query OK, 0 rows affected (0.23 sec)

mysql> CREATE ROLE 'cft'; Query OK, 0 rows affected (0.23 sec)

mysql> CREATE ROLE 'cft';
Query OK, 0 rows affected (0.23 sec)

2.ロールに権限付与します

mysql> GRANT DELETE,INSERT,SELECT,UPDATE ON testdb.* TO 'cft';

Query OK, 0 rows affected (0.09 sec)

mysql> GRANT DELETE,INSERT,SELECT,UPDATE ON testdb.* TO 'cft'; Query OK, 0 rows affected (0.09 sec)

mysql> GRANT DELETE,INSERT,SELECT,UPDATE ON testdb.* TO 'cft';
Query OK, 0 rows affected (0.09 sec)

3.ユーザーを作成します

mysql> CREATE USER testuser@'%' IDENTIFIED BY 'Pass2022@#ord';

Query OK, 0 rows affected (0.06 sec)

mysql> CREATE USER testuser@'%' IDENTIFIED BY 'Pass2022@#ord'; Query OK, 0 rows affected (0.06 sec)

mysql> CREATE USER testuser@'%' IDENTIFIED BY 'Pass2022@#ord';
Query OK, 0 rows affected (0.06 sec)

4. ユーザーにロール権限を付与します

mysql> GRANT 'cft' to testuser@'%';

Query OK, 0 rows affected (0.30 sec)

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.00 sec)

mysql> GRANT 'cft' to testuser@'%'; Query OK, 0 rows affected (0.30 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec)

mysql> GRANT 'cft' to testuser@'%';
Query OK, 0 rows affected (0.30 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

Posted by arkgame