MySQL quickly creates databases and users

Use the shell to run MySQL statements to quickly and easily create MySQL users and databases.

The CREATE statement is given below, where the dollar sign indicates a command prompt:

$ mysql-u adminusername-penter password:welcome to the MySQL monitor.  Commands End With; or \g.your MySQL connection ID is 5340 to server version:3.23.54 Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the buffer. mysql> CREATE DATABASE DatabaseName; Query OK, 1 row Affected (0.00 sec) mysql> GRANT all privileges on databasename.* to "wordpressusername" @ "hostname" IDE Ntified by "password"; Query OK, 0 rows Affected (0.00 sec)  

MySQL quickly creates databases and users