Install phpMyAdmin on a Linux server Print

This article will go over the steps of installing phpMyAdmin on a Linux server. phpMyAdmin is a web-based program that can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, and export data into various formats."

1. Login to the Linux server via SSH. If you are unfamiliar with how to SSH.
2. Navigate to location where the software is to be installed.
3. Download the software onto the web server:
   • Go to this site.
   • Click the link for the .tar.gz link for the latest stable version of phpMyAdmin.
   • Select a nearby mirror and click the download link.
   • When the new page loads, there's a link at the top for a direct download. Copy this link.
   • Go back to SSH and type: wget <link> (where <link> is what you just copied) and hit enter. The file will download.
4. Extract the software with the command:

   tar -xzvf phpMyAdmin-x.x.x.tar.gz

5. Move the extracted folder from its location to phpmyadmin:

   mv phpMyAdmin-x.x.x phpmyadmin

6. open phpmyadmin/config.inc.php with your favorite text editor, e.g. nano phpmyadmin/config.inc.php
7. Within that file, edit the following lines:
   • $cfg['PmaAbsoluteUri']: This should be the complete URL to where phpMyAdmin is installed on your site.
   • $cfg['blowfish_secret']: Just set this to a random jumble of letters.
   • $cfg['Servers'][$i]['host']: the MySQL internal server address, e.g. mysql3.
   • $cfg['Servers'][$i]['auth_type']: set this to cookie;
   • $cfg['Servers'][$i]['user']: the customer's mysql username.
   • $cfg['Servers'][$i]['password']: the customer's mysql password.
   • $cfg['Servers'][$i]['only_db']: the customer's mysql database name .
8. Navigate to the URL you set above in a browser. At the login screen enter the MySQL username and password and you will be logged in to phpMyAdmin.