How to install phpMyAdmin [PMA] on a Linux VPS/Dedicated se

Optimizing and customizing your VPS/Dedicated server

How to install phpMyAdmin [PMA] on a Linux VPS/Dedicated se

Postby Mark » Wed Dec 23, 2009 8:52 am

Here are the simplest steps to get it installed on a plain Linux VPS Hosting or Dedicated server :

1. Download the latest version of phpMyAdmin from phpMyAdmin or from here :

root@support [~]# wget http://jaist.dl.sourceforge.net/sour...english.tar.gz

2. Rename the TAR file for your convenience :
root@support [~]# mv phpMyAdmin* phpMyAdmin.tar.gz

3. Untar the package :
root@support [~]# tar xzf phpMyAdmin*

4. Move it to the appropriate place :
root@support [~]# mv phpMyAdmin /usr/share/

5. Configure phpMyAdmin :
root@support [~]# cd /usr/share/phpMyAdmin
root@support [/usr/share/phpmyadmin]# cp config.*.php config.inc.php
root@support [/usr/share/phpmyadmin]# vi config.inc.php

6. Locate the following lines within that file & make sure each they look like the below ones :
PHP Code:
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'mysql-root-pass';
7. Save the file.

8. Create the apache configuration file for phpMyAdmin :
root@support [/usr/share/phpmyadmin]# echo "alias /phpmyadmin /usr/share/phpMyAdmin" > /etc/httpd/conf.d/phpMyAdmin.conf

9. Restart the http service :
root@support [~]# service httpd restart

10. You're done

Now, access phpMyAdmin through the following using the root login details: http://server-ip/phpmyadmin eg: http://10.10.10.1/phpmyadmin
Mark
 
Posts: 124
Joined: Fri Dec 11, 2009 2:18 pm

Return to Configuring VPS/Dedicated servers

Who is online

Users browsing this forum: No registered users and 1 guest

cron