[讨论]在FC4下安装mysql的步骤问题,请高手进来认真解答一下,谢谢!

中国龙腾

我的系统是FC4,是自定义安装的,安装了编辑器、开发工具、文本浏览器等,
mysql下的是mysql-standard-4.1.12-pc-linux-gnu-i686.tar.gz,安装目录是/usr/local/mysql
安装步骤完全按网上大家发的贴:
[root@Bleach usr]# groupadd mysql
[root@Bleach usr]# useradd -g mysql mysql
[root@Bleach usr]# cd /usr/local
[root@Bleach local]# gunzip < /usr/mysql-standard-4.0.23-pc-linux-i686.tar.gz | tar xvf -
[root@Bleach local]# ln -s /usr/local/mysql-standard-4.0.23-pc-linux-i686 mysql
[root@Bleach mysql]# cd mysql
[root@Bleach mysql]# scripts/mysql_install_db --user=mysql
[root@Bleach mysql]# chown -R root .
[root@Bleach mysql]# chown -R mysql data
[root@Bleach mysql]# chgrp -R mysql .
[root@Bleach mysql]# ./bin/mysqld_safe --user=mysql &
[root@Bleach mysql]# ./bin/mysqladmin -u root password mysql
[root@Bleach mysql]# cp ./support-files/mysql.server /etc/init.d/mysql
[root@Bleach mysql]# cd /etc/rc3.d/
[root@Bleach rc3.d]# ln -s /etc/init.d/mysql S85mysql
[root@Bleach rc3.d]# ln -s /etc/init.d/mysql K85mysql

可是,进行到[root@Bleach mysql]# scripts/mysql_install_db --user=mysql  这一步,系统就总是报错:
[root@analyser mysql]# scripts/mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables

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:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h analyser.com.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 ./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 . ; ./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 ./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

如果是在根目录下,就提示
[root@analyser /]# /usr/local/mysql/scripts/mysql_install_db --user=mysql
Could not find help file 'fill_help_tables.sql' in ./support-files or inside ..

后来,我在/usr/local/mysql/share里看到fill_help_tables.sql这个文件,并把它COPY到support-files里,仍然报一样的错.

不知道哪位大虾安装mysql时遇到过同样问题,并解决了的,麻烦你把解决方法贴出来,供大家学习啊!~
(这个问题,好像不止我一个人遇到,我在论坛里看到好多这样的贴,郁闷!
为什么有的人安成功了,有的人又和我一样呢?)

lsunx

按以上步骤第一次scripts/mysql_install_db --user=mysql 安装系统数据库mysql是不成功。
./bin/mysqld_safe --user=mysql &　是无法正常启动的。
解决方法就是：
在启动失败退出后，删除data下所有文件，重新执行如下步骤，再启动就成功了。
[root@Bleach mysql]# scripts/mysql_install_db --user=mysql
[root@Bleach mysql]# chown -R root .
[root@Bleach mysql]# chown -R mysql data
[root@Bleach mysql]# chgrp -R mysql .

rardge

原帖由 lsunx 于 2005-12-15 08:57 发表
按以上步骤第一次scripts/mysql_install_db --user=mysql 安装系统数据库mysql是不成功。
./bin/mysqld_safe --user=mysql &　是无法正常启动的。
解决方法就是：
在启动失败退出后，删除data下所有文件， ...

啊？linux 下的版本这么变态啊，要删除后再来一次？
我是用FreeBSD的，从来没有这样，一次就pass了。

中国龙腾

楼上的，我按照你说的，把data下的文件都删了，重新scripts/mysql_install_db --user=mysql ，可是问题依旧啊，不过，data里又写了两个库：mysql和test，其他的都没
看来，问题不在这啊，

rardge

楼主，你发了若干帖了，现在都不知道你到底是什么问题了。
我在另外一帖已经说了，下面这个，不是错误提示啊，只是告诉你如何启动、如何设置密码、如果发现问题报告到哪里等等。
------------------------------------------------------------------
可是,进行到[root@Bleach mysql]# scripts/mysql_install_db --user=mysql  这一步,系统就总是报错:
[root@analyser mysql]# scripts/mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables

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:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h analyser.com.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 ./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 . ; ./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 ./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
------------------------------------------------------------------

tchhyc

如果是在根目录下,就提示
[root@analyser /]# /usr/local/mysql/scripts/mysql_install_db --user=mysql
Could not find help file 'fill_help_tables.sql' in ./support-files or inside ..
置顶的帖子不是写着
[root@Bleach mysql]# scripts/mysql_install_db --user=mysql
要这样吗?你干嘛还要/usr/local/mysql/scripts/mysql_install_db --user=mysql这样,你进
mysql_install_db 看看就知道了,里面有很多都是用./表示当前路径的,你在/usr/local/mysql/scripts/
下了怎么找啊?
而且执行好的信息就如楼上所说的,并没有看到什么错误

[ 本帖最后由 tchhyc 于 2005-12-15 10:32 编辑 ]

tchhyc

看你发了这么多帖子,建议发贴前先自己研究一下,解决不了再发贴

macrodba

从新下载一个mysql二进制文件把。有可能文件丢包了。