Install and Configure phpMyAdmin on Linux

In order to install and configure phpMyAdmin, a web-based database management program, please use the instructions below.

 

SSH access to your Linux server is a requirement, and the following must be pre-installed:

PHP5 or above
MySQL 5
Apache

 

 

 Install phpMyadmin

1

Log in to your Linux server via SSH. Navigate to the Apache Document Root and download the latest version of phpMyAdmin from http://www.phpmyadmin.net/home_page/downloads.php using the wget command.

2

Once the setup file has been downloaded, unzip the file into the current location using the following tar command:

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

and rename the folder created using the command:

mv phpMyAdmin-3.3.7-all-languages phpmyadmin

 

 

 Configure phpMyAdmin

1

Open a browser and visit the phpMyAdmin setup wizard using the URL:http://{your-ip-address}/phpmyadmin/setup/index.php

Click New server.

2

On the next page, under the Basic settings tab, fill out the following:

·      Verbose Name of the Server: Enter a descriptive name for the server.

·      Server hostname: Leave it as "localhost".

·      Server port: Leave it empty to use default port

·      Server socket: Leave it empty to use default socket

·      Use SSL: (Optional) Check box only if your web server supports SSL.

·      Connection type: Select tcp.

·      PHP extension to use: Select mysql for optimal performance.

·      Compress connection: (Optional) Check box only if you wish to use compressed protocol for MySQL connection.

·      Authentication type: Select cookie.

·      User for config auth: Leave it as "root".

·      Password for config auth: Enter the MySQL root password.

·      Connect without password: Leave unchecked.  It allows log in without password should a log in with password fail.

·      SweKey config file: Enter the name of the file containing SweKey IDs and login names for hardware authentication. Leave the string empty to deactivate this feature.

·      No changes are required on the remaining three tabs.


Click Save.

phpMyAdmin is now installed and configured.

3

To launch phpMyAdmin, visit the URL: http://{your-ip-address}/phpmyadmin/index.php and log in with your MySQL root username and password.  Once you have logged in you should be able to manage all the MySQL databases from your browser.