Heray-Was-Here
Server : Apache
System : Linux vps37394.inmotionhosting.com 3.10.0-1160.119.1.vz7.224.4 #1 SMP Mon Sep 30 15:36:27 MSK 2024 x86_64
User : jasonp18 ( 1000)
PHP Version : 7.4.33
Disable Function : exec,passthru,shell_exec,system
Directory :  /proc/3/task/3/root/scripts/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //proc/3/task/3/root/scripts/cleanupmysqlprivs
#!/bin/bash

echo -n "Cleaning up mysql privs.  Please ignore errors about non-existent columns as you may have an older version of mysql....."

mysql -v -f mysql <<EOM
update user set Create_priv='N' where Create_priv='Y' and User != 'root';
update user set Create_tmp_table_priv='N' where Create_tmp_table_priv='Y' and User != 'root';
update user set Lock_tables_priv='N' where Lock_tables_priv='Y' and User != 'root';
update user set Execute_priv='N' where Execute_priv='Y' and User != 'root';
EOM
mysqladmin reload

echo "Done."

Hry