Setting Up WordPress & Your MySQL Database

by Drew Conroy

Posted on November 11, 2019

two purple colored databases

Note: This post is from our video tutorial on "Setting Up WordPress & Your MySQL Database"

Today I am going to show how to easily download WordPress and set up a database. But first get a Pen or Pencil and piece of paper.

After you have signed up for a hosting plan you should have been sent the details for logging into your control panel. All control panels provided by hosting companies are relatively similar. Today I will be using a control panel from Inmotion Hosting.

You can get to your control panel through Inmotion Hosting go to their home page and then click on the Amp Login. Make sure you bookmark this page so next time you can go directly to it.  I will be providing a link to this page in the comments section down below. As you can see I have my credentials saved. Then there is the check box with “I am not a robot”. You might end up having to answer a question or two by clicking on some pictures first.

Once you are logged in look for the cPanel then click on it. Then on the next page under Databases look for MySQL Databases and click on  that. Once inside look for “Create New Database”.

Enter whatever name you want to use for your database.

I would keep it short and only one word. If you decide to use additional words you just need to make sure you use an underscore in between them, you can not have any spaces.

I’m going to use the name databeta As an example. I will break it up into two words: data underscore beta (data_beta). Now make sure you write down your database name before continuing. Then click the “Create Database button”. That’s it, you have just created a database.  Click the “Go Back” link to return to the page.

Now you need to Create a User and Assign it to that Database.  Scroll down and look for “Add New User” and fill in the fields/boxes.  Again, no spaces and keep it short and sweet. I am going to use super_user and that’s super underscore user (super_user). Notice, there is a “Password Generator” button for creating a new password if you would like.  But it’s up to you, you can use whatever you want. Once you have filled everything in click the “Create User” button. Then Click the “Go Back” link to return to the page.

We are going to assign your new User to your Database.

Look for the “Add the User to Database” section. Select the User and your Database. It may have defaulted to them for you already. Either way, once they are selected click the “Add” button.  On the following page make sure you check off the box at the top that reads “All Privileges” then scroll down and click the “Make Changes” button. From here, Go to the top of the page and click the “Home” tab. On the following page under Software look for the “Softaculous Apps Installer” icon on the page and click on it.

On the next page, hover your cursor over the big WordPress image and then click on the red install button.

On the following page at the top under “Software Setup”. To the right, for “Choose Protocol”, the dropdown will show are variety of options. Inmotion Hosting does give you a free SSL certificate if you signed up with them. You will eventually want to have them set that up for you. For now, select http://www.

Next on down is “Choose Domain”. Select your domain from the drop down menu.  For “In Directory” leave that blank. Under “Site Settings”;  “Site Name” and “Site Description” you can leave those alone for now. In a later video I will show you how you can change that from inside your WordPress Dashboard. Leave Enable Multisite (WPMU) unchecked.

Under “Account Admin” choose a Admin Username and Password.

Do not use "Admin" and "Password". You will want to write them down. Select an email address for the admin. Make sure the email address is working because you will need it. There is a “choose your language” to select what language you want, but it defaults to English.

mysql logo with a dolphin

Then finally under “Select Plugin(s)”. Make sure everything is unchecked. Then click the “Install” button.  It may take a few minutes but when it’s through installing you will see something like the following text on the screen.

Congratulations, the software was installed successfully
WordPress has been successfully installed at:
Administrative URL :
Click the Administrative URL link above.

If for some reason it does not work then open another browser window and copy and paste that in and hit enter. It should automatically log you into your WordPress Dashboard. From inside your WordPress Dashboard: I want you too take your cursor and hover over the right upper tab on the page where it shows“Howdy, (your login) “ Click the “Log Out” link. This will bring you to the login screen where it may or may not have saved your login and password.  If not, you have it written down. This is where you will login to your WordPress Dashboard. Make sure you bookmark this page now in your browser, so you’ll have it saved.

You are now all set up!

Check out our WordPress Beginner Tutorials Series on our YouTube Channel.

Thanks for Reading - Have a Great Day!

Drew & the Crew