How to create and modify a database in WHM/cPanel server

To create Database

Here we will create a sample database named example_testdb. Now Click Create Database.

We have successfully created the database example_testdb.

To create MySQL user

To access the database we need to create MySQL user. Here, to access the example_testdb which is created, we have created a MySQL user called example_user.

You can enter the password manually, for security reasons we will generate the encrypted password using the password generator.

Now Click Create user.

Alert: You have successfully created MySQL user named example_user

To add user to specific database

Select the user to be added to the database and select the database and click add.

To manage user privileges

User: example_user
Database: example_testdb

For instance, Here we have given all privileges. You can manage the user privileges according to your requirement for the specific account.

Now the user can access the database with full privileges.

Click Make changes.

Now you have successfully given the requested privileges on the database " example_testdb" to the user " example_user"

Now you can overview the created database and the privileged users.

To change current database name

You can view the current database in the current database section. Here you can rename the database by selecting the rename option. A popup window appears to rename the database.

Important: It is potentially dangerous operation to rename MySQL database. You may need to take backup this database before renaming it.

You can enter the new database name that you prefer and click proceed. Once you click proceed, the database will be renamed and the page will now reload.

To rename MySQL user name

Go to current user section and select username to modify. Click rename. Popup screen appears

You can enter a new user name and click Proceed to change and the page will be reloaded.