MySQL データベース作成とユーザー作成

$ mysql -u root -p
Enter password:

mysql> CREATE DATABASE fuel_db CHARACTER SET utf8;
Query OK, 1 row affected (0.02 sec)

mysql> GRANT ALL PRIVILEGES ON fuel_db.* TO 'fuel_app'@'localhost' \
 IDENTIFIED BY 'password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.09 sec)

mysql> SELECT host, user, password FROM mysql.user;
+-----------+-----------+-------------------------------------------+
| host      | user      | password                                  |
+-----------+-----------+-------------------------------------------+
| localhost | root      | *2F10579EC0B16D79B10EC6661A6832A4BE294520 |
| 127.0.0.1 | root      | *2F10579EC0B16D79B10EC6661A6832A4BE294520 |
| ::1       | root      | *2F10579EC0B16D79B10EC6661A6832A4BE294520 |
| localhost | fuel_app  | *57A57ED64FC0198B00320AFDEFC80EDC5B447D93 |
+-----------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)

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