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:

***

"Learning WordPress has been a huge stumbling block for me. I've been looking for something that covers absolutely everything but doesn't cost an arm and a leg. Thank you so much ... you have just provided me with what I have been looking for! Truly appreciated!" - Tanya

***

Recommended Video Courses For WordPress Users

Build An e-Commerce Store With WordPress

Learn how to set up an e-commerce store on your WordPress site using e-commerce platforms like WooCommerce and Easy Digital Downloads.

More info: Build An e-Commerce Store With WordPress

Recommended Video Courses For WordPress Users

Keyword Research Tools

This video course shows you how to do keyword research using tools like the Google Keyword Planner.

More info: Keyword Research Tools

Recommended Video Courses For WordPress Users

Why Your Business Needs WordPress

Learn about the unique features, benefits, and advantages of using WordPress to start or grow your business online.

More info: Why Your Business Needs WordPress

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 Use Softaculous

Softaculous is a software program that automates the installation of commercial and open source web applications to websites on webhosting applications like cPanel. This video course shows you how to install WordPress on your website using Softaculous.

More info: How To Use Softaculous

Recommended Video Courses For WordPress Users

How To Use Amazon S3

Learn how to set up and use Amazon S3 to upload, store, manage, and protect your site’s images, large media files, downloadable files, stream videos and more.

More info: How To Use Amazon S3

Recommended Video Courses For WordPress Users

Build A WordPress Site ... Fast!

Need a new website or blog in a hurry?

This video course shows you how to quickly install and configure a WordPress website or blog on your own domain name and be up and running in no time!

More info: Build A WordPress Site ... Fast!

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

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

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