Create Databases and add Users in cPanel > MySQL Databases

Although most application installers like Wordpress in Installatron create a database automatically, there may be times when you need to create one for development, testing or troubleshooting. You can create databases in phpMyAdmin or using a commands in a Terminal, or by going navigating to cPanel > Databases > MySQL Databases. This article covers how to create databases and add users using the cPanel MySQL interface.

Create New Database

cPanel-Databases-MySQL.png

To create a database from cPanel > Databases > MySQL Databases, click the link to enter that interface.

 

cPanel-MySQL-createDB.png

Create New Database: enter a name for the database. The username in the account is automatically added as a prefix for example in the format (username_)mydatabase. Click Create Database to finish.

 

Add New User

Databases need an associated user with all privileges set to modify it. You can create a database user for each database. It is common practice to use the same name for the user as the database itself. Or you can have one database user that is added to several databases. The first step is to Add New User:

cPanel-MySQL-Add-New-User.png

The username again is autofilled so enter the name to match the database or something else you prefer. Use the Password Generator or enter one manually. Then click Create User. Once a database user is created, then there is another step to Add User to Database.

 

Add User to Database

cPanel-MySQL-Add-user-to-db.png

Select the desired User and Database from the dropdown menus to add them to the database. Then click Add. Then select the Privileges the user will have.

 

cPanel-MySQL-user-priveleges.png

cPanel-MySQL-user-priveleges-2.png

Select ALL PRIVILEGES or only select ones from the list. Then click Make Changes to finish.

 

More articles about Databases

 

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

Reclaim Hosting Support Hours
8:00 am - 5:00 pm ET, Monday through Friday
Submit a Ticket
Get a quick and helpful response from the pros.
Need Extra Support?
No problem, we're here to help! Talk to us about Professional Services.