パスワードが変更されたことを確認する。
mysql > SELECT host, user, password FROM mysql.user;
+---------------------------+------+-------------------------------------------+
| host | user | password |
+---------------------------+------+-------------------------------------------+
| localhost | root | *750AD1B93907B52149E5713DF132BDC97B162D7E |
| 127.0.0.1 | root | *750AD1B93907B52149E5713DF132BDC97B162D7E |
| ::1 | root | *750AD1B93907B52149E5713DF132BDC97B162D7E |
| localhost | | |
+---------------------------+------+-------------------------------------------+
4 rows in set (0.00 sec)
- ユーザーを作成する。<code>
mysql > GRANT ALL PRIVILEGES ON tomoyan_db.* TO 'tomoyan'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
- ユーザーが作成されていることを確認する。<code.
mysql > SELECT host, user, password FROM mysql.user WHERE user='tomoyan';
+-----------+---------+-------------------------------------------+
| host | user | password |
+-----------+---------+-------------------------------------------+
| localhost | tomoyan | *717B4CC972A8740B718968BDC83A9EEC27086FA4 |
+-----------+---------+-------------------------------------------+
1 row in set (0.00 sec)