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

  • Purpose of A Database

      Many beginners wonder to themselves: What do we use a database for? How is it beneficial to us? Why do we use a database? A DATABASE can be useful such...
  • 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...
  • How can I convert my MyISAM tables to InnoDB?

    If you want to convert a MyISAM table to InnoDB, the process is fairly easy, but you can do something extra to speed things up. Before converting the table, adjust...
  • MySQL Basic fundamentals

    A Basic MySQL Tutorial    Introduction: MySQL MySQL is an open source database management software that helps users store, organize, and retrieve data. It is a very powerful program with...