How to Create a MySQL Database in HostGator

How to Create a MySQL Database in HostGatorThis post will help you to create MySQL Database in HostGator. To create MySQL Database you do not need to be computer geek. If you follow my steps you can easily create Database in your Hostgator Hosting.

 1. Hostgator cPanel
First login your Hostgator cPanel. If you don’t have Hostgator account and Don’t know how to open it then read my this post. It will help you to buy a hostgator account.

After login you will see your Hostgator cPanel like this.

http://www.waystomakesite.com/

2. Database
Find Database section in your cPanel. You will see four options in there. Click on MySQL® Databases icon.
http://www.waystomakesite.com/

3. Create New Database
Then you will see a text area in next page. Enter your database name in text box. You can enter any name but any spaces or special characters are not allowed in your database name. Once you have entered the database name in the textbox, click the Create Database button.

Create a MySQL Database in HostGator

4. Database Was Created
After clicking on the Create Database button, a new page will show that the database was created .Your account username will be prepended to the new database name. If you entered ‘waystomakesite‘ as your database name, the actual database name will be username_ waystomakesite .

5. Create a User
Now you need to create a user for your new database.  Scroll down to the bottom of the MySQL Databases page and you will see the Add New User form to create a user for your database.

Create a MySQL user in HostGator
Enter a username for the database user in the Username text entry field and a strong password in the Password text entry field. Then click the Create User button.
After clicking the Create User button, screen will show you the username and password for the new database user. Now you need to add the user to the database.
6. Add User To Database
Scroll down to the bottom of the MySQL Databases page ,you will see Add User To Database section in there.
add MySQL user to MySQL database in HostGator

In the first select box, find and select the database user you have created and in the select box, locate and select the database you have created. Once you have selected the database and user, click the Add button to add the user to the database.

After clicking on the Add button, the MySQL Account Maintenance page will appear.Set the database privileges and click on the Make Changes button.

add MySQL user to MySQL database in HostGator

Done! You have  successfully created a new MySQL database for your website. Now go to next step to create your own website.

Leave a Reply