WordPress For Non-Techies: Free WordPress Tutorials – WPCompendium.org

How To Create A WordPress MySQL Database

This 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 …

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

Create a database name and click ‘Next Step’ …

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’ …

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

In the next screen, do the following:

Congratulations! You have successfully created a MySQL database …

 See Also …

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

***

"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

***

Recommended Video Courses For WordPress Users

How To Use cPanel

cPanel is a powerful and simple-to-use web hosting management software application that gives website owners the ability to quickly and easily manage their servers and websites using a simple and intuitive dashboard.

This video course will teach you how to use the main features of cPanel to manage your web hosting.

More info: How To Use cPanel

Recommended Video Courses For WordPress Users

Google Tools

This video course will help you learn the basics of using Google Tools like Google Analytics and Gmail.

More info: Google Tools

Recommended Video Courses For WordPress Users

WordPress Security

Learn how to keep your WordPress site or blog secure and protected from malware, hackers and brute-force attacks.

More info: WordPress Security

Recommended Video Courses For WordPress Users

How To Install, Set Up & Use WordPress Multisite

Learn how to quickly and securely set up an online community of websites or blogs using the powerful WordPress Multisite feature.

More info: WordPress Multisite

Recommended Video Courses For WordPress Users

How To Set Up WordPress On Localhost

Learn how to install, set up, and locally host a fully functioning WordPress site on your computer.

More info: How To Set Up WordPress On Localhost

Recommended Video Courses For WordPress Users

Using Password Managers

Password Managers provide an easy and secure way to keep track of all your passwords. This video course shows you how to use two FREE powerful password management tools.

More info: Using Password Managers

Recommended Video Courses For WordPress Users

How To Use FTP

This video course shows you how to use FTP (File Transfer Protocol) to transfer and upload files between your hard drive and your server using a free FTP program called Filezilla.

More info: How To Use FTP

Recommended Video Courses For WordPress Users

How To Optimize WordPress

Learn how to optimize your WordPress site and improve your page loading speed.

More info: How To Optimize WordPress

Recommended Video Courses For WordPress Users

How To Back Up & Restore WordPress Sites

Learn how to safely and automatically backup your WordPress files and database and how to easily restore your WordPress site if something were to happen.

More info: How To Back Up & Restore WordPress Sites

Recommended Video Courses For WordPress Users

How To Set Up A Forum On WordPress

Learn how to set up a forum for your visitors, prospects, customers, members, or affiliates using WordPress.

More info: How To Set Up A Forum On WordPress