How To Create A WordPress MySQL Database

Learn how to create a MySQL database for WordPress using cPanel’s MySQL Database Wizard.

How To Create A WordPress MySQL DatabaseThis tutorial is part of our WordPress Management tutorial series. In this tutorial, we show you how to create a MySQL database for WordPress using cPanel’s MySQL Database Wizard.

***

How To Create A WordPress MySQL Database

If you are performing a manual WordPress installation or adding a new application to your website that requires data to be stored in its own MySQL database, then follow the tutorial below to learn how to create a new MySQL database using cPanel.

To learn more about using cPanel, go here:

How To Create A MySQL Database

Log into your cPanel administration area …

How To Back Up Your WordPress Database Using phpMyAdmin

Scroll down to the ‘Databases’ section of your cPanel administration area and click on MySQL Database Wizard …

How To Install WordPress Using FTP

Create a database name and click ‘Next Step’ …

How To Install WordPress Using FTP

Note: In the above screenshot example, the prefix “wrdpress” is the domain username and “demo” is the database name. Your configuration will show a different domain username prefix.

Copy the entire ‘prefix_databasename’ string into a plain text file. You will need it later on during the installation process.

Next, create a username, and enter and verify a password (aim for a score of very strong – use the password generator if you need to), then click ‘Create User’ …

How To Install WordPress Using FTP

In the above screenshot example, the username is “demo1”.

In the next screen, do the following:

  • Copy the ‘User’, ‘Database’, and ‘Password’ details to a plain text file and save it to your hard drive. You will need these later.
  • Select the ‘ALL PRIVILEGES’ checkbox
  • After completing the above tasks, click on Next Step to proceed …

How To Install WordPress Using FTP

Congratulations! You have successfully created a MySQL database …

How To Install WordPress Using FTP

 See Also …

To learn how to delete a MySQL Database, see the tutorial below:

How To Create A WordPress MySQL Database

***

"I am beyond impressed with what you have put together. I can tell that you put a ton of hard work into building what you have. You have the absolute best content on WordPress I have ever seen!" - Robert T. Jillie

Disclaimer: This site has no association with WordPress, Automattic, or any of the WordPress-related products mentioned or reviewed on this website. We may derive an affiliate commission from sales of services and/or products mentioned on our site. All product images are the copyright of their respective owners and comply with all license terms and agreements of use.

***

Did you enjoy this article? If so, please use the social links below and share this tutorial with other WordPress users.

Author: Martin Aranovitch

Martin Aranovitch is the founder of WPCompendium.org and has authored hundreds of FREE WordPress tutorials for non-techies and beginners. WPCompendium.org provides detailed step-by-step tutorials that will teach you how to use WordPress with no coding skills required and grow your business online at minimal cost!