Manually Create a MySQL Database in CPanel

In this tutorial we will show you how to manually create a database in CPanel. When you use an auto installer to setup ready to go applications like WordPress, Joomla, or Prestashop, the database is created for you. For applications such as CodeIgniter or CakePHP, a database is not created and must be done manually.

Creating a database in CPanel can be done two different ways. We will show you the easy method using the MySQL Database Wizard.

Step 1

Click the MySQL Database Wizard icon under the Databases section. Enter a database name. Most web hosts prepend your CPanel username to your database name. Hit Next Step.

Step 2

Enter a database username. Like the database name, most web hosts prepend your CPanel username to your database username.

Enter a password or use the Password Generator. Hit Create User.

Step 3

Select the privileges you would like your database user to have. Depending on your application, you may need to apply multiple or all privileges. When you are finished, click Next Step to end the process.

You have now created a MySQL database in CPanel, complete with a user account attached. You can now use phpMyAdmin to populate the database with your tables and data. You can access phpMyAdmin from the Databases section of CPanel.

For more tutorials on CPanel, WordPress, and other tools used by webmasters, visit us at Webmasternotebook.com and subscribe to our channel on Youtube.

Leave a Reply

Your email address will not be published. Required fields are marked *