How to Creating Database for WordPress

If you are installing WordPress on your own web server, follow the one of below instructions to create your WordPress database and user account.

Using Plesk

If your hosting provider supplies the Plesk hosting control panel and you want to install WordPress manually, follow the instructions below to create a database:

1. Log in to Plesk.
2. Click Databases in the Custom Website area of your website on the Websites & Domains page:

3. Click Add New Database, change database name if you want, create database user by providing credentials and click OK. You’re done!

Using cPanel 

If your hosting provider supplies the cPanel hosting control panel, you may follow these simple instructions to create your WordPress username and database. A more complete set of instructions for using cPanel to create the database and user can be found in Using cPanel.

1. Log in to your cPanel.
2. Click MySQL Database Wizard icon under the Databases section.
3. In Step 1. Create a Database enter the database name and click Next Step.
4. In Step 2. Create Database Users enter the database user name and the password. Make sure to use a strong password. Click Create User.
5. In Step 3. Add User to Database click the All Privileges checkbox and click Next Step.
6. In Step 4. Complete the task note the database name and user. Write down the values of hostname, username, databasename, and the password you chose. (Note that hostname will usually be localhost.)

Using Lunarpages.com’s custom cPanel (LPCP) 

Lunarpages has developed their own version of cPanel.

1. Log in to your account.
2. Go to Control Panel.
3. Click on the button on the left panel labeled ‘Go to LPCP’.
4. Go to MySQL Manager.
5. Add the user name and database name but leave the host name as the default IP number.
6. Note the IP address of the database on the right which is different from the default IP number of the host indicated in the above step.
7. When modifying the wp-config.php file, use the DB IP number, not ‘LOCALHOST’.
8. When modifying the wp-config.php file, be sure to use the full name of the database and user name, typically ‘accountname_nameyoucreated’.
9. Refer for more info.