MySQL数据文件说明(二)
..... [ OK ]
启动成功，查看进程：
[root@rac2 mysql]# ps -ef|grep mysql root 11512 1 2 21:02 pts/2 00:00:00 /bin/sh /usr/bin/mysqld_safe--datadir=/u01/mysql --pid-file=/u01/mysql/rac2.pid mysql 11769 11512 5 21:02 pts/2 00:00:00 /usr/sbin/mysqld --basedir=/usr--datadir=/u01/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql--log-error=/u01/mysql/rac2.err --pid-file=/u01/mysql/rac2.pid--socket=/u01/mysql/mysql.sock --port=3306 root 11796 3799 0 21:02 pts/2 00:00:00 grep mysql
2.7 其中的小插曲：
之前给/u01/mysql 目录赋的755 权限，但是启动报错：
[root@rac2 mysql]# service mysql start Starting MySQL....The server quit withoutupdating PID file[FAILED]ysql/rac2.pid).
查看log：
/u01/mysql/rac2.err 111130 20:59:34 [Note] /usr/sbin/mysqld:Shutdown complete 111130 20:59:34 mysqld_safe mysqld from pidfile /u01/mysql/rac2.pid ended 111130 21:02:25 mysqld_safe Starting mysqlddaemon with databases from /u01/mysql /usr/sbin/mysqld: File './mysql-bin.~rec~'not found (Errcode: 13) 111130 21:02:25 [ERROR]MYSQL_BIN_LOG::open_purge_index_file failed to open register file. 111130 21:02:25 [ERROR]MYSQL_BIN_LOG::open_index_file failed to sync the index file. 111130 21:02:25 [ERROR] Aborting
应该是权限不够，不能创建pid 文件，赋给777 权限后，正常：
chmod -R 777 /u01/mysql [root@rac2 mysql]# ll /u01/mysql/rac2.pid -rw-rw---- 1 mysql mysql 6 Nov 30 21:02/u01/mysql/rac2.pid