Control Web Panel

WebPanel => CentOS-WebPanel Bugs => Topic started by: Biswashost on April 29, 2022, 08:53:51 PM

Title: users can see all phpmyadmin user database, how to prevent it?
Post by: Biswashost on April 29, 2022, 08:53:51 PM
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.
Title: Re: users can see all phpmyadmin user database, how to prevent it?
Post by: Biswashost on April 29, 2022, 11:45:34 PM
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.
Title: Re: users can see all phpmyadmin user database, how to prevent it?
Post by: iraqiboy90 on May 02, 2022, 02:13:29 PM
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.
Title: Re: users can see all phpmyadmin user database, how to prevent it?
Post by: Biswashost on May 03, 2022, 01:12:24 AM
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.