Create MySQL database

• Log into cPanel and locate Databases.
• Click MySQL Databases.

• In the New Database field, type a name for the database.
• Click Create Database.

• Click Go Back.

• The new database will appear in the Current Databases table.

Create a Database User

After creating the database, you will need to create a user and assign privileges

• Log into cPanel and locate Databases.
• Click MySQL Databases.
• Click Jump to MySQL Users in the top-left corner of the page.
• Under Add New User, enter a username.
• Enter a password in the Password field.
• For help generating a strong password, click the Generate Password button.
• Retype the password in the Password (Again) field.
• Click Create User.

Assign Privileges to Database User

• Log into cPanel and locate Databases.
• Click MySQL Databases.
• Under Add User to Database, select a user from the User drop-down menu.
• From the Database drop-down menu, select the database you wish to allow the user access to.
• Click Add.

• From the MySQL Account Maintenance screen, select the privileges you wish to grant the user or select ALL PRIVILEGES.
• Click Make Changes.