show variables like 'gen%';
set global general_log=ON;
show variables like '%log_output%';
set global log_output='TABLE';
select * from mysql.general_log;
set global log_output='FILE';
truncate table mysql.general_log;
修改数据库密码:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new密码';