在FreeBSD5.1上安装MySQL4.0.22出现的问题

更新prots后，进入/usr/ports/mysql4-server
# : make install clean
# : /usr/local/bin mysql_install_db
# : /usr/local/bin mysqld_safe

启动mysqld_safe执行失败

If your error log file has something like:

Can't find file: './mysql/host.frm' (errno: 13)

, and you've tried setting
--datadir=/path/to/my/data/directory but you
still get the same error, it may be because the
databases installed in the mysql data directory
(usually /var/lib/mysql) are not owned by the
mysql daemon, but by the user who ran
mysql_install_db. chown them to mysql and chgrp
them to the appropriate group e.g.

chown -R mysql /var/lib/mysql/mysql
chgrp -R daemons /var/lib/mysql/mysql
就OK了！