How to Create a MySQL Database

Your control panel provides you the ability to create a database using MySQL database. Joomla, WordPress and other content management systems live completely off of the use of MySQL database. Setting up a database in your control panel is easy.

How to create a MySQL Database

  • After launching  your hosting control panel click on the square icon labeled MySQL Server. (if your not sure how to log into your hosting control panel please visit here)setup-mysql-001
  • If MySQL is turned off click on the “Off” button to activate it. If it is activated, or after you activated MySQL, click on the icon labeled “Add” next to Add Database.setup-mysql-002
  • In the MySQL Management window the first course of action is to create a name for your database. Using our control panel the database would be named in the format “<username>_<dbname>. This database I am creating will be a database named “testing_clippers”.setup-mysql-003This window gives you the ability to add a database description. This option is not required but if highly recommended if you are going to work with several different databases within your account.  Adding a description it makes it easier for you to review which database is attached to a specific website.
  • After you have entered your database and your description click on the “Next” icon.setup-mysql-004
  • Step 2 in creating your database it to add a user that can access your database. The usernames are created similar in style to the database names themselves. Our database users are setup as <username>_<dbuser>. For this example we will use the username example “testing_blake”.setup-mysql-005
  • After you enter your selected user name create a password to use when your database user name needs to access the database itself. We recommend that you use 10 to 12 characters and have this password only for this specific database and nothing else. If you need assistance in setting up a secure password review this password generator.setup-mysql-006Once you have created your password and added to the window confirm the password once again in the window.
  • When you have added your user name and password it’s time to setup a user role. For our example we will be using the user role “DBA”.setup-mysql-007
  • After you have entered all of the information make sure to click  ”Add User” to save the username and setup the ability for it to edit the database.setup-mysql-008
  • Finally, after you have added the user click the “Finish” icon to complete setting up the database and the user name.setup-mysql-009

Once you have clicked on the “Finish” icon you screen will be redirected back to the MySQL Server page which will display your newly created database in your account.

Was this article helpful?

Yes (33)
No (2)

We're sorry you didn't find this article very helpful. Please help us improve it by leaving your feedback below.

Error