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."
- Login to the Linux server via SSH. If you are unfamiliar with how to SSH.
- Navigate to location where the software is to be installed.
- 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.
- Extract the software with the command:
tar -xzvf phpMyAdmin-x.x.x.tar.gz
- Move the extracted folder from its location to phpmyadmin:
mv phpMyAdmin-x.x.x phpmyadmin
- open phpmyadmin/config.inc.php with your favorite text editor, e.g. nano phpmyadmin/config.inc.php
- 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 .
- 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.