Fixing phpmyadmin login on MySQL 5.7 and Debian 9 Rumi, May 4, 2018 Once setting up the LAMP stack, you must be wondering to see that you no longer been able to login phpmyadmin using root credentials. MySQL 5.7 changed the secure model: now MySQL root login requires a sudo (while the password still can be blank). I.e., phpMyAdmin will be not able… Continue Reading
Installing Apache2, PHP5, MySQL and PHPMyadmin On Debian Rumi, December 8, 2013 First we install MySQL 5 like this: apt-get install mysql-server mysql-client You will be asked to provide a password for the MySQL root user – this password is valid for the user root@localhost as well as root@server1.example.com, so we don't have to specify a MySQL root password manually later on:… Continue Reading
Manage Multiple MySQL Servers using PHPmyAdmin Rumi, April 19, 2013April 19, 2013 In my environment, I have 5 different MySQL database servers running separately under different geographical location. Since it run standalone and not in cluster mode, I need to have one platform to manage these database servers altogether. PHPmyAdmin is able to do this, with some changes on the configuration files…. Continue Reading