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.