启动Mysql 错误 1067 进程意外终止的一种解决方法

装完Mysql后,如果启动Mysql时,报错如下
1
2
3
4
5
6
7
8
9
H:\mysql\bin>net start mysql
MySql 服务正在启动 .
MySql 服务无法启动。
 
系统出错。
 
发生系统错误 1067。
 
进程意外终止。


请执行以下命令
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
H:\mysql\bin>mysqld-nt --defaults-file=h:\windows\my.ini --standalone --console
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
061109  9:51:52  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
061109  9:51:52  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...
061109  9:51:53  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
061109  9:51:56  InnoDB: Started
mysqld-nt: ready for connections.
Version: '4.0.26-nt'  socket: ''  port: 3306  Official MySQL binary

就可以了,原因是Mysql数据库服务器未初始化。

附my.ini,一般装完都会自动生成在系统盘:\winnt(或windows)\下

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#This File was made using the WinMySQLAdmin 1.4 Tool
#2006-11-09 09:39:52
 
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
 
[mysqld]
basedir=H:/mysql
#bind-address=192.168.1.179
datadir=H:/mysql/data
#language=H:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=H:/mysql/bin/mysqld-nt.exe
user=root
password=
[Client]
user=root
password=


平均得分
(0 次评分)





文章来自: 本站原创
标签: mysql 启动 1067 解决方法 
评论: 104 | 查看次数: 8708
游客 [2007-06-15 04:31:32]
Thanks for this site!
buy tramadol
游客 [2007-06-15 03:59:15]
Thanks for this site!
buy tramadol
游客 [2007-06-15 03:24:56]
Thanks for this site!
buy tramadol
游客 [2007-06-15 02:51:21]
Thanks for this site!
buy tramadol
游客 [2007-06-15 02:15:40]
Thanks for this site!
buy tramadol
游客 [2007-06-15 01:38:28]
Thanks for this site!
buy tramadol
游客 [2007-06-14 23:19:10]
Thanks for this site!
buy tramadol
游客 [2007-06-14 22:47:21]
Thanks for this site!
buy tramadol
游客 [2007-06-13 21:58:07]
Thanks for this site!
buy viagra
游客 [2007-06-13 21:31:57]
Thanks for this site!
buy cialis
游客 [2007-06-11 20:33:05]
游客 [2007-06-11 16:23:39]
游客 [2007-06-11 16:18:21]
游客 [2007-06-11 16:14:35]
游客 [2007-06-11 15:17:44]
发表评论
昵 称:  登录
内 容:
选 项:
字数限制 1000 字 | UBB代码 开启 | [img]标签 开启