[root@localhost var]# vi /etc/my.cnf log-bin=/usr/local/mysql/data/mylog --添加log-bin参数 [root@localhost var]# service mysqld stop mysqld: unrecognized service [root@localhost var]# service mysql stop shutting down mysql.... [ ok ] [root
[root@localhost var]# vi /etc/my.cnf
log-bin=/usr/local/mysql/data/mylog --添加log-bin参数
[root@localhost var]# service mysqld stop
mysqld: unrecognized service
[root@localhost var]# service mysql stop
shutting down mysql.... [ ok ]
[root@localhost var]# service mysql start
starting mysql.the server quit without updating pid file (/[failed]l/mysql/var/localhost.localdomain.pid).
[root@localhost var]# service mysql start
starting mysql.the server quit without updating pid file (/[failed]l/mysql/var/localhost.localdomain.pid).
[root@localhost var]# tail -25 localhost.localdomain.err
140805 13:43:22 mysqld_safe starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/bin/mysqld: file '/usr/local/mysql/data/mylog.index' not found (errcode: 13)
140805 13:43:22 [error] aborting
140805 13:43:22 [note] /usr/local/mysql/bin/mysqld: shutdown complete
140805 13:42:53 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
[root@localhost mysql]# ll /usr/local/mysql/
total 80
-rw-r--r-- 1 root mysql 17987 aug 29 2012 copying
-rw-r--r-- 1 root mysql 7604 aug 29 2012 install-binary
-rw-r--r-- 1 root mysql 2552 aug 29 2012 readme
drwxr-xr-x 2 root mysql 4096 dec 26 2013 bin
drwxr-xr-x 4 root mysql 4096 dec 26 2013 data
drwxr-xr-x 2 root mysql 4096 dec 26 2013 docs
drwxr-xr-x 3 root mysql 4096 dec 26 2013 include
drwxr-xr-x 3 root mysql 4096 dec 26 2013 lib
drwxr-xr-x 4 root mysql 4096 dec 26 2013 man
drwxr-xr-x 10 root mysql 4096 dec 26 2013 mysql-test
drwxr-xr-x 2 root mysql 4096 dec 26 2013 scripts
drwxr-xr-x 27 root mysql 4096 dec 26 2013 share
drwxr-xr-x 4 root mysql 4096 dec 26 2013 sql-bench
drwxr-xr-x 2 root mysql 4096 dec 26 2013 support-files
drwx------ 5 mysql mysql 4096 aug 5 13:46 var
[root@localhost mysql]# chown -r mysql /usr/local/mysql/data --更改data目录属主
[root@localhost mysql]# ll /usr/local/mysql/
total 80
-rw-r--r-- 1 root mysql 17987 aug 29 2012 copying
-rw-r--r-- 1 root mysql 7604 aug 29 2012 install-binary
-rw-r--r-- 1 root mysql 2552 aug 29 2012 readme
drwxr-xr-x 2 root mysql 4096 dec 26 2013 bin
drwxr-xr-x 4 mysql mysql 4096 dec 26 2013 data
drwxr-xr-x 2 root mysql 4096 dec 26 2013 docs
drwxr-xr-x 3 root mysql 4096 dec 26 2013 include
drwxr-xr-x 3 root mysql 4096 dec 26 2013 lib
drwxr-xr-x 4 root mysql 4096 dec 26 2013 man
drwxr-xr-x 10 root mysql 4096 dec 26 2013 mysql-test
drwxr-xr-x 2 root mysql 4096 dec 26 2013 scripts
drwxr-xr-x 27 root mysql 4096 dec 26 2013 share
drwxr-xr-x 4 root mysql 4096 dec 26 2013 sql-bench
drwxr-xr-x 2 root mysql 4096 dec 26 2013 support-files
drwx------ 5 mysql mysql 4096 aug 5 13:46 var
[root@localhost mysql]# service mysql start
starting mysql.. [ ok ]