phpmyadmin

phpMyAdmin

It is a free web based MySQL database Administration Tool. It makes mysql database administration very easy using graphical interface. Without phpMyAdmin it is very difficult to mysql database operations in the command line. phpMyAdmin has become so convenient and it is absolutely sought by most webmasters to be present along with the mysql server.

yum install phpmyadmin

Point your browser to: http://ip.address/phpmyadmin.

Common Errors

You might encounter the following errors while configuring phpmyadmin.

Forbidden: You don't have permission to access /phpmyadmin/ on this server.

To fix:

Edit the /etc/httpd/conf.d/phpmyadmin.conf and uncomment the line deny from all.

nano /etc/httpd/conf.d/phpmyadmin.conf

  Order Deny,Allow
  # Deny from all
  Allow from 127.0.0.1
  

Error: The configuration file now needs a secret passphrase (blowfish_secret)

To fix:

nano /usr/share/phpmyadmin/config.inc.php

Look for a line and enter any password. Just dont leave it empty!

$cfg['blowfish_secret'] = 'mydemopass'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

It worked for me using the above methods! 
Log into the phpmyadmin with the mysql root password we changed while installing the mysql database.