Closed fr-sato closed 10 years ago
本課題は16:25開始、工数見積2時間で行います。 よろしくお願い致します。
GRANT ALL PRIVILEGES ON *.* TO (username)@(hostname) IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON *.* TO user01@localhost IDENTIFIED BY '****';
Query OK, 0 rows affected (0.03 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.47 sec)
mysql> show grants for user01@localhost;
+------------------------------------------------------------------------------------------------------------------------+
| Grants for user01@localhost |
+------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'user01'@'localhost' IDENTIFIED BY PASSWORD '****' |
+------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
GRANT SELECT ON (DBname).* TO (username)@(hostname) IDENTIFIED BY 'password';
mysql> GRANT SELECT ON mysql_test.* TO user02@localhost IDENTIFIED BY '****';
Query OK, 0 rows affected (0.04 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for user02@localhost;
+---------------------------------------------------------------------------------------------------------------+
| Grants for user02@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user02'@'localhost' IDENTIFIED BY PASSWORD '****' |
| GRANT SELECT ON `mysql_test`.* TO 'user02'@'localhost' |
+---------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
GRANT CREATE, ALTER, SELECT,DELETE ON (DBname).* TO (username)@(hostname) IDENTIFIED BY 'password';
mysql> GRANT CREATE, ALTER, SELECT,DELETE ON mysql_test.* TO user03@localhost IDENTIFIED BY '****';
Query OK, 0 rows affected (0.01 sec)
mysql> show grants for user03@localhost;
+---------------------------------------------------------------------------------------------------------------+
| Grants for user03@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user03'@'localhost' IDENTIFIED BY PASSWORD '****' |
| GRANT SELECT, DELETE, CREATE, ALTER ON `mysql_test`.* TO 'user03'@'localhost' |
+---------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
確認しました。おkです。
■目的
SQLを用いてアカウントを作成します。
■課題
以下の権限を持つアカウントをSQLを用いて作成して下さい。
アカウント名、パスワードはお任せしますがアカウント名は分かり易い、パスワードは複雑性のあるものにして下さい。
作成の際に発行したコマンドとその結果はIssueに記述して下さい。(パスワードは****と伏せて記述して下さい)