mysql> CREATE DATABASE wordpress;
Query OK, 1 row affected (0.00 sec)

mysql> CREATE USER 'wordpress'@'172.31.%' IDENTIFIED BY 'z62Vtik5';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL ON wordpress.* to 'wordpress'@'172.31.%';
Query OK, 0 rows affected (0.01 sec)

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

[root@localhost ~]# mysql --user=wordpress --password=z62Vtik5 --host=mysql.localhost wordpress