安装到 ./scripts/mysql_install_db --user=mysql 就无法继续下去了!!!（已解决）

jjzeng

解决方法的链接在这里：http://bbs.chinaunix.net/viewthr ... &extra=page%3D1

系统: RHEL-U2.    mysql-max-5.0.16-linux-i686-glibc23.tar.gz

shell>groupadd mysql
shell>useradd -g mysql mysql
shell>./mysql_install_db --user=mysql   

/*出来提示:  */
./mysql_install_db: line 85: my_print_defaults: command not found
Could not find help file 'fill_help_tables.sql' in ./support-files or inside ..

/*接着退出 scripts/ 目录, 在 mysql/ 目录下打入命令:  */
shell>scripts/mysql_install_db --user=mysql

/*出现不同的提示:  */

Installing all prepared tables
Fill help tables

HELP FILES CAN NOT COMPLETE INSTALL
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 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 ./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

/*知道出问题了,却继续试着安装*/
shell>chmod -R root .
shell>chmod -R mysql data
shell>chmod -R mysql .
shell>./bin/mysqld_safe --user=mysql &

/*结果不出所料,启动不起来! 后来以为是 MAX版本的事情,试了STAND 版本 ,结果是一样的,实在是没办法了,googel也找不到答案,上来发贴了.之前用的 Cent-OS 4的时候很正常,换成RHEL-U2后,就这样了.清各位花一丁点时间帮个小忙,解决一下,谢谢!!!
如果需要提供更多的信息,请提示我!

[ 本帖最后由 jjzeng 于 2006-2-23 11:50 编辑 ]

cuci

服务不能启动可以看`hostname`.err查原因

jjzeng

检查了日志,
051209  9:28:58 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
051209  9:28:58 [ERROR] Can't start server: can't create PID file: No such file or directory
051209 09:28:58  mysqld ended

InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
051212 15:39:42  InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.

051212 15:41:22  InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
051212 15:41:22  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.

051212 16:04:27 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
051212 16:04:27 [ERROR] Can't start server: can't create PID file: No such file or directory
051212 16:04:27  mysqld ended

051212 16:04:27 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
051212 16:04:27 [ERROR] Can't start server: can't create PID file: No such file or directory
051212 16:04:27  mysqld ended

第一次安装mysql就出现这样的情况,也检查过了,没有另外的 mysqld进程.
而且有些地方我不理解是什么意思,呵呵,所以就摘取了一些出来,让大家帮忙看看是什么原因.

cuci

我觉得是你的data目录权限得问题，改成mysql得试试吧

jjzeng

把 data 权限改为 777 了，出现同样的提示，甚至把 data 里面的  mysql ,test  都改为777 了，但是提示依旧，我知道肯定是不是这样修改。
那怎么修改？

rardge

原帖由 jjzeng 于 2005-12-12 22:10 发表
051212 16:04:27 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
051212 16:04:27 [ERROR] Can't start server: can't create PID file: No such file or directory

/var/run/mysqld 这个目录有么？

jjzeng

没有这个目录！

rardge

你手工下命令 touch /var/run/mysqld/mydqld.pid 再试验一下。要让 mysql 用户有权限写哦

jjzeng

touch /var/run/mysqld/mydqld.pid   提示没有那个文件或目录

接者 手工建了个目录 mysqld/mysqld.pid  就没出现提示没有那个文件或目录

但是没反应. 下来又试了 一下: ./scripts/mysql_install_db --user=mysql   情况依旧.
查看日志,没有新的日志

rardge

你用 root 账号登录系统，然后 ./scripts/mysql_install_db 看看，后面不要指定用户呢？