phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a Web browser. It is a tools that giving users the ability to interact with their MySQL databases to perform the task such as creating, modifying or drop databases, executing SQL statements, managing users and set permissions. This post will show you the steps on how to setup phpMyAdmin 3.5.1 on CentOS 6.2 using remi repository.
Prerequisites :
How to Install Remi yum Repository on CentOS 6.2 x86 and x86_64
Simply execute the following command to install phpmyadmin :
[root@centos62 ~]# yum install phpmyadmin -y Loaded plugins: fastestmirror, priorities Determining fastest mirrors * base: mirror.averse.net * extras: mirror.yourconnect.com * remi: iut-info.univ-reims.fr * remi-test: iut-info.univ-reims.fr * updates: mirror.yourconnect.com base | 3.7 kB 00:00 base/primary_db | 3.5 MB 00:34 extras | 3.5 kB 00:00 extras/primary_db | 9.1 kB 00:00 remi | 2.9 kB 00:00 remi/primary_db | 259 kB 00:02 remi-test | 2.9 kB 00:00 remi-test/primary_db | 80 kB 00:01 updates | 3.5 kB 00:00 updates/primary_db | 3.9 MB 00:35 Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package phpMyAdmin.noarch 0:3.5.1-1.el6.remi will be installed --> Processing Dependency: php-mysql >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.remi.noarch --> Processing Dependency: php-mcrypt >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.remi.noarch --> Processing Dependency: php-mbstring >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.remi.noarch --> Processing Dependency: php-gd >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.remi.noarch --> Running transaction check ---> Package php-gd.i686 0:5.4.4-1.el6.remi will be installed ---> Package php-mbstring.i686 0:5.4.4-1.el6.remi will be installed ---> Package php-mcrypt.i686 0:5.4.4-1.el6.remi will be installed ---> Package php-mysql.i686 0:5.4.4-1.el6.remi will be installed --> Processing Dependency: php-pdo(x86-32) = 5.4.4-1.el6.remi for package: php-mysql-5.4.4-1.el6.remi.i686 --> Running transaction check ---> Package php-pdo.i686 0:5.4.4-1.el6.remi will be installed --> Finished Dependency Resolution Dependencies Resolved ==================================================================================================== Package Arch Version Repository Size ==================================================================================================== Installing: phpMyAdmin noarch 3.5.1-1.el6.remi remi 4.7 M Installing for dependencies: php-gd i686 5.4.4-1.el6.remi remi-test 132 k php-mbstring i686 5.4.4-1.el6.remi remi-test 921 k php-mcrypt i686 5.4.4-1.el6.remi remi-test 41 k php-mysql i686 5.4.4-1.el6.remi remi-test 122 k php-pdo i686 5.4.4-1.el6.remi remi-test 107 k Transaction Summary ==================================================================================================== Install 6 Package(s) Total download size: 6.0 M Installed size: 21 M Downloading Packages: (1/6): php-gd-5.4.4-1.el6.remi.i686.rpm | 132 kB 00:11 (2/6): php-mbstring-5.4.4-1.el6.remi.i686.rpm | 921 kB 00:28 (3/6): php-mcrypt-5.4.4-1.el6.remi.i686.rpm | 41 kB 00:01 (4/6): php-mysql-5.4.4-1.el6.remi.i686.rpm | 122 kB 00:02 (5/6): php-pdo-5.4.4-1.el6.remi.i686.rpm | 107 kB 00:01 (6/6): phpMyAdmin-3.5.1-1.el6.remi.noarch.rpm | 4.7 MB 01:14 ---------------------------------------------------------------------------------------------------- Total 50 kB/s | 6.0 MB 02:04 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : php-gd-5.4.4-1.el6.remi.i686 1/6 Installing : php-mcrypt-5.4.4-1.el6.remi.i686 2/6 Installing : php-pdo-5.4.4-1.el6.remi.i686 3/6 Installing : php-mysql-5.4.4-1.el6.remi.i686 4/6 Installing : php-mbstring-5.4.4-1.el6.remi.i686 5/6 Installing : phpMyAdmin-3.5.1-1.el6.remi.noarch 6/6 Installed: phpMyAdmin.noarch 0:3.5.1-1.el6.remi Dependency Installed: php-gd.i686 0:5.4.4-1.el6.remi php-mbstring.i686 0:5.4.4-1.el6.remi php-mcrypt.i686 0:5.4.4-1.el6.remi php-mysql.i686 0:5.4.4-1.el6.remi php-pdo.i686 0:5.4.4-1.el6.remi Complete!
[root@centos62 ~]# vim /etc/httpd/conf.d/phpMyAdmin.conf
Original configuration file :
Alias /phpMyAdmin /usr/share/phpMyAdmin Alias /phpmyadmin /usr/share/phpMyAdmin <Directory /usr/share/phpMyAdmin/> order deny,allow deny from all allow from 127.0.0.1 allow from ::1 </Directory>
Modify to the following :
Alias /phpMyAdmin /usr/share/phpMyAdmin Alias /phpmyadmin /usr/share/phpMyAdmin <Directory /usr/share/phpMyAdmin/> order deny,allow deny from all allow from 127.0.0.1 allow from all </Directory>
Once configured, restart the httpd as below :
[root@centos62 ~]# service httpd restart
Login to the phpmyadmin as below :
http://192.168.1.44/phpmyadmin
