我有这个人的serverfault链接相同的问题，但解决scheme完全不适合我。 我无法第一次启动mysql5.5。 一开始用mysql
cd /usr/local ; /usr/local/bin/mysqld_safe & 其他尝试的开关 – >
--user=mysql --socket=/var/run/mysql/mysql.sock
我已经重新安装数据库使用：
mysql_install_db --user=mysql --basedir=/usr/local --datadir=/var/db/mysql
我已经重新安装了每一个可能的组合，而且总是有相同的错误
150309 06:20:27 mysqld_safe Starting mysqld daemon with databases from /usr/local/bin/data/mysql 150309 6:20:27 [Note] Plugin 'InnoDB' is disabled. /usr/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist 150309 6:20:27 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 150309 6:20:27 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 150309 6:20:27 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 150309 6:20:27 [Note] Server socket created on IP: '0.0.0.0'. 150309 6:20:27 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 150309 06:20:27 mysqld_safe mysqld from pid file /usr/local/bin/data/mysql/yoda.com.pid ended
我的数据目录权限是：
[\u@yoda:/usr/local] # ls -l /usr/local/bin/data total 110700 -rw-rw---- 1 root wheel 50331648 Mar 8 19:50 ib_logfile0 -rw-rw---- 1 root wheel 50331648 Mar 8 19:50 ib_logfile1 -rw-rw---- 1 root wheel 12582912 Mar 8 19:50 ibdata1 drwxrwxr-x 2 mysql mysql 512 Mar 9 06:20 mysql drwx------ 2 root wheel 2560 Mar 8 19:50 performance_schema drwx------ 2 root wheel 512 Mar 8 19:50 test [\u@yoda:/usr/local] # ls -l /usr/local/bin/data/mysql/ total 8 -rw-r----- 1 mysql mysql 4632 Mar 9 06:20 yoda.com.err [\u@yoda:/usr/local] # ls -l /var/db/ total 1776 drwxr-xr-x 5 mysql mysql 512 Mar 9 04:44 mysql [\u@yoda:/usr/local] # ls -l /var/db/mysql/ total 12436 -rw-rw---- 1 mysql mysql 12582912 Mar 8 11:37 ibdata1 drwx------ 2 mysql mysql 2048 Mar 9 04:02 mysql drwx------ 2 mysql mysql 1024 Mar 9 04:44 performance_schema drwx------ 2 mysql mysql 512 Mar 8 11:43 test -rw-r----- 1 mysql mysql 104477 Mar 9 03:56 yoda.com.err
你如何在FreeBSD上启动mysql？