Manage MySQL with phpMyAdmin on Ubuntu 9.10 (Karmic)
Updated by Linode
This guide has been deprecated and is no longer being maintained.
phpMyAdmin is an open source web application written in PHP that provides a GUI to aid in MySQL database administration. It supports multiple MySQL servers and is a robust and easy alternative to using the MySQL command line client.
We assume you’ve followed the steps outlined in our getting started guide. All configuration will be performed in a terminal session; make sure you’re logged into your Linode as root via SSH. We also assume that you have installed a working LAMP stack. For guides on installing a LAMP stack for your distribution, please visit the LAMP guides section of Linode Guides & Tutorials.
Be aware, if you have opted to install the
php-suhosin package, there are some known issues when using phpMyAdmin. Please visit the Suhosin phpMyAdmin Compatibility Issues page for more information about tuning and workarounds.
Enabling the “Universe” Repository
mcrypt PHP module required by phpMyAdmin is contained in the “universe” repository for Ubuntu Karmic. Edit your
/etc/apt/sources.list file to enable the “universe” repositories by removing the hash symbol in front of the universe lines. The file should resemble the following example:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
## main & restricted repositories deb http://us.archive.ubuntu.com/ubuntu/ karmic main restricted deb-src http://us.archive.ubuntu.com/ubuntu/ karmic main restricted deb http://security.ubuntu.com/ubuntu karmic-security main restricted deb-src http://security.ubuntu.com/ubuntu karmic-security main restricted ## universe repositories deb http://us.archive.ubuntu.com/ubuntu/ karmic universe deb-src http://us.archive.ubuntu.com/ubuntu/ karmic universe deb http://us.archive.ubuntu.com/ubuntu/ karmic-updates universe deb-src http://us.archive.ubuntu.com/ubuntu/ karmic-updates universe deb http://security.ubuntu.com/ubuntu karmic-security universe deb-src http://security.ubuntu.com/ubuntu karmic-security universe
When you have saved this file, issue the following command to refresh your system’s package database:
apt-get update apt-get upgrade --show-upgraded
Preparing Your Apache Configuration
In order to provide better security, this guide will install phpMyAdmin to an SSL secured Apache
VirtualHost. While you can use HTTP to access your phpMyAdmin instance, it will send your passwords in plain text over the internet. Since you will most likely be logging in to phpMyAdmin using your MySQL root user, HTTP is definitely not recommended.
If you need to set up SSL for your host, please refer to our using Apache with SSL guide. Please ensure SSL is enabled for your virtual host before proceeding.
phpMyAdmin requires the
mcrypt PHP module. You can install it using the following command:
apt-get install php5-mcrypt
You may need to restart your Apache server daemon for the changes to take effect:
To install the current version of phpMyAdmin on a Debian system use the following command:
apt-get install phpmyadmin
You will be asked which server to configure phpMyAdmin for. Choose your current web server.
phpMyAdmin will be installed to
/usr/share/phpmyadmin. During installation, it will be configured for the Apache default site. However, if you are using Apache virtual hosts a little more configuration is needed.
For each virtual host that you would like to give access to your PHPMyAdmin installation, you must create a symbolic link from the document root to the phpMyAdmin installation location (
Change directory to your document root and issue the following commands to create the symbolic link (be sure to substitute the proper paths for your particular configuration):
cd /srv/www/example.com/public_html ln -s /usr/share/phpmyadmin
This will create a symbolic link named
phpmyadmin in your document root.
We recommend securing your phpMyAdmin directory using an
.htaccess file and only allowing specified IP addresses to access it. You can do this by creating an
.htaccess file in your
phpmyadmin directory. Refer to the sample
.htaccess file below. Be sure to substitute the proper paths and IP addresses for your particular configuration.
1 2 3
Order Deny,Allow Deny from all Allow from 18.104.22.168
Since you are required to enter your MySQL credentials when using phpMyAdmin, we recommend that you use SSL to secure HTTP traffic to your phpMyAdmin installation. For more information on using SSL with your websites, please consult guides that address SSL certificates.
You can force phpMyAdmin to use SSL in the phpMyAdmin configuration file
/etc/phpmyadmin/config.inc.php by adding the following lines under the
Server(s) configuration section:
$cfg['ForceSSL'] = 'true';
Testing Your phpMyAdmin Installation
To test phpMyAdmin, open your favorite browser and navigate to
https://example.com/phpmyadmin. You will be prompted for a username and password. Use the username “root” and the password you specified when you installed MySQL. Alternatively, you can log in using any MySQL user and retain their permissions.
If you can successfully log in, phpMyAdmin has been installed properly.
You may wish to consult the following resources for additional information on this topic. While these are provided in the hope that they will be useful, please note that we cannot vouch for the accuracy or timeliness of externally hosted materials.
This guide is published under a CC BY-ND 4.0 license.