昨晚在FreeBSD7.0上面源码安装MySQL5.0 配置 编译都没出什么问题
准备运行启动的时候却怎么也启动不了 极度郁闷
在RHEL4.0上装过 大多的错误都是因为权限问题 但这里/var/mysql已经是mysql:mysql
重试几次 仍是不行 只好more /var/dream.com.err 大致的几个错误:
dream#/etc/rc.d/
mysql start
Starting MySQLkill: 754 : No such process
ERROR!
/usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm '
Fatal error: Can 't open and lock privilege tables: Can't find file: './mysql/host.frm'
/usr/local/mysql/libexec/mysqld: Can't create/write to file '/var/dream.com.pid '
Can 't start server: can't create PID file: Permission denied
Starting MySQLkill: 754 : No such process
ERROR!
/usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm '
Fatal error: Can 't open and lock privilege tables: Can't find file: './mysql/host.frm'
/usr/local/mysql/libexec/mysqld: Can't create/write to file '/var/dream.com.pid '
Can 't start server: can't create PID file: Permission denied
看了下 /var目录的权限drwxr-xr-x 额~~ 那就这样吧:
dream# chmod o+w /
var
dream# /etc/rc.d/ mysql start
Starting MySQL SUCCESS!
dream# /etc/rc.d/ mysql start
Starting MySQL SUCCESS!
麦高!我已无语~~
想想 最好是这样:chmod a+wt /var 加个sticky模式 恩哈!o(∩_∩)o