The first thing we need to do is create an SQL database for our wordpress installation. Hopefully you did as I requested and purchased a hosting account that has CPanel, if you did then this process will be simple.
Next we want to login to our CPanel to create the database. To do this do the following:
Now that we are logged into our cpanel let's create the database.
The next step is to give the database a name. I chose to type in bccondo as illustrated below. You can type any name in here you like, I just chose the name of a business. When finished click Next.
The next step is to create a user and a password for the database we just created as illustrated below. Make sure you use a strong password for this step. A strong password consists of upper and lower case letters as well as numbers. View how to create a secure password for more info. When finished click Next.
The next step is to add the new user to the database. Select All Priviledges as shown in the illustration below. Please take note at this time to notice the database name and the name of the database user as shown below. You will need this information later on. Notice the database name is bccondo_bccondo and the database username is bccondo_billybo. When finished click Next.
Congratulations you have successfully created a database. Give yourself a pat on the back. This would be a good time to grab a coffee.
Do not let this next step intimidate you. This is the last thing we need to accomplish before uploading the files to our website in order for everything to clip along at a smooth rate. Follow the instructions to the letter and you should have no problems.
Launch your favorite text editor. Notepad will work just fine if you have it installed. Do not use Microsoft Word for this step.
Open up the wordpress folder on your hard drive. Find the file called wp-config-sample.php Rename the file to wp-config.php and then open the file with Notepad
If you can’t see file extensions on your computer go to this page: how to view file extensions and follow the instructions there to enable viewing file extensions.
Find the section in the file with the following information:
// ** MySQL settings ** //
define(‘DB_NAME’, ‘putyourdbnamehere’); // The name of the database
define(‘DB_USER’, ‘usernamehere’); // Your MySQL username
define(‘DB_PASSWORD’, ‘yourpasswordhere’); // …and password
define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
// Change SECRET_KEY to a unique phrase. You won’t have to remember it later,
// so make it long and complicated. You can visit https://www.grc.com/passwords.htm
// to get a phrase generated for you, or just make something up.
define(‘SECRET_KEY’, ‘put your unique phrase here’); // Change this to a unique phrase.
Change the information to your settings that you created earlier. For example do the following:
The next thing we have to accomplish is uploading the files to our web server. In order to upload files to a web server we will need a software application that gives us FTP abilities. FTP stands for “File Transfer Protocol”. There are a few programs available on the Internet to accomplish this. I use a program called Cute FTP. Cute FTP can be downloaded from Globalscape, it comes in 3 flavours, you can decide which one you prefer. There is also trial versions available. If you would like a free version of FTP software download Filezilla from Sourceforge. I will be using Filezilla for this tutorial because it is FREE. So go ahead and download Filezilla and install the software.
Launch Filezilla and do the following:
Once you have completed the above steps it is time to test our connection. Go ahead and click on Connect. If everything went well you should now be logged into your website. You should see a screen similar to the one below.
Notice there are two sections in Filezilla now. You have your local site: view on the left which is your computer, and your remote site: view on the right which is your website, as I have illustrated below.
The next steps are critical, you will have to pay close attention to what we are doing here. In the next steps we will upload the contents of the wordpress folder to your website.
Launch Filezilla and connect to your website and then do the following:
Once all the files are uploaded you need to run the wordpress install script.