Portal Home > Knowledgebase > FAQ > Customer FAQ > How do I produce a MySQL database, user, and then delete if needed?


How do I produce a MySQL database, user, and then delete if needed?




Create: If you're using any style of PHP software or keeping a group of records which require to be accessed in how, you may have to be compelled to produce a database. Below can show you ways to form a MySQL database in cpanel.

Click MySQL Databases

In the box to the proper of latest Database, please offer a reputation for the database. Please note cPanel can produce the complete name of the database as cpaneluser_databasename

Click produce Database Button

You have currently successfully add the database, you may currently have to be compelled to produce a user to access the database.


Create User: Whenever you have got any style of MySQL database, you may have to be compelled to assign a user to be ready to access the database. If you'd wish to produce a user and provides them access to the database, please do the following:

Click MySQL Databases

Scroll down till you see this Users section

Under this section and to the proper of User name, please offer a user name for a database

Please note that that full database user are cpaneluser_databaseuser

To the proper of Password, please kind the password that you'd wish to produce for this database user.

Click produce User

You have currently created a database user. you'll be able to manage it from PhpMyAdmin, found within the Databases section in cPanel.


You currently have to be compelled to offer the user privileges for your specified database.

In the drop down menu to the proper of User, please sect the user that you'd like offer privileges to.

To the proper of Database, please choose a database that you'd just like the user to own privileges to.

Under privileges please opt for what style of privileges you'd just like the user to own.

Click Add User To Database button you have got currently created a replacement database with a privileged user. you'll be able to currently input the knowledge into a php script or another script to access it domestically

You have currently simply gave a user permissions to a database.


Delete: If you're deleting a script or would love to restart a replacement database, the primary step is to delete the recent MySQL database. To do so, please do the following:

Click MySQL Databases

Under Current Databases, you may realize the names of all of your current databases.

Click Delete next to the name of the database you'd wish to delete.

You have currently deleted a MySQL Database.


Note: you'll conjointly have to be compelled to delete the user who is accessing the database furthermore, if you'd like to not have from now on traces of the that database lingering.



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read
What does DomainSync do? (Views: 1889)

Powered by WHMCompleteSolution