Installing MySQL database

Installing Your First Data Base Using MySQL

Using MySQL to Install Your First DataBase

Installing a database isn’t as hard or complicated as it sounds. The very first time I ever installed a database, I was really afraid of completely messing up everything.  I even thought I was going to destroy my server or something.  I’ve definitely come a long way:)  And you will too.  It is far easier than you imagine.  And if you do screw something up, so what?  Just delete it and start over.  Ah, the beuty of point and click technology….

Step 1

Okay, so begin by logging into your server control panel and scroll down until you see the heading “Databases”. It is one of the main “titles” of the cPanel page you should see. Once there, click on the link icon that says “MySQL® Database Wizard”. This is the same for any cPanel server set up, so yours should look the same or basically the same. (cPanel provides different “skins” for the control panel, so there may be different colors or something, but overall it has the same features, lins and icons.)

cPanel-databases

Step 2

A new page opens up and prompts you to add a database name. I usually just use a descriptive name so that I can find the database easily when I have more than one database.

For example: https://www.helpingwebmasters.com I might name the database webmasterssite or something similar. The name should be a little different from the URL for security reasons. Better to be safe right from the start. Once you enter the name, a little green arrow will show saying that name can be used. Click on the “Next Step” button under the information you just entered.

cPanel new database

TIP: I have a lot of websites. So I use a spreadsheet to track all of my information for all of my sites. I will add a downloadable spreadsheet template that you can use for your sites as well. Keep track of all usernames, passwords, etc… in one place. It’ll save you a lot of headaches down the road!

 

Step 3

In this step, we’re going to create a database user and give your database a password. This username is limited to ten characters in Hostgator and seven in InMotion Hosting servers. Again, I just use a variation of the domain. So maybe something like “webmaster5” or “webaaa” as the username.

cPanel create database users

For the password, I use the Password Generator” option.  It gives you very good unique passwords at the click of a mouse. So password cPaneluse it! Just remember to copy and paste the database password to your spreadsheet or somewhere as you’ll be needing this later during the WordPress install.

Once you generate a password, click on the “Use Password” button on the popup. For Hostgator accounts, you’ll need to check/tick the little box that says “I have copied the password in a safe place”. InMotion doesn’t do this.

After you click on the “Use Password” button, a “Strength” box should appear and it should be 100% and the color green. This is just telling you how strong the password you have chosen is.

Click on the “Create User” button at the bottom of the page.

TIP: If your browser prompts you to “Save Password”, do NOT do it! It is annoying and will always remember that password every time you create a new database. Just close the box.

 

Step 4

The next step is to give permissions to the user, “Step 3: Add User to the Database”.

cPanel Add User

I always just click on the “All Privileges” box at the top of the box with all of the options. The click the Button that reads “next Step”. And you’re done.

cPanel completed installI just click on the link to go back to the dashboard homepage. You should now do the same.

That’s it! Easy:)

If you do run into a problem, comment below and I’ll try to help out. I am by no means a database guru. In fact, I know little about them other than how to install and make a few changes because I’ve messed up things before:(

Previous Post
namesilo change DNS
Blogging

How to Point a Domain

Next Post
filezilla ftp client
Blogging

FTP what! What is FTP?

Leave a Reply

Your email address will not be published. Required fields are marked *