(help)启动mysql时出现一个错误

lazy_bug

version:  mysql-4.1.16
安装过程一切正常,没有提示错误信息!!

#groupadd mysql
#useradd -g mysql mysql
#chgrp -R mysql /usr/local/mysql/
#tar zxvf mysql-4.1.16.tar.gz   
#cd mysql-4.1.16
#./configure --prefix=/usr/local/mysql
#make
#make install
#cp support-files/my-medium.cnf /etc/my.cnf   
#cd /usr/local/mysql
#bin/mysql_install_db --user=mysql   
接下来就是下面的错误了!





[root@host1 bin]# ./mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
051217 16:33:33 [ERROR] Aborting

051217 16:33:33 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

./mysql_install_db: line 299:  3928 断开的管道              cat $fill_help_tables

WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
The "HELP" command might not work properly


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h host1.test.cn password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/local/mysql/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com



请各位帮忙,谢谢!!!

[ 本帖最后由 lazy_bug 于 2005-12-17 17:35 编辑 ]

R9_Alien

顶一下。。。我怎么跟你一个错误啊。。。是不是这个版本有毛病啊？？？？？

odin_free

实施这个
你那个有点乱
#groupadd mysql
#useradd -g mysql mysql
#cd /usr/local
#tar zxf mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz
#ln -s mysql-standard-4.1.13-pc-linux-gnu-i686 mysql
#cd mysql
#scripts/mysql_install_db --user=mysql
#chgrp -R mysql *
#bin/mysqld_safe --user=mysql &

R9_Alien

我就是楼上的安装方法，到#scripts/mysql_install_db --user=mysql 这一步就报错了，版本是rh as3 up6 ,奇怪死了，，，，5.0.17倒是过去了，4这个版本就是报这个错

sdet1234

换个版本！！呵呵

jjlovelml

我也遇到了这样的问题，期待解决

lazy_bug

不好意思，最近忙着准备邮件服务器的测试，少上论坛了，以上的问题我找了很多官方的网站，有人也碰到这个问题，我不知道这是不是bug ，水平有限啊，没办法我最后只能换成高版本的！我个人觉得最好还是用高版本的！！

liu1084

原帖由 lazy_bug 于 2005-12-17 16:43 发表
version:  mysql-4.1.16
安装过程一切正常,没有提示错误信息!!

#groupadd mysql
#useradd -g mysql mysql
#chgrp -R mysql /usr/local/mysql/
#tar zxvf mysql-4.1.16.tar.gz   
#cd mysql-4.1.16
#./co ...

安装完毕后权限设置不对,你怎么还没有安装就设置权限了？
#chown -R root /usr/local/mysql
#chown -R mysql /usr/local/mysql/var
#chgrp -R mysql /usr/local/mysql

[ 本帖最后由 liu1084 于 2006-1-16 14:18 编辑 ]