mysql问题？在线请教！

providence

mysql_install_db安装授权表,报下列错。我把my.cnf中的'max_allowed_packet'增得非常大也不行。我用的是mysql 5.0.1
[root@localhost etc]# mysql_install_db
Installing all prepared tables
041022 10:13:41  Warning: Asked for 196608 thread stack, but got 126976
Fill help tables
041022 10:13:41  Warning: Asked for 196608 thread stack, but got 126976
ERROR: 1153  Got a packet bigger than 'max_allowed_packet' bytes
041022 10:13:41  Aborting

041022 10:13:41  /usr/sbin/mysqld: Shutdown complete


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/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain 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/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/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/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

dannycat

应该还是你的环境有误，贴出你的 my.cnf。

或者，删除 my.cnf，重新启动 MySQL。

providence

我是拷贝一份的。/usr/share/mysql/my-medium.cnf,其它什么没改。

dannycat

呵呵，那就对了。 那个文件就是有问题。

providence

哪怎么弄，一点都不懂哟。开始照做别人的资料在做。

providence

我把my.cnf删除了后就不报错了！但mysql的配置文件是哪个呀？？5.0.1跟以前的不一样吗？

dannycat

一样的，全局设置在 /etc/my.cnf， 单服务器设置在 mysql-data-dir/my.cnf，用户设置在 ~/.my.cnf。
不用它那个例子文件就是了。
那个例子文件的问题好象在于 sort_buffer_size 太小了，不指定它好了。

providence

重新安装一次。替换所有以前存在的文件。会自动产生my.cnf这个文件。不会报错了。
再次感谢斑竹。