| Server IP : 221.132.30.236 / Your IP : 216.73.216.91 [ Web Server : Apache System : Linux web3.trangwebvang.net 2.6.32-954.3.5.lve1.4.86.el6.x86_64 #1 SMP Tue Aug 31 17:08:39 UTC 2021 x86_64 User : cherishhotel ( 944) PHP Version : 5.6.40 Disable Function : exec, system,passthru,shell_exec,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,popen,show_source,proc_nice, proc_terminate, proc_get_status, proc_close, pfsockopen, leak, apache_child_terminate, posix_kill, posix_mkfifo, posix_setpgid, posix_setsid, posix_setuid,dl,symlink Domains : 0 Domains MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /scripts/ |
Upload File : |
#!/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."