1. Workaround for installing phpMyAdmin on CentOS

    Having mysql/php/apache already setup I decided to install phpMyAdmin, however because the mysql is Percona there were some dependency checks that failed.

    After a lot of trial and error the following did the trick:

    #stop the services
/etc/init.d/httpd stop
/etc/init.d/mysql stop

#remove mysql
yum --enablerepo=remi remove Percona* mysql*

#install everything in one shot
yum --enablerepo=remi install Percona-Server-server-55 Percona-Server-client-55 phpMyAdmin

#start the services
/etc/init.d/httpd start
/etc/init.d/mysql start

#rerun the secure installation script
/usr/bin/mysql_secure_installation

    Once that has finished you’ll need to edit the apache config to allow you remote access to the phpMyAdmin site:

    nano /etc/httpd/conf.d/phpMyAdmin.conf

#add allow from your ip address
allow from 123.456.789.101

    You should now be able to access it at http://example.com/phpMyAdmin/

Notes

  1. trialbybyte posted this