Tip:
Highlight text to annotate it
X
Once you are in the cPanel of the t.server
or the hosting service you are using, you will want
to create a database.
If you scroll down, go to the Database section.
Click on: mySQL Databases
Now there’s a lot of userIDs and passwords
that you are going to have to keep track of, so I recommend that you write them all down.
First of all, there’s the userID and password for the cPanel
and the URL that you will need to get into the cPanel
Your UserID is your first name and last initial.
Here you can see it on the URL field.
Your password is your student ID number.
In order to access the cPanel, you need to go out to
the URL: https: your firstnameLastInitial
dot t, dot south-central, dot edu. Here’s the key:
You have to put in colon 2083.
That goes in a specific doorway that the server is checking to see
who is coming in.
Write those down and label them clearly
that they are how you get to the cPanel.
You are going to have another set of userNames and database names for the database.
I would recommend
using wordpress as the username AND wordpress as your databaser
name. That way, when you see those files
or are working with the cPanel, you’ll recognize
what you have set up.
Mark these clearly that they are for your database
because that is separate from you cPanel access.
Let’s go into cPanel and create a database.
Because everyone’s database is stored in a common area on the server
what the cPanel does is take the userID,
which is unique to everybody and an underscore
and puts it in front of your database name. Here we are going to create
the database. We are going to call it wordpress (keeping it all lower case).
Click on “Create Database"
Here is the name of the database. Write this down!
Your first nameLastInitial underscore and the name you gave the database.
Click on “Go Back”
You can see
that I’ve already created a database for a thing called Drupal. I know that’s my Drupal database.
Now I need to make a user name.
I could use pedroj_drupal if I want but that gets a little confusing.
So I’m going to make a new user and call that user “wordpress"
Again, cPanel will be adding on a prefix and underscore in case someone else on the t.server decided to use the same name.
Then I’m going to use
my password. You can use your student ID or any pasword
you want. You’ll notice that cPanel automatically checks the strength
So, I’m using a capital letter, lower case letters, and a special character.
Now I have that
Write down this password so you don’t forget it. Clearly label it!
that it is the database password.
Click on “Create User"
Now we have a database, a user, and a password.
Now we have to connect the database and the userID together.
Scroll all the way down. Here you can see we have the database
but there’s no user connected to it. We are going to scroll all the way down...
and we are going to set up the user pedroj_wordpress with the database pedroj_wordpress.
So you can see how those two fit together.
Make sure you click the “Add” button.
When you do this you will see the privileges page. There are several
that you don’t need, but for your test example
we are not going to be worried about security. Access is more important right now.
So, we are going to click on “All Priviliges”
If you are going to have a live website there’s a few of these you want to turn off.
but don’t worry about that now.
So, make the changes and click on “back”
Now you can see that we have the database connected with the user.
and you know
the userID and password to access this.
That’s all you need to know
on setting up a database. In the next video we will be showing you how
to install WordPress. And you will use the information you wrote down
and automatically install WordPress.