之前我安装过5.1这个版本,但是后来卸载了,把安装文件夹,注册表都清理干净了,
但是现在重新安装的时候总是在start service和最后的安全提示mysqld.exe遇到问题,
MYSQL服务启动不了,试过很多次都不行,请大家指点一下原因啊
但是现在重新安装的时候总是在start service和最后的安全提示mysqld.exe遇到问题,
MYSQL服务启动不了,试过很多次都不行,请大家指点一下原因啊
调试欢乐多
Volume in drive C is xxxxx
Volume Serial Number is xxxxx Directory of C:\Program Files\MySQL\MySQL Server 5.1\bin06/22/2009 06:47p <DIR> .
06/22/2009 06:47p <DIR> ..
03/16/2009 01:29p 2,359,296 libmySQL.dll
06/03/2009 05:06p 8 myisamchk
03/16/2009 01:29p 2,089,600 myisamchk.exe
03/16/2009 01:29p 1,979,008 myisamlog.exe
03/16/2009 01:29p 2,007,680 myisampack.exe
03/16/2009 01:29p 1,966,720 myisam_ftdump.exe
03/16/2009 01:29p 2,347,648 mysql.exe
03/16/2009 01:29p 5,623,808 mysql.pdb
03/16/2009 01:29p 2,282,112 mysqladmin.exe
03/16/2009 01:29p 5,419,008 mysqladmin.pdb
03/16/2009 01:29p 2,368,128 mysqlbinlog.exe
03/16/2009 01:29p 5,885,952 mysqlbinlog.pdb
03/16/2009 01:29p 2,278,016 mysqlcheck.exe
03/16/2009 01:28p 10,715,776 mysqld-debug.exe
03/16/2009 01:28p 2,624,552 mysqld-debug.map
03/16/2009 01:28p 20,434,944 mysqld-debug.pdb
03/16/2009 01:29p 6,562,432 mysqld.exe
03/16/2009 01:29p 3,330,554 mysqld.map
03/16/2009 01:29p 20,557,824 mysqld.pdb
03/16/2009 01:29p 2,331,264 mysqldump.exe
03/16/2009 01:29p 5,566,464 mysqldump.pdb
03/16/2009 01:29p 2,273,920 mysqlimport.exe
03/16/2009 01:29p 5,394,432 mysqlimport.pdb
02/06/2009 12:17a 2,971,776 MySQLInstanceConfig.exe
03/16/2009 01:29p 2,318,976 mysqlmanager.exe
03/16/2009 01:29p 704,517 mysqlmanager.map
03/16/2009 01:29p 5,885,952 mysqlmanager.pdb
03/16/2009 01:29p 2,273,920 mysqlshow.exe
03/16/2009 01:29p 5,386,240 mysqlshow.pdb
03/16/2009 01:29p 2,417,280 mysqltest.exe
03/16/2009 01:29p 2,609,152 mysql_client_test.exe
03/16/2009 01:29p 1,802,880 mysql_upgrade.exe
03/16/2009 01:29p 1,728,512 my_print_defaults.exe
03/16/2009 01:29p 1,716,224 perror.exe
03/16/2009 01:29p 1,720,320 replace.exe
03/16/2009 01:29p 1,703,936 resolveip.exe
06/22/2009 06:49p 1,668 table.sql
37 File(s) 149,640,499 bytes
2 Dir(s) 31,076,479,488 bytes freeH:\>
H:\>dir "C:\Program Files\MySQL\MySQL Server 5.1\"
Volume in drive C is xxxxx
Volume Serial Number is xxxxx Directory of C:\Program Files\MySQL\MySQL Server 5.106/18/2009 04:14p <DIR> .
06/18/2009 04:14p <DIR> ..
06/22/2009 06:47p <DIR> bin
03/16/2009 01:29p 19,071 COPYING
07/01/2009 09:13a <DIR> DATA
04/11/2009 07:35p <DIR> Docs
03/16/2009 01:29p 5,139 EXCEPTIONS-CLIENT
03/16/2009 01:29p 5,036 my-huge.ini
03/16/2009 01:29p 21,272 my-innodb-heavy-4G.ini
03/16/2009 01:29p 5,010 my-large.ini
03/16/2009 01:29p 5,017 my-medium.ini
03/16/2009 01:29p 2,500 my-small.ini
11/12/2008 02:13a 13,129 my-template.ini
04/18/2009 12:08a 8,956 my.bak1
04/19/2009 06:15p 9,056 my.bak2
04/23/2009 09:26p 9,501 my.bak3
04/23/2009 09:26p 9,562 my.bak4
05/06/2009 11:38p 9,699 my.ini
04/11/2009 07:35p <DIR> share
13 File(s) 122,948 bytes
6 Dir(s) 31,076,477,952 bytes freeH:\>[/code]
驱动器 C 中的卷没有标签。
卷的序列号是 442F-4F45 C:\Program Files\MySQL\MySQL Server 5.1\bin 的目录2009-07-01 15:39 <DIR> .
2009-07-01 15:39 <DIR> ..
2008-11-15 05:53 2,260,992 libmySQL.dll
2008-11-15 05:53 1,999,488 myisamchk.exe
2008-11-15 05:53 1,888,896 myisamlog.exe
2008-11-15 05:53 1,917,568 myisampack.exe
2008-11-15 05:53 1,876,608 myisam_ftdump.exe
2008-11-15 05:53 2,253,440 mysql.exe
2008-11-15 05:53 5,599,232 mysql.pdb
2008-11-15 05:53 2,192,000 mysqladmin.exe
2008-11-15 05:53 5,386,240 mysqladmin.pdb
2008-11-15 05:53 2,278,016 mysqlbinlog.exe
2008-11-15 05:53 5,853,184 mysqlbinlog.pdb
2008-11-15 05:53 2,187,904 mysqlcheck.exe
2008-11-15 05:53 6,447,744 mysqld.exe
2008-11-15 05:53 3,291,807 mysqld.map
2008-11-15 05:53 20,426,752 mysqld.pdb
2008-11-15 05:53 2,241,152 mysqldump.exe
2008-11-15 05:53 5,533,696 mysqldump.pdb
2008-11-15 05:53 2,179,712 mysqlimport.exe
2008-11-15 05:53 5,361,664 mysqlimport.pdb
2008-11-12 02:13 2,972,288 MySQLInstanceConfig.exe
2008-11-15 05:53 2,183,808 mysqlshow.exe
2008-11-15 05:53 5,353,472 mysqlshow.pdb
2008-11-15 05:53 1,708,672 mysql_upgrade.exe
2008-11-15 05:53 1,634,304 my_print_defaults.exe
2008-11-15 05:53 1,617,920 perror.exe
2008-11-15 05:53 1,613,824 resolveip.exe
26 个文件 98,260,383 字节
2 个目录 20,138,291,200 可用字节
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
# (@localstatedir@ for this installation) or to
# ~/.my.cnf to set user-specific options.
#
# On Windows you should keep this file in the installation directory
# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
# make sure the server reads the config file use the startup option
# "--defaults-file".
#
# To run run the server from the command line, execute this in a
# command line shell, e.g.
# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# To install the server as a Windows service manually, execute this in a
# command line shell, e.g.
# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# And then execute this in a command line shell to start the server, e.g.
# net start MySQLXY
#
#
# Guildlines for editing this file
# ----------------------------------------------------------------------
#
# In this file, you can use all long options that the program supports.
# If you want to know the options a program supports, start the program
# with the "--help" option.
#
# More detailed information about the individual options can also be
# found in the manual.
#
#
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]port=3306[mysql]default-character-set=latin1
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.1/"#Path to the database root
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to login even if the
# connection limit has been reached.
max_connections=100# Query cache is used to cache SELECT results and later return them
# without actual executing the same query once again. Having the query
# cache enabled may result in significant speed improvements, if your
# have a lot of identical queries and rarely changing tables. See the
# "Qcache_lowmem_prunes" status variable to check if the current value
# is high enough for your load.
# Note: In case your tables change very often or if your queries are
# textually different every time, the query cache may result in a
# slowdown instead of a performance improvement.
query_cache_size=0# The number of open tables for all threads. Increasing this value
# increases the number of file descriptors that mysqld requires.
# Therefore you have to make sure to set the amount of open files
# allowed to at least 4096 in the variable "open-files-limit" in
# section [mysqld_safe]
table_cache=256# Maximum size for internal (in-memory) temporary tables. If a table
# grows larger than this value, it is automatically converted to disk
# based table This limitation is for a single table. There can be many
# of them.
tmp_table_size=8M
# How many threads we should keep in a cache for reuse. When a client
# disconnects, the client's threads are put in the cache if there aren't
# more than thread_cache_size threads from before. This greatly reduces
# the amount of thread creations needed if you have a lot of new
# connections. (Normally this doesn't give a notable performance
# improvement if you have a good thread implementation.)
thread_cache_size=8#*** MyISAM Specific options# The maximum size of the temporary file MySQL is allowed to use while
# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.
# If the file-size would be bigger than this, the index will be created
# through the key cache (which is slower).
myisam_max_sort_file_size=100G# If the temporary file used for fast index creation would be bigger
# than using the key cache by the amount specified here, then prefer the
# key cache method. This is mainly used to force long character keys in
# large tables to use the slower key cache method to create the index.
myisam_sort_buffer_size=16M# Size of the Key Buffer, used to cache index blocks for MyISAM tables.
# Do not set it larger than 30% of your available memory, as some memory
# is also required by the OS to cache rows. Even if you're not using
# MyISAM tables, you should still set it to 8-64M as it will also be
# used for internal temporary disk tables.
key_buffer_size=10M# Size of the buffer used for doing full table scans of MyISAM tables.
# Allocated per thread, if a full scan is needed.
read_buffer_size=64K
read_rnd_buffer_size=256K# This buffer is allocated when MySQL needs to rebuild the index in
# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE
# into an empty table. It is allocated per thread so be careful with
# large settings.
sort_buffer_size=256K
#*** INNODB Specific options ***
# Use this option if you have a MySQL server with InnoDB support enabled
# but you do not plan to use it. This will save memory and disk space
# and speed up some things.
#skip-innodb# Additional memory pool that is used by InnoDB to store metadata
# information. If InnoDB requires more memory for this purpose it will
# start to allocate it from the OS. As this is fast enough on most
# recent operating systems, you normally do not need to change this
# value. SHOW INNODB STATUS will display the current amount used.
innodb_additional_mem_pool_size=2M# If set to 1, InnoDB will flush (fsync) the transaction logs to the
# disk at each commit, which offers full ACID behavior. If you are
# willing to compromise this safety, and you are running small
# transactions, you may set this to 0 or 2 to reduce disk I/O to the
# logs. Value 0 means that the log is only written to the log file and
# the log file flushed to disk approximately once per second. Value 2
# means the log is written to the log file at each commit, but the log
# file is only flushed to disk approximately once per second.
innodb_flush_log_at_trx_commit=1# The size of the buffer InnoDB uses for buffering log data. As soon as
# it is full, InnoDB will have to flush it to disk. As it is flushed
# once per second anyway, it does not make sense to have it very large
# (even with long transactions).
innodb_log_buffer_size=1M# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
# row data. The bigger you set this the less disk I/O is needed to
# access data in tables. On a dedicated database server you may set this
# parameter up to 80% of the machine physical memory size. Do not set it
# too large, though, because competition of the physical memory may
# cause paging in the operating system. Note that on 32bit systems you
# might be limited to 2-3.5G of user level memory per process, so do not
# set it too high.
innodb_buffer_pool_size=16M# Size of each log file in a log group. You should set the combined size
# of log files to about 25%-100% of your buffer pool size to avoid
# unneeded buffer pool flush activity on log file overwrite. However,
# note that a larger logfile size will increase the time needed for the
# recovery process.
innodb_log_file_size=10M# Number of threads allowed inside the InnoDB kernel. The optimal value
# depends highly on the application, hardware as well as the OS
# scheduler properties. A too high value may lead to thread thrashing.
innodb_thread_concurrency=8
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"应该安装成功了。看一下这个参数对应的目录中,如果文件正常则,可以开始启动了。
该文件夹下应该有 mysql, test 两个文件夹。mysql 目录下有如下文件。[code=BatchFile] Directory of C:\Program Files\MySQL\MySQL Server 5.1\data\mysql04/24/2009 02:41p <DIR> .
04/24/2009 02:41p <DIR> ..
03/13/2009 11:44p 8,820 columns_priv.frm
03/13/2009 11:44p 0 columns_priv.MYD
03/13/2009 11:44p 4,096 columns_priv.MYI
03/13/2009 11:44p 9,582 db.frm
06/26/2009 08:24p 880 db.MYD
06/26/2009 08:24p 5,120 db.MYI
03/13/2009 11:44p 10,223 event.frm
03/13/2009 11:44p 0 event.MYD
03/13/2009 11:44p 2,048 event.MYI
03/13/2009 11:44p 8,665 func.frm
03/13/2009 11:44p 0 func.MYD
03/13/2009 11:44p 1,024 func.MYI
06/26/2009 07:54p 35 general_log.CSM
03/13/2009 11:44p 0 general_log.CSV
03/13/2009 11:44p 8,776 general_log.frm
03/13/2009 11:44p 8,700 help_category.frm
03/13/2009 11:44p 21,497 help_category.MYD
03/13/2009 11:44p 3,072 help_category.MYI
03/13/2009 11:44p 8,612 help_keyword.frm
03/13/2009 11:44p 88,650 help_keyword.MYD
03/13/2009 11:44p 16,384 help_keyword.MYI
03/13/2009 11:44p 8,630 help_relation.frm
03/13/2009 11:44p 8,874 help_relation.MYD
03/13/2009 11:44p 16,384 help_relation.MYI
03/13/2009 11:44p 8,770 help_topic.frm
03/13/2009 11:44p 413,596 help_topic.MYD
03/13/2009 11:44p 20,480 help_topic.MYI
03/13/2009 11:44p 9,510 host.frm
03/13/2009 11:44p 0 host.MYD
03/13/2009 11:44p 2,048 host.MYI
03/13/2009 11:44p 8,778 ndb_binlog_index.frm
03/13/2009 11:44p 0 ndb_binlog_index.MYD
03/13/2009 11:44p 1,024 ndb_binlog_index.MYI
03/13/2009 11:44p 8,586 plugin.frm
03/13/2009 11:44p 0 plugin.MYD
03/13/2009 11:44p 1,024 plugin.MYI
03/13/2009 11:44p 9,996 proc.frm
07/01/2009 10:13a 9,652 proc.MYD
07/01/2009 10:13a 4,096 proc.MYI
03/13/2009 11:44p 8,875 procs_priv.frm
03/13/2009 11:44p 0 procs_priv.MYD
03/13/2009 11:44p 4,096 procs_priv.MYI
03/13/2009 11:44p 8,838 servers.frm
03/13/2009 11:44p 0 servers.MYD
03/13/2009 11:44p 1,024 servers.MYI
06/26/2009 07:54p 35 slow_log.CSM
03/13/2009 11:44p 0 slow_log.CSV
03/13/2009 11:44p 8,976 slow_log.frm
03/13/2009 11:44p 8,955 tables_priv.frm
05/04/2009 04:41p 1,702 tables_priv.MYD
05/04/2009 04:41p 8,192 tables_priv.MYI
03/13/2009 11:44p 8,636 time_zone.frm
03/13/2009 11:44p 0 time_zone.MYD
03/13/2009 11:44p 1,024 time_zone.MYI
03/13/2009 11:44p 8,624 time_zone_leap_second.frm
03/13/2009 11:44p 0 time_zone_leap_second.MYD
03/13/2009 11:44p 1,024 time_zone_leap_second.MYI
03/13/2009 11:44p 8,606 time_zone_name.frm
03/13/2009 11:44p 0 time_zone_name.MYD
03/13/2009 11:44p 1,024 time_zone_name.MYI
03/13/2009 11:44p 8,686 time_zone_transition.frm
03/13/2009 11:44p 0 time_zone_transition.MYD
03/13/2009 11:44p 1,024 time_zone_transition.MYI
03/13/2009 11:44p 8,748 time_zone_transition_type.frm
03/13/2009 11:44p 0 time_zone_transition_type.MYD
03/13/2009 11:44p 1,024 time_zone_transition_type.MYI
03/13/2009 11:44p 10,466 user.frm
06/30/2009 08:10p 424 user.MYD
06/30/2009 08:26p 2,048 user.MYI
04/18/2009 09:54a 8,766 user_info.frm
04/18/2009 09:54a 0 user_info.MYD
04/18/2009 09:54a 1,024 user_info.MYI
72 File(s) 859,473 bytes
2 Dir(s) 31,074,356,736 bytes freeH:\>[/code]
命令行输入telnet localhost 3306不能正常连接
打开这个目录有有一个 *.err 文件,贴出里面内容。