データベース - MySQL - アカウント作成 about training HOT 5 CLOSED

mysql> create user 'user1'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> create user 'user2'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> create user 'user3'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on utfDB.* to 'user1'@localhost identified by 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select on utfDB.* to 'user2'@localhost identified by 'password';  
Query OK, 0 rows affected (0.00 sec)

mysql> grant create,alter,select,delete on utfDB.* to 'user3'@localhost identified by 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> create user 'user1'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> create user 'user2'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> create user 'user3'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> select user, host, password from mysql.user;
+---------+-----------------+-------------------------------------------+
| user    | host            | password                                  |
+---------+-----------------+-------------------------------------------+
| root    | localhost       |                                           |
| root    | ip-***-**-*-*** |                                           |
| root    | ***.*.*.*       |                                           |
| root    | ::1             |                                           |
|         | localhost       |                                           |
|         | ip-***-**-*-*** |                                           |
| thori   | ***-**-*-***    | password |
| issue24 | ip-***-**-*-*** | password |
| user1   | localhost       | password |
| user2   | localhost       | password |
| user3   | localhost       | password|
+---------+-----------------+-------------------------------------------+

mysql> grant all on *.* to 'user1'@localhost identified by 'password';
Query OK, 0 rows affected (0.01 sec)

mysql> show grants for user1@localhost
    -> ;
+-----------------------------------------------------------------------------------------------------------------------+
| Grants for user1@localhost                                                                                            |
+-----------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'user1'@'localhost' IDENTIFIED BY PASSWORD 'password' |
| GRANT ALL PRIVILEGES ON `utfDB`.* TO 'user1'@'localhost'                                                              |
+-----------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> grant select on utfDB.* to 'user2'@localhost identified by 'password';  
Query OK, 0 rows affected (0.00 sec)

mysql> show grants for user2@localhost;
+--------------------------------------------------------------------------------------------------------------+
| Grants for user2@localhost                                                                                   |
+--------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user2'@'localhost' IDENTIFIED BY PASSWORD 'password' |
| GRANT SELECT ON `utfDB`.* TO 'user2'@'localhost'                                                             |
+--------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> grant create,alter,select,delete on utfDB.* to 'user3'@localhost identified by 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> show grants for user3@localhost;
+--------------------------------------------------------------------------------------------------------------+
| Grants for user3@localhost                                                                                   |
+--------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user3'@'localhost' IDENTIFIED BY PASSWORD 'password' |
| GRANT SELECT, DELETE, CREATE, ALTER ON `utfDB`.* TO 'user3'@'localhost'                                      |
+--------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)