GENTOO 配置启动MYSQL失败,求助.

zonyonq

# /etc/init.d/mysql start 启动失败

/etc/mysql/my.cnf文件配置信息

1. 
   
2. # /etc/mysql/my.cnf: The global mysql configuration file.
   
3. # $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-5.1,v 1.2 2010/03/24 18:26:09 robbat2 Exp $
   
4. 
   
5. # The following options will be passed to all MySQL clients
   
6. [client]
   
7. #password                                        = your_password
   
8. port                                                = 3306
   
9. socket                                                = /var/run/mysqld/mysqld.sock
   
10. 
    
11. [mysql]
    
12. character-sets-dir=/usr/share/mysql/charsets
    
13. default-character-set=utf8
    
14. 
    
15. [mysqladmin]
    
16. character-sets-dir=/usr/share/mysql/charsets
    
17. default-character-set=utf8
    
18. 
    
19. [mysqlcheck]
    
20. character-sets-dir=/usr/share/mysql/charsets
    
21. default-character-set=utf8
    
22. 
    
23. [mysqldump]
    
24. character-sets-dir=/usr/share/mysql/charsets
    
25. default-character-set=utf8
    
26. 
    
27. [mysqlimport]
    
28. character-sets-dir=/usr/share/mysql/charsets
    
29. default-character-set=utf8
    
30. 
    
31. [mysqlshow]
    
32. character-sets-dir=/usr/share/mysql/charsets
    
33. default-character-set=utf8
    
34. 
    
35. [myisamchk]
    
36. character-sets-dir=/usr/share/mysql/charsets
    
37. 
    
38. [myisampack]
    
39. character-sets-dir=/usr/share/mysql/charsets
    
40. 
    
41. # use [safe_mysqld] with mysql-3
    
42. [mysqld_safe]
    
43. err-log                                                = /var/log/mysql/mysql.err
    
44. 
    
45. # add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations
    
46. [mysqld]
    
47. character-set-server                = utf8
    
48. user                                                 = mysql
    
49. port                                                 = 3306
    
50. socket                                                 = /var/run/mysqld/mysqld.sock
    
51. pid-file                                         = /var/run/mysqld/mysqld.pid
    
52. log-error                                         = /var/log/mysql/mysqld.err
    
53. basedir                                         = /usr
    
54. datadir                                         = /usr/mysql/data
    
55. skip-external-locking
    
56. key_buffer                                         = 16M
    
57. max_allowed_packet                         = 1M
    
58. table_cache                                 = 64
    
59. sort_buffer_size                         = 512K
    
60. net_buffer_length                         = 8K
    
61. read_buffer_size                         = 256K
    
62. read_rnd_buffer_size                 = 512K
    
63. myisam_sort_buffer_size         = 8M
    
64. language                                         = /usr/share/mysql/english
    
65. 
    
66. # security:
    
67. # using "localhost" in connects uses sockets by default
    
68. # skip-networking
    
69. bind-address                                = 127.0.0.1
    
70. 
    
71. log-bin
    
72. server-id                                         = 1
    
73. 
    
74. # point the following paths to different dedicated disks
    
75. tmpdir                                                 = /tmp/
    
76. #log-update                                 = /path-to-dedicated-directory/hostname
    
77. 
    
78. # you need the debug USE flag enabled to use the following directives,
    
79. # if needed, uncomment them, start the server and issue
    
80. # #tail -f /tmp/mysqld.sql /tmp/mysqld.trace
    
81. # this will show you *exactly* what's happening in your server ;)
    
82. 
    
83. #log                                                = /tmp/mysqld.sql
    
84. #gdb
    
85. #debug                                                = d:t:i:o,/tmp/mysqld.trace
    
86. #one-thread
    
87. 
    
88. # uncomment the following directives if you are using BDB tables
    
89. #bdb_cache_size                                = 4M
    
90. #bdb_max_lock                                = 10000
    
91. 
    
92. # the following is the InnoDB configuration
    
93. # if you wish to disable innodb instead
    
94. # uncomment just the next line
    
95. #skip-innodb
    
96. #
    
97. # the rest of the innodb config follows:
    
98. # don't eat too much memory, we're trying to be safe on 64Mb boxes
    
99. # you might want to bump this up a bit on boxes with more RAM
    
100. innodb_buffer_pool_size = 16M
     
101. # this is the default, increase it if you have lots of tables
     
102. innodb_additional_mem_pool_size = 2M
     
103. #
     
104. # i'd like to use /var/lib/mysql/innodb, but that is seen as a database :-(
     
105. # and upstream wants things to be under /var/lib/mysql/, so that's the route
     
106. # we have to take for the moment
     
107. innodb_data_home_dir                = /usr/mysql/data #/var/lib/mysql/
     
108. innodb_log_arch_dir                = /usr/mysql/data #/var/lib/mysql/
     
109. innodb_log_group_home_dir        = /usr/mysql/data #/var/lib/mysql/
     
110. # you may wish to change this size to be more suitable for your system
     
111. # the max is there to avoid run-away growth on your machine
     
112. innodb_data_file_path = ibdata1:10M:autoextend:max:128M
     
113. # we keep this at around 25% of of innodb_buffer_pool_size
     
114. # sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size)
     
115. innodb_log_file_size = 5M
     
116. # this is the default, increase it if you have very large transactions going on
     
117. innodb_log_buffer_size = 8M
     
118. # this is the default and won't hurt you
     
119. # you shouldn't need to tweak it
     
120. innodb_log_files_in_group=2
     
121. # see the innodb config docs, the other options are not always safe
     
122. innodb_flush_log_at_trx_commit = 1
     
123. innodb_lock_wait_timeout = 50
     
124. innodb_file_per_table
     
125. 
     
126. [mysqldump]
     
127. quick
     
128. max_allowed_packet                         = 16M
     
129. 
     
130. [mysql]
     
131. # uncomment the next directive if you are not familiar with SQL
     
132. #safe-updates
     
133. 
     
134. [isamchk]
     
135. key_buffer                                         = 20M
     
136. sort_buffer_size                         = 20M
     
137. read_buffer                                 = 2M
     
138. write_buffer                                 = 2M
     
139. 
     
140. [myisamchk]
     
141. key_buffer                                         = 20M
     
142. sort_buffer_size                         = 20M
     
143. read_buffer                                 = 2M
     
144. write_buffer                                 = 2M
     
145. 
     
146. [mysqlhotcopy]
     
147. interactive-timeout
     
148. 
     

复制代码

zonyonq

:yun::yun::yun::yun: 么有人帮助下么..

2603301009

貌似gentoo自带了两个mysql的启动脚本，试试另外一个。

druggo

看错误日志啊

blackwhite

http://www.gentoo.org/doc/en/mysql-howto.xml
你需要做mysql的初始化。
emerge --config =dev-db/mysql-[version]

zonyonq

苍天啊,大地啊. 怎么会这样呢. 郁闷...

1. 
   
2. kelvin mysql # emerge --config =dev-db/mysql-5.1.56
   
3. 
   
4. 
   
5. Configuring pkg...
   
6. 
   
7. * MySQL MY_DATADIR has changed
   
8. * from /var/lib/mysql
   
9. * to /usr/mysql/data
   
10. * Both /var/lib/mysql and /usr/mysql/data exist
    
11. * Attempting to use /usr/mysql/data and preserving /var/lib/mysql
    
12. * You have already a MySQL database in place.
    
13. * (///usr/mysql/data/*)
    
14. * Please rename or delete it if you wish to replace it.
    
15. * ERROR: dev-db/mysql-5.1.56 failed (config phase):
    
16. *   MySQL database already exists!
    
17. *
    
18. * Call stack:
    
19. *     ebuild.sh, line   56:  Called pkg_config
    
20. *   environment, line 4166:  Called mysql_pkg_config
    
21. *   environment, line 3664:  Called die
    
22. * The specific snippet of code:
    
23. *           die "MySQL database already exists!";
    
24. *
    
25. * If you need support, post the output of 'emerge --info =dev-db/mysql-5.1.56',
    
26. * the complete build log and the output of 'emerge -pqv =dev-db/mysql-5.1.56'.
    
27. * This ebuild is from an overlay named 'gentoo': '/var/db/pkg/'
    
28. * The complete build log is located at '/var/tmp/portage/dev-db/mysql-5.1.56/temp/build.log'.
    
29. * The ebuild environment file is located at '/var/tmp/portage/dev-db/mysql-5.1.56/temp/environment'.
    
30. * S: '/var/tmp/portage/dev-db/mysql-5.1.56/work/mysql-5.1.56'
    
31. 
    

复制代码

RichardGv

呃，提示不是写得很清楚了嘛？需要您将/usr/mysql/data/中的内容删除或移走。