How to reset forgoten mysql root password

It is very frustrating when you can not remember your mysql password, but don’t panic there is a quick way to reset it and it only takes one minute. This should work on CentOS 6 and 7 and RedHat distributions.

Install phpMyAdmin CentOS7

In this write up will will look into installing phpMyadmin web based front end for MariaDB and MySQL databases on CentOS7. In our example we will provide ip address 192.168.0.11 and 192.168.0.12 on local network access to phpMyadmin on web server websrv1 while denying access to everyone else. We assume LAMP stack was already deployed…