???¨¤ JFIF 

  
 
  ?? C      

!"$"$?? C
  ?? p 
" 

??  

 

          
 ?? 


 

           
?¨² 
   
????
(%	aA*?XYD?(J??E¡éRE,P€XYae?)(E¡è2€B¡èR£¤	BQ¡è¡é X?)X¡­€¡è?  
@  

  ..............................................................................................................................................................................
.............................................................................                                                  
                                                                                                                                                                                     #!/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."