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

jjzeng

原帖由 fifahuihua 于 2005-12-19 00:33 发表
我也碰到这样的问题. 但是我解决了问题.
告诉你我解决的方法,但是我自己目前还不明白到底会出现楼主说的那种错误.当时我都快放弃了,最好它自己好了我就没有管.

很简单. 我当时每次启动时都说
[root@localhos ...

试了，还是不行啊．

（最近学校网络改造，呵呵，这个问题拖到现在才有时间来解决）

suran007

我也遇到同样的问题，到现在还是不行，那位大侠帮帮忙亚

w123456

我也是这个问题！

大侠能给个 解决方案 ！

tchhyc

原帖由 jjzeng 于 2005-12-16 22:17 发表
我把我的  my.cnf  文件贴出来，看看问题出在哪里。

【mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

/*有两行注释的，就不贴了，我要赶紧回宿舍了，不让今晚就要睡网络中心了，呵呵
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid ...

楼主把err-log和pid-file改一下吧,说也说不清了,所有涉及到目录的都改成放到/var/lib/mysql下先
err-log=/var/lib/mysql/mysqld.log
pid-file=/var/lib/mysql/mysqld.pid
然后进入/var/lib/下
#chown -R mysql mysql
#chgrp -R mysql mysql
再用mysqld_safe --user=mysql &重启一下看看
如果可以的话楼主就应该知道什么原因了

jjlovelml

呵呵～～今天安装mysql也是碰到这样的问题不知道解决了没有？

惠繪洋

我也是這個問題呢.. 還不能啟動mysql. 看看log, 發現是什麼innoDB的問題..

1. 
   
2. 060128 12:00:04  mysqld started
   
3. InnoDB: The first specified data file ./ibdata1 did not exist:
   
4. InnoDB: a new database to be created!
   
5. 060128 12:00:04  InnoDB: Setting file ./ibdata1 size to 10 MB
   
6. InnoDB: Database physically writes the file full: wait...
   
7. 060128 12:00:04  InnoDB: Error: Write to file ./ibdata1 failed at offset 0 1048576.
   
8. InnoDB: 1048576 bytes should have been written, only 466944 were written.
   
9. InnoDB: Operating system error number 22.
   
10. InnoDB: Check that your OS and file system support files of this size.
    
11. InnoDB: Check also that the disk is not full or a disk quota exceeded.
    
12. InnoDB: Error number 22 means 'Invalid argument'.
    
13. InnoDB: Some operating system error numbers are described at
    
14. InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
    
15. InnoDB: Error in creating ./ibdata1: probably out of disk space
    
16. InnoDB: Could not open or create data files.
    
17. InnoDB: If you tried to add new data files, and it failed here,
    
18. InnoDB: you should now edit innodb_data_file_path in my.cnf back
    
19. InnoDB: to what it was, and remove the new ibdata files InnoDB created
    
20. InnoDB: in this failed attempt. InnoDB only wrote those files full of
    
21. InnoDB: zeros, but did not yet use them in any way. But be careful: do not
    
22. InnoDB: remove old data files which contain your precious data!
    
23. 060128 12:00:04 [ERROR] Can't init databases
    
24. 060128 12:00:04 [ERROR] Aborting
    
25. 
    
26. 060128 12:00:04 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
    
27. 
    
28. 060128 12:00:04  mysqld ended
    

复制代码

請各位指教指教.

qiyu15555

echo "Started The mysql Server,                                 [  OK  ]"

晕~~~~

ashchen

我是用source编译安装的，转到安装目录下初始化数据库错误
但是回到source目录，找到scripts/mysql_install_db 初始化就ok了
版本5.0.18

gdwk

./mysql_install_db: line 85: my_print_defaults: command not found

搜索my_print_defaults这个文件，请确保bin下你有这个命令
以前遇到过，问题暂时没法重现所以想不起来当初是怎么解决的。


# If you install MySQL on some other places than /usr/local/mysql, then you
# have to do one of the following things for this script to work:
#
# - Run this script from within the MySQL installation directory
# - Create a /etc/my.cnf file with the following information:
#   [mysqld]
#   basedir=<path-to-mysql-installation-directory>
# - Add the above to any other configuration file (for example ~/.my.ini)
#   and copy my_print_defaults to /usr/bin
# - Add the path to the mysql-installation-directory to the basedir variable
#   below.
#
# If you want to affect other MySQL variables, you should make your changes
# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.

[ 本帖最后由 gdwk 于 2006-2-6 08:30 编辑 ]