Home Servers Install phpMyAdmin on VPS or Amazon EC2 and VPC

Install phpMyAdmin on VPS or Amazon EC2 and VPC

5
0
851

If you Install phpMyAdmin on VPS or Amazon EC2 and VPC, then SQL DB management can be made simple and very powerful. phpMyAdmin is DB administration control panel written in php. This is free and gives you all the options to handle a database including maintenance, repair, cleaning, backups and restore. This is a must have for any webmaster.

phpMyAdmin install on VPS or EC2 geekact

I am assuming that you have already installed PHP, MySQL and Apache. This guide is basically for CentOS linux however, can be used for any linux if some commands are replaced; for e.g. wget.

TIP: Ec2 or VPC user using Amazon linux need to use “sudo” in front of every command or things will not work. Alternatively, type “sudo su” once and get rid of typing sudo every time.

So, Let’s Install phpMyAdmin on VPS or Amazon EC2 and VPC :

1. First of all, login to your VPS server or Amazon EC2 or VPC server using PuTTY. You can also use any other SSH client.
2. Go to this download page of phpMyAdmin website.
3. Select your version and language. Version is important as latest phpMyAdmin can only be ran if you have PHP 5.3+ on your server.

I have selected the latest version available at the time of writing this article It was “phpMyAdmin-3.5.3-all-languages.tar.gz”.

4. Click it. So you will go to download page. There will be a direct link. Right click it and copy that URL.
5. Go back to Putty. Now type “wget”, give a space and paste that copied address.  Hit enter. Server address will be resolved and download will start. Wait for it to complete.

Alternatively, you can just copy paste following to get it downloaded;

wget http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/3.5.3/phpMyAdmin-3.5.3-all-languages.tar.gz

6. Now unpack it using following;

tar xvfz phpMyAdmin-3.5.3-all-languages.tar.gz

All the contents will be extracted to root folder in a folder ‘phpmyadmin’

7. Now, you need to create another folder ‘phpmyadmin’ but under folder ‘html’ folder. So use this;

mkdir /var/www/html/phpmyadmin

8. You will now need to copy all the contents of extracted folder to this newly created folder;

cd phpmyadmin
cp -R * /var/www/html/phpmyadmin

9. Restart apache server;

service httpd restart

or

/etc/init.d/httpd restart

Now, go to browser and type “yourdomain.com/phpmyadmin”. You should be greeted with phpMyAdmin login page. Use your MySQL root login and password. If you don’t have it you can reset or change it via webmin. For assistant you can follow this guide.

If you are unable to get to phpMyAdmin page then you will need to configure some settings and do some installations. Don’t worry it’s a breeze. However to avoid complexity and getting off-topic I am just linking it to other article as I can’t include all of them here.

Troubleshooting various phpMyAdmin starting problems:

Problem 1 – phpMyAdmin Error 404 Page Not Found

This is real annoying and nasty but have a simple fix. Read this article to solve this one.

Problem 2 – Your PHP installation appears to be missing the MySQL extension which is required by WordPress

This will take a little more work. Read this article to solve this one.

Problem 3 – MySQL root login password:

This one is simple to fix. Read this one.

 

When everything is fixed then you will be able to access phpMyAdmin.

Let me know of any issues you are facing. I will try to resolve them. Just make sure that you post your issues in this Troubleshooting article.

Here ends; Install phpMyAdmin on VPS or Amazon EC2 and VPC.

5 Comments

  1. Harish

    December 7, 2012 at 2:53 pm

    Amazing work. No better guide to install phpmyadmin on vps or ec2. Thanks man!

    Reply

    • Miester

      April 19, 2013 at 9:00 pm

      I agree

      Reply

    • Guest

      May 26, 2013 at 11:49 pm

      works nicely on ec2 after trying a few guide which doesnt work. thanks

      Reply

  2. David

    January 24, 2013 at 1:46 pm

    Thanx!!!

    Reply

  3. Miester

    April 19, 2013 at 8:59 pm

    I agree with Harish. No better guide for phpmyadmin installation. Thanks Mrinal. I am subsribed! 😀

    Reply

Don't hesitate. Comment!

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Check Also

How to Properly Set WordPress Redirect to HTTPS

Installing SSL is easy but making your WordPress site to adapt it and forget HTTP so, your…