How To Create A MySQL Database

Created by Haider Ali, Modified on Fri, 24 Oct at 1:59 AM by Haider Ali

MySQL is the world's second most widely used open-source relational database management system (RDBMS). You will need to install MySQL databases for many of the scripts that you use to power your website.

While many of our modules, such as Wordpress, create the MySQL database for you, there will be times when you need to manually create one.

In this tutorial, we’re going to show you how to create a MySQL database using the wizard which will add a user as well.

Step 1: Login to cPanel

Step 2: Click on the Database Wizard

Step 3: Give your database a name and click Next Step.

Step 4: Now add a User that can access the database along with the desired password then click Create User.

Step 5: Give the user permissions. Generally All Privileges works well for most. But if you have unique uses for this database and user, select what permissions you would like to give them.

Step 6: You are now done!

As you probably noticed, your cpanel username will be prepended to any database name or username. For this example the db username is: webfoundrtest and the username is webfoundr-test2. Once you have your database created you can now connect it to your scripts that will need to access it.