httpd-xampp.conf: How to allow access to an external IP besides localhost in phpmyadmin for ubuntu?

If you want to access phpMyAdmin from a static IP besides localhost, then you’re in right place, just follow the below steps :- Step 1 :- First locate httpd-xampp.conf file, for Ubuntu it’s located at /opt/lampp/etc/extra/ Step 2 :- open httpd-xampp.conf file for editing. you’ll find something live below code Step 3 :- add Require ip your_ip_address below Require local . Step 4 :- Add your static IP address after Require ip your_static_ip. It’s Done. Now Check to access your_ip_address/phpmyadmin

How to change Phpmyadmin MySQL Root Password with XAMPP on Localhost on Ubuntu.

At First we have to find that which root user password we want change because there are 3 root user password are in phpMyAdmin. To find, first fill root on username and leave blank password and click on Go, it will show which user you are trying to login. In my case i’m logging in root@localhost so i’ll change that password after logging in phpmyadmin. So, login in your phpmyadmin. After login you’ll see User Accounts Section on the top.