How To Install WordPress On A Web Server Without MySQL Or CPANEL

Today we’ll be learning how to install WordPress on a web server without a CPANEL or MySQL database, just pure FTP. I’m sharing this because I run into similar problem before. The ftp server on the site that I’ve developed is not synchronized with my web server’s CPANEL thereby making it impossible to connect the database that I made there. It almost drive me crazy or something. I’ve searched the net for answers, but I haven’t found any clear solutions there and so I decided to do something about it. That’s like life actually, either you accept things as it is or you do something about it. Just kiddin.
The solution is surprisingly simple, upload WordPress on your ftp server, and since you don’t have a CPANEL, you can create a MySQL database using a free data provider outside of your web server such as freemysql.net or freesql.org . The details are listed in the following steps:
1. Download the latest version of WordPress from http://wordpress.org/.
2. Extract the downloaded files.
3. Start Filezilla(If you don’t have Filezilla installed, you can download it from http://sourceforge.net/projects/filezilla/files/FileZilla_Client/3.5.3/FileZilla_3.5.3_win32-setup.exe)>Enter your FTP server host, username and password then click quick connect.

4. Upload the contents of the wordpress folder to the public_html folder.
5. Open your web browser. Enter the URL of your site on the address bar.
6. Click Create Configuration File>Let’s Go button. The following should then appear.
7. Since we do not have CPanel and we can’t obviously create a MySQL database file which is needed in this window>Press CTRL + N. This will open up a new browser window. Enter freemysql.net in the address bar. The following should then appear:

Freemysql.net is a great site that offers free MySQL database storage for FREE.

8. Click the client area> then register.
9.After you have registered. Login to your account and create a MySQL database file. Remember the name of the database file that you have made because that will be used as your wordpress database name.
10. If you look on the bottom of your freemysql.net account, you will see your host or server name:
11. Now switch the browser screen to your WordPress configuration file then enter your freemysql.net database credentials>Click Submit.
12. Click the Run the Install button> And follow the on screen installation process to install wordpress.

Note: For more information, visit the wordpress official installation guide here http://codex.wordpress.org/Installing_WordPress. That’s all.

Fixing the “Previous release of Microsoft Visual Studio 2008” failed error when installing SQL Server R2

This error normally shows up if you try to install SQL Server R2 on a Windows machine. Unfornately, if you install Microsoft Visual Studio 2008 as the error implied, it still won’t work and it’s somewhat enough to make someone crazy or something.




This error could actually be fixed without installing Microsoft Visual Studio 2008. Follow these simple steps and I promise you, you will be able to install SQL Server R2 without fail. Trust me, I’ve tried it on ten (10) computers and it worked each and every time.

1. Download the necessary files in installing SQL Server 2008 R2. I won’t be covering how to install SQL Server R2 here, because there are several sites on the net that already teaches people how to do that. Just do a Google search and find a site that teaches how to install SQL Server 2008 R2 step by step.

2. Before you install SQL Server 2008 R2, uninstall any express edition applications such as Visual Basic Express Edition, Visual C# Express Edition and Visual Web Developer from your computer. Could be done by clicking Start>Control Panel>Add / Remove Programs> Select your Express edition file>Change/Remove >Uninstall>next>Finish.



3. Clear the TEMP folder. Could be done by clicking the Start button>Run>Enter “%temp%” no quotes> then delete all the contents of the TEMP folder.



4. Clear the contents of the PREFETCH folder. Could be done by clicking Start>Run>Enter “Prefetch” no quotes>Ok.



5. After clearing the contents of the prefetch folder, restart your computer the Install SQL Server 2008 R2. That’s all!

Note: This isn’t really the official way of doing this. But it worked for me and I thought it’s worth a share. Just tryin to help :)