Wordpress Manual Installation and MySQL Manual Installation Part 2

Manual Wordpress Installation Continued Part 2 – Currently working with MySQL Database Creation.

There is a video included on the bottom of this printed tutorial.

Installation Tip

Installation_Tip.png

Before you continue any further do yourself a favor and do this. Open a Notepad file and copy any information that will be needed further along in the installation. Being able to copy and paste the information instead of re-typing it manually will decrease your chances of creating an error.

The database name

The_database_name.png

The good thing about coming here first to this step this way is that generally you see all of the other Database names.

Most of the default names for WordPress Databases (MySQL) starts with "wrdp" and a number. So if we had used the wizard, you would not have seen the other Database names and not have know to start this new installation at Step 1 "wrdp4". Again if this is the First WordPress installation on your webhost it would be "wrdp1". Please if any of this seems a little confusing you can look at the video I also made on this subject. You can also post a comment for any questions that you have and I will answer them.

Step 2 Click "create database"

Database name is verified

Database_name_is_verified.png

As you can see our database is added, and if you notice the word "computer" was added to our database name we picked. This is normal it is just another way to identify the path to the database. Click "go back" so we can go back to our Database creation Dashboard.

Copy into your notepad file.

Create a New Database User

Create_a_New_Database_User.png

In this step we are creating a Database User that now needs to connect to the Database we just created. Again I would like to remind you that you can make this anything you want. Here I decided to stick to "wrdp4". Once you create the password and type it in again, you will now Click "Create User"

NOTE: Please make the password something really hard as you do not want your Database hacked.

Verification of New Database User

Verification_of_New_Database_User.png

This is our confirmation screenshot that are database user was created. Copy into your notepad file.

Connecting the Database User to our Database

Connecting_the_Database_User_to_our_Database.png

In this step, we select our Database User in the Drop-Down Menu and we select our Database in the drop-down menu. We then click the add button.

Activating the privileges of our Database User

Activating_the_privileges_of_our_Database_User.png

This screen comes up automatically, immediately after you add new Database User. Again you can see that our username that we packed is pre-populated with the word "computer". See the next step on how to add privileges.

Setting the privileges of our Database User to our Database

Setting_the_privileges_of_our_Database_User_to_our_Database.png

In Step 1 By putting a check in all privileges, it will automatically populate all the other fields. You then go to Step 2 to make changes, and then go to Step 3 to go back.

We are now done in our webhost Cpanel. We will now take our New Database UserName and Password, and New Database Name to add our wp-config-sample.php file In the next step .

Locate your wp-config-sample.php file on your Hard Drive.

Locate_your_wp-config-sample.php_file_on_your_Hard_Drive..png

Simply find the file and open it in Notepad or other HTML editor. I picked Notepad here as almost everyone has access to this Free program that came with your computer.

The Default wp-config-sample.php file

The_Default_wp-config-sample.php_file.png

This is what the Default file looks like in WordPress 2.7.1.

Putting our Values into the wp-config-sample.php file.

Putting_our_Values_into_the_wp-config-sample.php_file..png

Here we take the username and password information from our created Database and Database User and paste it into our wp-config-sample.php file. Remember you can use your notepad file contents here.

1. We copy our Database Name from our text file that we created for this website. Make sure to keep the 'apostrophes' in place when adding.

2. Copy your Database UserName.

3. Copy your Database Username Password

4. This can be left alone (typically)

5. This can be left alone (typically)

6. This can be left alone (typically)

Save your File!!

Upload all our Wordpress Files to our Webhost from our PC.

Upload_all_our_Wordpress_Files_to_our_Webhost_from_our_PC..png

Open your FTP program. If you have been following these tutorials you will be using Filezilla.

Please refer to the FTP tutorial if you need a refresher.

Please notice how I have my folders and files selected prior to the upload.

Once your files are uploaded go to the next step. There are somethings we need to change on the our webhost side prior to running our installation script.

Changing File and Folder Attributes.

Changing_File_and_Folder_Attributes..png

Select the file "wp-content" we need to change the permissions to "777" Again remember when selecting it to "right-click" it so you can access the menu to change the folder permissions.

Rename the wp-config-sample.php file

Rename_the_wp-config-sample.php_file.png

Select the wp-config-sample.php file. Please look at the next step what it will look like after you rename it. To access the "rename" feature you need to "right-click" it to bring up the menu.

Manual Installation Video Part 2

Please turn your speaker volume up if you are unable to hear.