Installing WordPress & phpMyAdmin on Ubuntu 14.04 server
07/19/2017 2:33 PM
So, your blog is becoming famous and attracting the audience from all parts of the world. You are happy for sure, but your current shared server isn’t. That is because it is overloaded by handling the increasing amounts of traffic and requests from your visitors for your content. You know that it’s the right time to move on to a VPS server when your visitors start complaining of sites being down or loading very slowly. In this tutorial below, we will be guiding you with complete steps with which you can install WordPress and phpMyAdmin (for databases) on Ubuntu (14.04) server using Serverpilot which can handle large amounts of traffic that you throw at it.
If you are the one who likes video explanations better over articles, then you are welcome to check out the video above. For the other part of our audience, here’s the detailed tutorial:
Things you will be needing:
- Ubuntu 14.04 64-bit droplet. You can purchase one for yourself from Digital Ocean if you don’t have one.
- FileZilla FTP Client. Download it from here.
- An account with serverpilot.io
- Latest WordPress installation files (or your current installation files if you are migrating from a different host)
- Latest phpMyAdmin version. Get it from here.
- Putty SSH client. Get it from here.
Steps To Install PHPMyAdmin & Wordpress on Ubuntu 14.04 Server
Step 1: Creating a droplet
- Once you have registered your own Digital Ocean account from the URL above, you will get 10 USD in credits for free which you can use to try them out for two months with 5 USD plan.
- Select Amsterdam or New York while creating the server.
- Ignore all the complex settings and scroll down to naming your server. You can name it something memorable or with your site name for identification.
Step 2: Connecting your droplet with Serverpilot and installing WP
- Now that you have created a droplet, it’s time to link it to Serverpilot for installing WordPress. Check your email for the root password and the IP address of your shiny new droplet.
- Enter those details in Serverpilot.io and enter your desired SFTP password (which will be later used for connecting with FileZilla)
- Click on Connect to Serverpilot and wait until it is finished.
- Once the connection is established, you need to create app to install WordPress.
- Be sure to check on the WordPress checkbox and enter the desired details which you need while setting them up.
- You are done with WordPress installation, you can check your site by opening the IP address using any browser. You can point this IP address to your custom domain name if you have any.
Step 3: Installing phpMyAdmin via FileZilla and Putty SSH client
- Connect to your server using FileZilla. You need to enter the IP address, username (serverpilot) and the SFTP password you chose while connecting your server with Serverpilot.
- Enter the port number as 22 (secure).
- Once connected, navigate to srv/users/serverpilot/apps/YOURSITENAME/public.
- Upload phpMyAdmin in public directory. You might want to rename the phpMyAdmin zip file to an easy to type name before uploading.
- Once the upload is done, access your server through SSH (Secure Shell) using Putty.
- You won’t be able to see the password which you are typing in, so don’t worry and click on enter once you are done with the password entry.
- Once you are in, cd to the public directory where phpMyAdmin is uploaded and use the “unzip filename.zip” command to unzip phpMyAdmin on your server.
- Done, you can access phpMyAdmin by entering your IP/phpMyAdmin (or the name which you chose for the long file name of phpMyAdmin)
Now that you have installed WordPress and phpMyAdmin without the use of cPanel (a memory eater in my opinion), you can import your previous database using phpMyAdmin and move your old WordPress installation by using FileZilla and unzip it using Putty. Your site is now ready to handle good amount of traffic and you can keep your visitors happy by providing them faster load times and improving your SERP in Google.