LinuxSir.cn,穿越时空的Linuxsir!

 找回密码
 注册
搜索
热搜: shell linux mysql
查看: 1669|回复: 2

求助:mysql安装配置问题

[复制链接]
发表于 2006-8-8 21:51:06 | 显示全部楼层 |阅读模式
redhat 9.0下安装mysql-max-5.0.24-linux-i686-glibc23.tar.gz(最新版本)时出错了。
我是根据http://dev.mysql.com/doc/refman/5.1/zh/installing.html里面的介绍(2.7. 在其它类Unix系统中安装MySQL)安装的。

# tar -zvxf mysql-max-5.0.24-linux-i686-glibc23.tar.gz
# cp -r mysql-max-5.0.21-linux-i686-glibc23.tar.gz /usr/local/
# mv /usr/local/mysql-max-5.0.21-linux-i686-glibc23.tar.gz /usr/local/mysql
# cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

添加mysql用户及用户组
# /usr/local/sbin/groupadd mysql
# /usr/local/sbin/useradd -g mysql mysql
修改mysql目录权限
# chown -R root /usr/local/mysql
# chgrp -R mysql /usr/local/mysql
# chown -R mysql /usr/local/mysql/data

(接下来出现问题了)
生成mysql系统数据库
# /usr/local/mysql/scripts/mysql_install_db --user=mysql&  (回车)
[1] 2098
[root@localhost root]# /usr/local/mysql/scripts/mysql_install_db: line
1: my_pri
nt_defaults: command not found
Could not find help file 'fill_help_tables.sql' in ./support-files or
inside ..
(ctrl+c退出)
[1]+  Exit 1                  /usr/local/mysql/scripts/mysql_install_db

(没有解决,继续往下)
启动mysql服务
# /usr/local/mysql/bin/mysqld_safe --user=mysql& (回车)
[1] 2105
[root@localhost root]# Starting mysqld daemon with databases from
/usr/local/mys
ql/data
(过了几秒钟继续...)
STOPPING server from pid file
/usr/local/mysql/data/localhost.localdomain.pid
060808 20:54:37  mysqld ended
(就这样被停止了)

查看日志如下:
060808 20:54:34  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060808 20:54:35  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060808 20:54:36  InnoDB: Log file ./ib_logfile0 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
060808 20:54:36  InnoDB: Log file ./ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060808 20:54:37  InnoDB: Started; log sequence number 0 0
060808 20:54:37 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.host' doesn't exist
060808 20:54:37  mysqld ended

我是生手,e文又不好,日志看不大懂!有大哥大姐帮我看看吗?mysql-max-5.0.24-linux-i686.tar.gz 这版本也试过,同样的错误!我应该怎么做?我以前没配置过PHP服务器,现在急需,第一步配mysql就出错了,好急啊!!
发表于 2006-8-15 13:26:40 | 显示全部楼层
Can't open and lock privilege tables: Table 'mysql.host' doesn't exist



这句我觉得是问题的所在

不过怎么解决我也不知道
回复 支持 反对

使用道具 举报

发表于 2006-8-15 21:47:26 | 显示全部楼层
我也出过这个问题。换一个MySQL版本解决。
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

快速回复 返回顶部 返回列表