PhpMyadmin installation

                                  

Phpmyadmin is a free tool used to administrate MySQL . Phpmyadmin supports all major operation with MySQL in GUI mode.

  $ Install/enable EPEL repository .

[root@localhost ~]# rpm -ivh http://ftp.jaist.ac.jp/pub/Linux/Fedora/epel/6/i386/epel-release-6-7.noarch.rpm
                          <or>
[root@localhost ~]# lwp-download http://ftp.jaist.ac.jp/pub/Linux/Fedora/epel/6/i386/epel-release-6-7.noarch.rpm
[root@localhost ~]# rpm -ivh epel-release-6-7.noarch.rpm

 $Now you can install phpmyadmin package
[root@localhost ~]# yum install phpMyAdmin

 $Now restart httpd service
[root@localhost ~]# service httpd restart
Now open the path in your browser ( Eg->  http://192.168.1.1/phpMyAdmin ) . You can see the below screen after entering Mysql root username and password .

Troubleshooting :

»  #2002 – Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
The server is not responding (or the local server’s socket is not correctly configured).

( This means your mysql server service is stopped , you must start the service  “service mysql start”)

» You don’t have permission to access /phpMyAdmin/ on this server.

Open /etc/httpd/conf.d/phpMyAdmin.conf file and find the lines “Deny from All ” and comment those lines and restart httpd service


Now, you can access phpMyAdmin by opening http://your_IP/phpmyadmin. If you get this error: “The configuration file now needs a secret passphrase (blowfish_secret).” then you need to edit the config.inc.php.

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

Find the following line, replace PASSWORD with your password and save the file.

$cfg['blowfish_secret'] = 'PASSWORD';