Create a MySQL Database for your WordPress Site via cPanel | WP Learning Lab

Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL
Create a MySQL Database for your WordPress Site via cPanel | WP Learning Lab

Although this video specific to WordPress users, it is also a great MySQL beginners tutorial. You won’t actually go into phpMyAdmin or interact with the database directly so there’s no danger of breaking very much.

The first thing you need we’ll do in this MySQL tutorial for beginners is log into the cPanel off your hosting account. In this video I’m working in a HostGator account. Once logged in you need to find an icon called MySQL Databases click on that icon or link (make sure it’s not the MySQL database wizard). The developers of cPanel have made creating a database very easy.

Near the top of the page that loads you will see an area called Create New Database. You will see some characters followed by an underscore followed by a blank field. The characters preceding the empty field are called the database prefix and they are very important.

Enter the database name into the empty field and click on Create Database. It is best to make the database name random letters and numbers so that it’s more difficult for dataminers to guess and steal your database contents.

After clicking create database you’ll be taken to a new page where the name of the new database is listed. Copy that database name into a text file for the WordPress installation process I explain in another video. Then click on Go Back.

Now you’re back to the database creation page. Scroll down until you see the MySQL Users section where we will Add a New User. Similar to when you created the MySQL database, add a username in the blank field to the right of the database prefix. Try to make it random letters and numbers again.

For the password use the Password Generator to create a very secure password. Next click on Create User.

On the next page you will be shown the username and the password you just created. Copy both to the text file where the database name is.

There you go, you’ve created your first MySQL database! That’s it for this beginners MySQL database tutorial.

I hope this information helps you! If you have any questions leave a comment below or ping me @WPLearningLab on Twitter.

All videos in the WP Learning Lab WordPress Installation Series:

1. WordPress Installation Introduction https://youtu.be/7jiMRKYcjq0

2. Buying A Domain Name For Your Website (From GoDaddy) – Tips & Tricks of the Pros https://youtu.be/qThIPLjjW5Y

3. WordPress Hosting: Buying A (BlueHost) Hosting Account for Your Website https://youtu.be/Amlw0VKbtRU

4. Setting Name Servers In Your GoDaddy Domain Registrar Account https://youtu.be/mlWBm4nL3R8

5. Create Add On Domains via cPanel https://youtu.be/vOjKns89Rj0

6. Downloading and Uploading WordPress.org (Self Hosted WordPress) Files https://youtu.be/O6IgVyxusro

7. Create a MySQL Database for your WordPress Site via cPanel https://youtu.be/wtG1IJ1Wbvs

8. Edit wp-config.php To Add WordPress Database Credentials https://youtu.be/QRKigi4ek_g

9. WordPress Installation Form & Logging In For The First Time https://youtu.be/qDGRcGTFOjs

10. WordPress One Click Install https://youtu.be/5L5fGL5egGk

11. Create A Custom Email Address For Your Website Via cPanel https://youtu.be/q4_1CeSU8XM

12. Forward Your Custom Email Address via cPanel https://youtu.be/n7sm8b5gUVY

13. WordPress Installation Series Conclusion & Next Steps https://youtu.be/ZJ3-gf3c-9o

————–

If you want more excellent WordPress information check out our website where we post WordPress tutorials daily.

Home

Connect with us:

WP Learning Lab Channel: http://www.youtube.com/subscription_center?add_user=wplearninglab

Facebook: https://www.facebook.com/wplearninglab

Twitter: https://twitter.com/WPLearningLab

Google Plus: http://google.com/+Wplearninglab

Pinterest: http://www.pinterest.com/wplearninglab/

source

The post Create a MySQL Database for your WordPress Site via cPanel | WP Learning Lab appeared first on Effective Guides for Digital Marketing / Internet Marketing / SEO Campaign.

from Effective Guides for Digital Marketing / Internet Marketing / SEO Campaign http://effectiveguide.com/create-a-mysql-database-for-your-wordpress-site-via-cpanel-wp-learning-lab/
via Earn Online