After doing the most recent update root password no longer works in phpmyadmin could you please lookin to fixing this as i have gone to zpanel for till this problem can be fixed
This is a new security feature to make it harder for your server to be hacked. You need to whitelist your IP address by doing the following:
sudo -i
sed -i "s#^include_once 'rootip_whitelist_functions.php';#include_once '/usr/share/phpmyadmin/rootip_whitelist_functions.php';#g" "/etc/phpmyadmin/config.inc.php"
sed -i "s#^include 'rootip_whitelist.php';#include '/usr/share/phpmyadmin/rootip_whitelist.php';#g" "/etc/phpmyadmin/config.inc.php"
cd /usr/share/phpmyadmin/
nano rootip_whitelist.php
From the computer you are using to access PHPMyAdmin, browse to
www.grabip.tk to get your IP address. Write it down.
Now, while editing the rootip_whitelist.php file, find the line of:
// IP Addresses that are allowed to login via the root MySQL account through PHPMyAdmin
$allowedIPs = array("127.0.0.1");
Add your IP address to the array. It should look something like this:
// IP Addresses that are allowed to login via the root MySQL account through PHPMyAdmin
$allowedIPs = array("127.0.0.1", "1.1.1.1");
In the example above, the IP address of 1.1.1.1 was used. Replace that value with the one you found from
http://www.grabip.tk.
Save the file. You can now login as the root user from that machine.
In general, you should not login as the root user from an insecure connection. The root mysql user account is very important to keep secure.
To DISABLE this Feature Completely and Allow root Logins via PHPMyAdmin:If you want to allow the MySQL root user to login via PHPMyAdmin, simply run the following command:
sudo sh -c "echo \"<?php \\\$cfg['Servers'][1]['AllowRoot'] = TRUE; ?>\" >/usr/share/phpmyadmin/rootip_whitelist.php"
If you DO NOT want the root user to login using PHPMyAdmin from any IP address, simply clear the file by running this command:sudo sh -c ">/usr/share/phpmyadmin/rootip_whitelist.php"
Updates and upgrades will not overwrite the rootip_whitelist.php file even if it's empty.