Ubuntu 12.04 LTS - Installing phpMyAdmin


The phpMyAdmin package allows you to interact (manage dbs, tables, columns, users, etc) with your database through a PHP GUI. This article will detail installing the phpMyAdmin web interface on the Ubuntu 12.04 LTS (Precise Pangolin) platform.

Note: This article assumes you have installed mysql-server prior to running the following command to streamline the configuration process. This can be installed by running the following command 'sudo apt-get install mysql-server -y'

Setup phpMyAdmin

1. Start by installing the phpMyAdmin package from the command line.

sudo apt-get install phpmyadmin

2. During installation you will be asked to select a Web server to run the phpMyAdmin interface. Select either Apache or lighttpd and press enter.

3. You will be asked to configure a database for phpMyAdmin.  Select Yes and press enter.

4. Provide the password used when installing mysql-server for the database administrative user.

5. Provide a MySQL application password for phpmyadmin.

6. Launch a Web browser and login to phpMyAdmin with the username and password created during installation.


Additional Information

1. The configuration wizard took care of creating all necessary config files for phpmyadmin. Take a peak at the /etc/phpmyadmin directory to see the configuration files.

ls -al /etc/phpmyadmin

2. If you need to make updates to the configuration in the future you will want to pay attention to the db-config.php file and the .conf file that corresponds to the web server selected in step 2 of the Setup phpMyAdmin section.

© 2015 Rackspace US, Inc.

Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License

See license specifics and DISCLAIMER