该版本与mysql配置查询相关日志参数有差异, 特此记录
查询日志
general_log = ON
general_log_file = /var/lib/log/mysql/localhost.localdomain.general_log
错误日志
log_err = /var/lib/mysql/localhost.localdomain.err
慢查询日志
slow_query_log = ON
slow_query_log_file = /var/lib/mysql/localhost.localdomain.slow_query_log
long_query_time = 1
更新日志
log_slave_updates = 1
二进制文件
log_bin = /var/lib/mysql/localhost.localdomain.log_bin
更改用户名密码
password(‘加密前’)
‘*加密后’
update mysql.user set password=password(‘N2NmNDVkMDFiNTM4’) where user=‘test’;
update mysql.user set password=’*abcdete’ where user=‘roott’;