Database MySQL

Installing phpMyAdmin and connecting to remote database server

phpMyAdmin is one of the many tools that allows administrators the ability to effectively and efficiently work with their databases. This can can either be a local database or on a remote database. Where ever the location of your database, phpMyAdmin will easily allow you to connect to both.

 

Installing phpMyAdmin

This can be done either via FTP or directly from your command terminal.

FTP:

Download the phpMyAdmin file which supports your version on MySQL. In this example, I will be using phpMyAdmin 4.4.12 which is the latest (at the time of this writing) and supports MySQL 5.5. This can be downloaded here. Once it has been downloaded it will need to be extracted and then uploaded to your server. Be sure to rename this as this will be the name that will be used when accessing via your web browser. In this case the default directory name was renamed phpMyAdmin-4.4.12-english to pma.

The final url path will be example.com/pma

CLI:

Once logged into the server via ssh you can wget or fetch to download phpMyAdmin directly to your server. It can be downloaded using the following:

Download:

wget https://files.phpmyadmin.net/phpMyAdmin/4.4.12/phpMyAdmin-4.4.12-all-languages.tar.gz

fetch https://files.phpmyadmin.net/phpMyAdmin/4.4.12/phpMyAdmin-4.4.12-all-languages.tar.gz

Extract Directory:

tar -xvf phpMyAdmin-4.4.12-all-languages.tar.gz phpMyAdmin-4.4.12-all-languages

Rename Directory:

mv phpMyAdmin-4.4.12-all-languages pma

The final url path will be example.com/pma

Configuring Remote Server Access:

Copy the phpMyAdmin sample configuration:

cp config.sample.inc.php config.inc.php

Update config.inc.php

From: $cfg[‘Servers’][$i][‘host’] = ‘localhost';  // Default Settings, Local Database Server

To: $cfg[‘Servers’][$i][‘host’] = ‘db.webair.com';  // New Settings, Remote Database Server

To Conclude:

I hope this has provided some insight on how to install and configure phpMyAdmin in order to make your database administration life easier than it may have been before!

 

Related Articles

  • Reset MySQL Password

    Resetting a MySQL Root Password is one of the easiest things to do. However, finding documentation on how to do so can be challenging.   We as system administrators, have...
  • Monitoring MySQL

    Monitoring MySQL servers can be difficult in a way that a novice won’t be able to monitor MySQL that easily. MySQL gives a comprehensive list of variables to check your server’s health...
  • LAMP STACK

    What is a LAMP Stack? “LAMP stack is a popular open source web platform commonly used to run dynamic web sites and servers. It includes Linux, Apache, MySQL, and PHP/Python/Perl...
  • How to Display MySQL Storage Engines

    How to Display MySQL Storage Engines From the MySQL command line, issue the following command: SHOW ENGINES; You should receive a result similar to:   Typically the default storage engine...