Private
Server IP : 68.178.168.24  /  Your IP : 3.148.241.210
Web Server : Apache
System : Linux 24.168.178.68.host.secureserver.net 3.10.0-1160.119.1.el7.tuxcare.els19.x86_64 #1 SMP Mon Mar 31 17:29:00 UTC 2025 x86_64
User : realcarecert ( 1247)
PHP Version : 7.4.33
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /scripts/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /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."
Private