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
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 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
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
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
This is our confirmation screenshot that are database user was created. Copy into your notepad file.
Connecting the Database User to our Database
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
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
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.
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
This is what the Default file looks like in WordPress 2.7.1.
Putting our Values into the wp-config-sample.php file.
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.
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.
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
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.

