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.

help To learn more about using cPanel, go here:

redarrow Using cPanel To Manage WordPress

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 …

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

redarrow How To Delete A WordPress MySQL Database

How To Create A WordPress MySQL Database

***

"If you're new to WordPress, this can stand on its own as a training course and will stay with you as you progress from beginner to advanced and even guru status." - Bruce (Columbus, Ohio)

Disclaimer: This site is not directly associated with WordPress or any WordPress products promoted on this website. We may receive financial benefits or affiliate commissions from sales of any third-party products advertised, endorsed or linked to our website. All images are the copyright of their respective owners and are used solely for training or illustrative purposes.

Get Thrive Leads for WordPress

***

Did you enjoy this article? Feel free to share this page with others who could benefit from learning about WordPress using the social links below.

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!

Originally published as How To Create A WordPress MySQL Database.