Do you want to setup a new blog on your existing hosting account? Do you want to create a MySQL database on Hostgator for a new website? If yes, then keep reading this guide.

In this step-by-step guide, we will teach you, how you can create a MySQL database, and database user on Hostgator.

See Also: How to Add Additional or 2nd Domain to Hostgator?

Why do you need to Create a MySQL Database?

WordPress stores its information in a database. The database is necessary to keep your precious data safe and secure. So, whatever you write or post on the blog, it is full managed by a database system. It manages your blog data like text, comments, etc.

How to Create a MySQL Database on Hostgator?

Using the Hostgator cPanel, you can easily create a database. Check out the step-by-step guide below and add a MySQL Database on Hostgator without using any third-party tool.

Step 1: Login into the cPanel and click on the Websites > Databases > and then on MySQL databases.

Create SQL Database in Hostgator Hosting

Step 2: Here, create a new database user. Enter the username and password… and click on the create user button. A new user will be created successfully.

Create Database User

Step 3: Now create a new database. Enter the database name and click on the create database button.

Create Database

Point to Remember: Note down the database name, db_user and db_password. You will need them!

Step 4: After that, just add the new user to database that you have created in step 2.

  • Select the Database User and select the Database Name from the drop down list.
  • Click on the add button to add the user to database.

Add User to Database

Step 5: On the next screen, check the all privileges option and click on the save changes button.

Create SQL Database in Hostgator

You have successfully created a new database.

Now you have to add all these information – db_name, db_username, and db_password in the wp-config.php file of the WordPress.

You can check about the WordPress installation and how to edit the wp-config.php in the step-by-step guide of how to install WordPress manually on Hostgator.

For more information just comment below!

Don’t forget to share the step-by-step guide on how to create a MySQL database on Hostgator.