mysql_install_db --user=mysql 出現錯誤

[sunfarng]

大家好:
我的mysql版本是5.0.45 當我將下載的檔案解壓縮之後
依據INSTALL-BINARY說明檔的指示:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf -
shell> ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
shell> cd mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
shell> bin/mysqld_safe --user=mysql &

當我執行scripts/mysql_install_db --user=mysql時出現如下訊息:

root@FBI:/usr/local/mysql# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1004 Can't create file '/tmp/#sql13dc_1_0.frm' (errno: 28)
070730 11:52:17 [ERROR] Aborting

070730 11:52:17 [Note] ./bin/mysqld: Shutdown complete

Installation of system tables failed!

Examine the logs in ./data for more information.
You can try to start the mysqld daemon with:
./bin/mysqld --skip-grant &
and use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:

shell> ./bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in ./data that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!

感謝各位大大的幫忙!!!!

[redjoe]

Debian通常用GUI套件整合環境安裝，
或是在終端機下

代碼: 選擇全部

aptitude install mysql-server-5.0

來安裝，比較方便且沒有什麼問題。