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.

 

Was this article helpful?
0 out of 0 found this helpful

Have more questions? Contact our support instantly via Live Chat