WordPress Tutorials Part 8: How to Create MySQL Database in your Web Server

WordPress is a content management system. The information of your blog is stored in your MySQL database. So You must learn how to create a MySQL database for your blog. I will now show you how to create a MySQL database in your web server. If your web hosting company provide multiple databases, then use separate databases for every script you install. If you are allowed to use only one database, you may also use that database for multiple scripts. Just make sure that you are using different database prefix for different scripts. (I have found no option in HostGator. But, I used a single database for multiple scripts at FreeHostia.

Now here I am going to show you how you can create a MySQL database in your web server.

Step 1: Log in to your hosting cPanel.

Step 2: Click on the MySQL icon.

Step 3: Add a database user and password

Your database username is “Your hosting username+ your given database name”. If your hosting username is “user” and you create a database user called “blog”, then it will become “user_blog“.

Step 4: Add a new database like the following image.

Step 5: Now you have to add user to database.

First select the database username. Then You need to chose the database. Now you have set privileges to the user. Check “ALL” check box. Now click on the “Add User to DB”

You are done. You have now successfully made a database and ready to install wordpress in your website