List all cPanel users having Wildcard Remote Mysql Access
Remote MySQL option in cPanel allows other webservers to access the MySQL database on your server remotely.
Remote MySQL option can be very handy, if you want to allow applications like shopping carts or guestbooks on your other servers to access the databases.
But on the contrary, if the Remote MySQL option is not handled with care then it can lead to database hacks.
So, If you want to find out all cPanel users having Wildcard Access enabled then you can use the below simple command :
[code]root@server[#]mysql -N mysql -e “Select User from user where Host=’%'” | awk -F _ ‘{print $1}’ | uniq[/code]