Install PhpMyAdmin on Ubuntu

**admin** · 01-05-2015, 05:23 AM

Download and extract PhpMyAdmin

Code:

cd ~/www
wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.2.11/phpMyAdmin-4.2.11-english.tar.gz
tar zxvf phpMyAdmin-4.2.11-english.tar.gz
mv phpMyAdmin-4.2.11-english phpmyadmin
cd phpmyadmin
cp config.sample.inc.php config.inc.php

Create Apache Configuration file.

Code:

sudo subl /etc/apache2/sites-available/phpmyadmin.conf

Add following code and save.

Code:

Alias /phpmyadmin "/home/USERNAME/www/phpmyadmin"

<Directory "/home/USERNAME/www/phpmyadmin">
    AllowOverride All
    Require all granted
    Options FollowSymlinks
    Order allow,deny
    Allow from all
</Directory>

Now run

Code:

sudo a2ensite phpmyadmin
sudo service apache2 restart

**admin** · 01-05-2015, 05:24 AM

Replace USERNAME with your own username.

**sherlyk** · 01-05-2015, 03:48 PM

All commands except the last one worked fine for me .The last command gives me followimg message

**admin** · 01-05-2015, 09:08 PM

last command, it is just warning. Not an error. So that is fine.

Now to access phpMyAdmin, go to URL.

http://localhost/phpmyadmin

**sherlyk** · 01-06-2015, 04:30 AM

When I access that url, getting error. Please see the attached screenshot.

**admin** · 01-06-2015, 05:22 AM

Install MySQL extension for PHP.

Code:

sudo apt-get install php5-mysql

Restart Apache.

**sherlyk** · 01-06-2015, 06:07 AM

I got error message "mysqli extension is missing. Please check your PHP configuration."

Then installed MySQL extension for PHP using below command:

Code:

sudo apt-get install php5-mysql

After that, edited /etc/php5/apache2/php.ini file and uncommented below line:

mysqli.allow_local_infile = On

and restarted apache server. This resolved the error and phpmyadmin started working.