查看完整版本 : 连接mysql的问题,困惑了我一个下午了。
sweetykiss
2003-08-06, 18:06
c:mysql\bin>mysql
出现: "ERROR 2003: Can''t connect to MySQL server on ''localhost'' (10061)"的错误提示。
查了相关资料
运行 mysqld -install
net start mysql
提示mysql服务已经启动成功!
接着
c:mysql\bin>mysqld
成功
然后
c:mysql\bin>mysql 还是出现上面的错误!!!???
我困惑了一个下午了,望各位不吝赐教!
sweetykiss
2003-08-07, 08:30
重起还是这样。
sweetykiss
2003-08-07, 09:04
我的硬盘安装了两个系统,win98(C:)和win2000(E:)
我在win2000下安装,mysql安装在E盘。
my.ini配置如下
[mysqld]
basedir=E:/mysql
datadir=E:/mysql/data
启动服务时还是报这样的错误,为什么???
sweetykiss
2003-08-07, 10:32
还是没用。:(
mysql 服务无法启动
系统出错
系统发生1067错误
进程意外中止
sweetykiss
2003-08-07, 11:14
查看了.err文件。
InnoDB: Error: auto-extending data file .\ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
030807 10:52:11 Can't init databases
030807 10:52:11 Aborting
030807 10:52:11 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
030807 10:52:11 MySql: Shutdown Complete
你直接在windows双击安装好了,别用命令.
然后运行mysqld-nt
sweetykiss
2003-08-07, 14:21
不行。
sweetykiss
2003-08-07, 16:16
下了个低版本的,一切OK了。
sweetykiss
2003-08-08, 08:19
谢谢楼上各位朋友的帮助了。
vBulletin® v3.6.8,版权所有 ©2000-2009,Jelsoft Enterprises Ltd.