Phpmyadmin is a free tool used to administrate MySQL . Phpmyadmin supports all major operation with MySQL in GUI mode.
Before configuring Phpmyadmin refer these steps for installing and configuring apache , mysql and php.
1. Apache2 installation and configuration
2. Mysql installation
3. PHP installation
4. Testing all together
PhpMyadmin installation on Centos 6:
Step 1 » Install/enable EPEL repository . You can find latest repository here ( http://ftp.riken.jp/Linux/fedora/epel/6/i386/repoview/epel-release.html )
Step 2 » Now update repositories
Step 3 » After updating yum repositories , now you can install phpmyadmin package.
This command will install phpmyadmin package along with dependencies . please type thepackage name exactly as phpMyAdmin ( ” M” and “Y” –> Uppercase )
Step 4 » Now restart httpd service
Now open the path in your browser ( Eg-> http://192.168.10.1/phpMyAdmin ) . You can see the below screen after entering Mysql root username and password .
» #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