Create a MySQL Database and User

Log in to your hosting account and locate the MySQL Databases icon.

the mysql databases icon

Give your database a name. Make note of the name.

Click create database.

the create new database form

Now to create a new user. For security purposes it’s best to create a new MySQL user for each WordPress database you create.

To create a new user insert your username and password.

the create new mysql database form

Click create user.

Make note of the username and password.

Finally, assign this user to your database. Look for the section that says “Add User to Database” and select the user and the database. Click “Add”. Make sure you assign all privileges to the user.

the MySQL privileges menu