mysqld error general log arch linux

[root@icsserver mysql]# mkdir /var/lib/mysql/log


[root@icsserver mysql]# chown mysql:mysql /var/lib/mysql/log


[root@icsserver mysql]# touch /var/lib/mysql/log/mysqld_error.log


[root@icsserver mysql]# chown mysql:mysql /var/lib/mysql/log/mysqld_error.log


[root@icsserver mysql]# touch /var/lib/mysql/log/mysqld_general.log


[root@icsserver mysql]# chown mysql:mysql /var/lib/mysql/log/mysqld_general.log


[root@icsserver mysql]# systemctl disable mysqld
rm '/etc/systemd/system/multi-user.target.wants/mysqld.service'


[root@icsserver mysql]# mcedit /usr/lib/systemd/system/mysqld.service


[root@icsserver mysql]# grep -i exec /usr/lib/systemd/system/mysqld.service
ExecStart=/usr/bin/mysqld  --log-error=/var/lib/mysql/log/mysqld_error.log --general_log=1 --general_log_file=/var/lib/mysql/log/mysqld_general.log --pid-file=/run/mysqld/mysqld.pid
ExecStartPost=/usr/bin/mysqld-post


[root@icsserver mysql]# ls --full /var/lib/mysql/log/
total 8
-rw-r--r-- 1 mysql mysql 4032 2013-11-04 14:25:14.517868060 +0000 mysqld_error.log
-rw-r--r-- 1 mysql mysql  334 2013-11-04 14:25:15.234544248 +0000 mysqld_general.log


[root@icsserver mysql]# ls --full /var/lib/mysql/ | grep log
-rw-rw---- 1 mysql mysql    32768 2013-11-04 13:49:10.689244486 +0000 aria_log.00000001
-rw-rw---- 1 mysql mysql       52 2013-11-04 13:49:10.672577600 +0000 aria_log_control
-rw-rw---- 1 mysql mysql  5242880 2013-11-04 13:49:12.239264945 +0000 ib_logfile0
-rw-rw---- 1 mysql mysql  5242880 2013-10-25 00:34:47.270276048 +0100 ib_logfile1
drwxr-xr-x 2 mysql mysql     4096 2013-11-04 13:59:55.757764407 +0000 log


[root@icsserver mysql]# systemctl enable mysqld
ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/multi-user.target.wants/mysqld.service'


[root@icsserver mysql]# systemctl restart mysqld


[root@icsserver mysql]# cat /var/lib/mysql/log/mysqld_error.log
131104 14:05:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131104 14:05:08 InnoDB: Compressed tables use zlib 1.2.8
131104 14:05:08 InnoDB: Initializing buffer pool, size = 128.0M
131104 14:05:08 InnoDB: Completed initialization of buffer pool
131104 14:05:08 InnoDB: highest supported file format is Barracuda.
131104 14:05:09  InnoDB: Waiting for the background threads to start
131104 14:05:10 Percona XtraDB (http://www.percona.com) 5.5.33a-MariaDB-31.1 started; log sequence number 66089306
131104 14:05:10 [Note] Event Scheduler: Loaded 0 events
131104 14:05:10 [Note] /usr/bin/mysqld: ready for connections.
Version: '5.5.33a-MariaDB-log'  socket: '/run/mysqld/mysqld.sock'  port: 0  Source distribution


[root@icsserver mysql]# cat /var/lib/mysql/log/mysqld_general.log
/usr/bin/mysqld, Version: 5.5.33a-MariaDB-log (Source distribution). started with:
Tcp port: 0  Unix socket: /run/mysqld/mysqld.sock
Time                 Id Command    Argument
131104 14:25:15     1 Connect   Access denied for user 'UNKNOWN_USER'@'localhost' (using password: NO)
                    1 Connect   UNKNOWN_USER@localhost as anonymous on