users can see all phpmyadmin user database, how to prevent it?

[Biswashost]

Hi, recently I notice by one of my users that any users of my cwp servers can see all phpmyadmin database and can do any operation with any database which one actually he is not the owner. I tried several things, like: fixing all account permission, reinstall mariadb, change mysql password, rebuild the server, rebooting the server but nothing is working. It's affected only 1 of my VPS server that are running under KVM. Does anyone know the causes & if you know the solutions then kindly reply here quickly, I am in big trouble. Thanks.

[Biswashost]

Hi, I got the solution. Some how in my phpmyadmin "User accounts" section added a entry like: Any -->localhost--->yes--->usage--->No, So this entry means anyone can login to main localhost if anyone have a authorized user id & password. So, solution is just remove that user from the table. That's all. Hope it will help any one else. Today full night is gone to investigate this issue.

[iraqiboy90]

This is actually one of the first questions I had when joining this forum for the first time.
https://forum.centos-webpanel.com/index.php?topic=11602.msg39624#msg39624

So, it should be included in your notes to remove the "any" account after installing a new server.

[Biswashost]

This is actually one of the first questions I had when joining this forum for the first time.
https://forum.centos-webpanel.com/index.php?topic=11602.msg39624#msg39624

So, it should be included in your notes to remove the "any" account after installing a new server.

I already replied it about how to solved it. Thanks for your reply, at least someone replied me.

[anandmys]

Hi, I got the solution. Some how in my phpmyadmin "User accounts" section added a entry like: Any -->localhost--->yes--->usage--->No, So this entry means anyone can login to main localhost if anyone have a authorized user id & password. So, solution is just remove that user from the table. That's all. Hope it will help any one else. Today full night is gone to investigate this issue.

Thanks a ton. I was struggling with this. SOLVED