Re: 想重編MYSQL??不知道怎麼編?? - BBS
By Tom
at 2006-04-11T20:00
at 2006-04-11T20:00
Table of Contents
※ 引述《[email protected] ("管樂社"歡迎你加入~)》之銘言:
: ※ 引述《[email protected] (小菜)》之銘言:
: > 最後個人是到/var/db
: > 然後將MYSQL資料夾全砍了,
: > 這樣就OK了!
: > GOOGLE找上述錯誤訊息
: > 說明是說MYSQL未啟動,
: > 不過我明明下了
: > /usr/local/etc/rc.d/mysql-server.sh start
: > 真奇怪!
我是裝MySQL 5.0.19
也是有一樣的問題
你可以看看/var/db/mysql/[hostname].err
的錯誤訊息(假設預設安裝位置沒改)
像我的問題 應該是 --defaults-extra-file 的bug問題
拿掉就了ok了
不過記得確定是不是有...
chown -R mysql /var/db/mysql
chgrp -R mysql /var/db/mysql
: 我也跟你遇到一樣的問題~
: 把他mysql砍掉後就可以用了~
: 加上我的做法跟錯誤碼
: rm -r /var/db/mysql
: /usr/local/etc/rc.d/mysql-server.sh start
: /usr/local/bin/mysql
: warning code:
: 060410 16:49:11 [Warning] './mysql/host' had no or invalid character set, and de
: 060410 16:49:11 [Warning] './mysql/user' had no or invalid character set, and de
: 060410 16:49:11 [Warning] './mysql/db' had no or invalid character set, and defa
: 060410 16:49:11 [ERROR] Fatal error: mysql.user table is damaged or in unsupport
: 060410 16:49:11 mysqld ended
:
--
PLUR
--
: ※ 引述《[email protected] (小菜)》之銘言:
: > 最後個人是到/var/db
: > 然後將MYSQL資料夾全砍了,
: > 這樣就OK了!
: > GOOGLE找上述錯誤訊息
: > 說明是說MYSQL未啟動,
: > 不過我明明下了
: > /usr/local/etc/rc.d/mysql-server.sh start
: > 真奇怪!
我是裝MySQL 5.0.19
也是有一樣的問題
你可以看看/var/db/mysql/[hostname].err
的錯誤訊息(假設預設安裝位置沒改)
像我的問題 應該是 --defaults-extra-file 的bug問題
拿掉就了ok了
不過記得確定是不是有...
chown -R mysql /var/db/mysql
chgrp -R mysql /var/db/mysql
: 我也跟你遇到一樣的問題~
: 把他mysql砍掉後就可以用了~
: 加上我的做法跟錯誤碼
: rm -r /var/db/mysql
: /usr/local/etc/rc.d/mysql-server.sh start
: /usr/local/bin/mysql
: warning code:
: 060410 16:49:11 [Warning] './mysql/host' had no or invalid character set, and de
: 060410 16:49:11 [Warning] './mysql/user' had no or invalid character set, and de
: 060410 16:49:11 [Warning] './mysql/db' had no or invalid character set, and defa
: 060410 16:49:11 [ERROR] Fatal error: mysql.user table is damaged or in unsupport
: 060410 16:49:11 mysqld ended
:
--
PLUR
--
Tags:
BBS
All Comments
Related Posts
請問我的Hinet-ADSL可撥接但連不上?
By Zora
at 2006-04-10T20:17
at 2006-04-10T20:17
Re: 請問鍵盤的問題
By Jacob
at 2006-04-10T18:05
at 2006-04-10T18:05
no buffer space available
By Charlotte
at 2006-04-09T15:23
at 2006-04-09T15:23
no buffer space available
By Steve
at 2006-04-09T10:41
at 2006-04-09T10:41
FreeBSD是否有可能裝在Intel base MAC
By Selena
at 2006-04-09T03:56
at 2006-04-09T03:56