Installing phpmyadmin on centOS 6.3


phpMyAdmin is a free and open source tool used to handle mySQL database functionalities via web browser. Creating, editing or dropping databases, fields or tables can be done in this tool with a click of a button (instead of typing long queries).

This is a simple guide intended to install phpMyAdmin version 3.5.4 on CentOS 6.3.
First of all, you have to have LAMP (Linux Apache MySQL and PHP) installed and configured, if you haven't done so yet, follow the steps in this link, before proceeding here. :) 


1. In your terminal access root priveleges by typing su and type yum update to update your system. (though you could do this step later on. but it is advisable that your system is updated, before everything else)


2. Install the REMI repository by typing the following commands: rpm –Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm and rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

3. Now, it’s time to install phpmyadmin, type yum --enablerepo=remi install phpMyAdmin (take note that it's phpMyAdmin, not phpmyadmin -- because installing phpmyadmin <- with that spelling, will download an older version of phpMyAdmin... installing phpMyAdmin <- with that spelling, will download and install a recent version of the software)


4. Type service httpd restart to restart your apache server.

5. Go to your browser and type localhost/phpmyadmin , if you see this screen you have successfully installed phpmyadmin to your system. 


6. On the unlikely event that you couldn’t log in to phpmyadmin because of an error (#1045), go to your terminal, access root privileges (type su), and reset your mysql password by typing the following command mysqladmin –u root password <newpassword> (where <newpassword is your new password).