SQL-cheat-sheet.sql

CREATE USER `user`@`%` IDENTIFIED VIA mysql_native_password USING '*6048229B303DAF9E889FCB02B385C27823607B85' OR unix_socket; 
SHOW CREATE USER `user`@`%`\G 
GRANT ALL PRIVILEGES ON *.* TO `user`@`%`;
FLUSH PRIVILEGES;
 
SET GLOBAL general_log = 'ON';
SET GLOBAL log_output='TABLE';
SET GLOBAL slow_query_log=1;
SET GLOBAL log_output='TABLE';
SET GLOBAL long_query_time=5.0;
SET GLOBAL log_queries_not_using_indexes=ON;
SET GLOBAL min_examined_row_limit=100000;
SET GLOBAL log_slow_admin_statements=ON;
SET GLOBAL log_slow_filter='filesort,filesort_on_disk,tmp_table,tmp_table_on_disk';
SET GLOBAL log_slow_rate_limit=5;
SET GLOBAL log_slow_verbosity='query_plan,explain';
SET GLOBAL userstat=1;
SET GLOBAL SQL_WARNINGS = 'ON';
SET GLOBAL general_log = 'OFF';
ALTER TABLE mysql.general_log ENGINE = MyISAM;
SET GLOBAL general_log = 'ON';
SHOW CREATE TABLE mysql.general_log\G;

SHOW CREATE TABLE mysql.slow_query_log\G;
select @@datadir;
select @@version;
select @@socket;

SELECT @@GLOBAL.innodb_data_file_path
INTO OUTFILE './GLOBAL.innodb_data_file_path.csv'
    FIELDS TERMINATED BY ','
    ENCLOSED BY '"'
    LINES TERMINATED BY '\n';

SELECT * FROM
  INFORMATION_SCHEMA.SYSTEM_VARIABLES
INTO OUTFILE 'GLOBAL_VAR'
FIELDS TERMINATED BY ','
    ENCLOSED BY '"'
    LINES TERMINATED BY '\n';