Server IP : 192.168.23.10 / Your IP : 3.128.168.219
Web Server : Apache
System : Linux echo.premieradvertising.com 5.14.0-362.8.1.el9_3.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Nov 7 14:54:22 EST 2023 x86_64
User : rrrallyteam ( 1049)
PHP Version : 8.1.31
Disable Function : exec,passthru,shell_exec,system
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF
Directory (0755) : /scripts/

[ Home ]	[ C0mmand ]	[ Upload File ]

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."