show variables

 

#查看日志路径
show variables like 'log_%';

# mysql数据目录
show global variables like "%datadir%"


#查看慢查询
show variables like '%slow_query%';
show variables like '%quer%';
show global variables like '%long_query%';

#查看时区
show variables like '%time_zone%';

# 字符集
show variables like 'character%'

# 排序规则
show variables like 'collation%';

 

SELECT @@GLOBAL.time_zone, @@SESSION.time_zone;