mysql访问日志记录配置

1.1 创建用于存放连接日志的数据库和表

create database accesslog;
CREATE TABLE accesslog.accesslog (`id` int(11) primary key auto_increment, `time` timestamp, `localname` varchar(30), `matchname` varchar(30))

1.2 创建用户权限
grant read on accesslog.* to root@localhost identified by ‘password’;

1.3 设置init-connect
在[mysqld]下添加以下设置：
init-connect=’insert into accesslog.accesslog values(connection_id(),user(),current_user(),now());’
log-bin

1.4 重启数据库生效
shell> service mysqld restart