Creating New Database Using MySQL In Linux Hosting

In this post, I’ll be talking about how to create a MySQL database in Linux Web Hosting. This is actually very simple. First of all, login to your hosting account and open the control panel (cPanel).

In cPanel, navigate or scroll down to the databases section. Here select the MySQL databases option. And rest you can figure it out yourself. But if you can’t, then continue reading..

You can find a box which says ‘Create New Database‘. All you need to do over here is just enter the name of the database. And hit the ‘Create Database‘ Button.

Your database will be created. You can now use this database for WordPress, Joomla, etc. But you’ll need to add users to the newly created database. In the next post we’ll see how to add users to the MySQL database.

Uploading Files To The Server Using An FTP Client

In this post, i’ll talk about how to use an FTP Client to upload files to the web server. FTP is File Transfer Protocol. For uploading files to the web server, you will need an FTP Client. I’ll recommend FileZilla. Its tiny and easy to use. You can download FileZilla FTP Client from their official website and install it on your computer.

Now you will need the FTP details of your web host. You must have received these details in an email sent to you after purchasing the web hosting.

I have received the e-mail as shown below. This will give you an idea of what you exactly need to connect using an FTP Client.

FTP Details BIGROCK

Connecting To The Server

  • If you have the FTP details, just go ahead and open the FileZilla Client.
  • Click on File > Site Manager.
  • Click on New Site.

Site Manager FileZilla

  • Enter IP address (which you received in email) in Host details. Or you can simply type in ftp.yourdomain.com as i have done in the screenshot above.
  • Enter port as 21.
  • In Server Type, try FTP, FTPS or FTPES. Check which one works out for you.
  • Enter the username and password which you received in the email.
  • And click on Connect.

If connection is established then well and good. If not, just put the error message in comments below and i’ll try to help you out.

Uploading Files

Once Connection is established, you can find a list of folders like mail, public_ftp, public_html, tmp, www, etc. All you need to know right now is that www is the folder where you will upload all the contents of your website.

To upload any file, just drag and drop that file over that folder. Or you can open the folder first and then drag-drop the file inside the folder. This will initiate the file upload.

For example, if you upload xyz.png to www folder. It can be found at yourdomain.com/xyz.png and thus www is the root directory of your website.

Installing WordPress On The Web Host

In the previous post, I have written about purchasing domain and web hosting from BigRock. Now lets see how to install WordPress on the server which you have purchased. And note that, I am using BigRock’s hosting as an example. But you can follow this for almost every other host.

Once you purchase linux hosting with a new domain, your account will be setup in 24 hours. Once its done, just login to your hosting account.

List Of Orders - Big Rock

After logging in, click on the domain name of the product named Web Services. Now scroll down to the Web Hosting part and click on Manage Web Hosting. This will open up the Control Panel (cPanel).

BigRock Web Hosting cPanel

In Softaculous app installer, click on WordPress. You’ll be taken to the installation page. Click on install button and now you’ll be asked to enter the details of the installation.

Installing WordPress Using Softaculous Installer

  1. Choose the Protocol as HTTP.
  2. Choose domain as your Domain Name. (I have chosen codefap.com)
  3. Leave the ‘In Directory‘ empty, so the installation will be in the root folder (domain.com) instead of sub folder (domain.com/wordpress).
  4. Leave the Database name and table prefix as it is.
  5. Just go ahead and enter the site name and description.
  6. Enter the admin username, password and email address. This will be the user account which you can use to administrate the blog. Basically this is blog owner’s account.
  7. Once WordPress is installed you can simply goto yourdomain.com/wp-admin and login using the username and password which you have set previously.
  8. That’s it. You are now ready to go.

Softaculous WordPress Installation Linux Bigrock

Note that, If your host does not support an online installer then you will need to upload the WordPress package using an FTP Client. I’ll talk about that in the next post.