试试下面的命令:C:\mysql\bin>mysqld-nt remove Service successfully removed.C:\mysql\bin>mysqld-nt -install Service successfully installed.C:\mysql\bin>net start mysql MySQL服务已经启动成功。C:\mysql\bin>mysql Welcome to the MySQL monitor...
F:\mysql\bin>mysqld-nt remove Service successfully removed.F:\mysql\bin>mysqld-nt -install Service successfully installed.F:\mysql\bin>net start mysql MySql 服务正在启动 . MySql 服务无法启动。系统出错。系统发生 1067 错误。进程意外终止。 F:\mysql\bin>
F:\mysql\bin>mysqladmin -u root -p shutdown Enter password: ****** mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' (10061)' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306'F:\mysql\bin>
痛苦中
Service successfully removed.C:\mysql\bin>mysqld-nt -install
Service successfully installed.C:\mysql\bin>net start mysql
MySQL服务已经启动成功。C:\mysql\bin>mysql
Welcome to the MySQL monitor...
Service successfully removed.F:\mysql\bin>mysqld-nt -install
Service successfully installed.F:\mysql\bin>net start mysql
MySql 服务正在启动 .
MySql 服务无法启动。系统出错。系统发生 1067 错误。进程意外终止。
F:\mysql\bin>
感激不尽!!
c:\mysql\bin\mysqladmin-u root -p shutdown
然后再net start mysql重启服务。
Enter password: ******
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'F:\mysql\bin>
F:\mysql\bin>telnet localhost 3306
正在连接到localhost...无法打开到主机的连接 在端口 3306 : 连接失败重做系统会有效么?
basedir = f:/mysql/
# 基本目录:mysql安装目录
datadir = f:/mysql/data/
# 数据文件所在目录
#tmpdir#=
# 临时文件存放目录
#bind-address=192.168.0.2
# 本机的IP地址
port=3306
# 所占用的IP端口
log-bin = f:/mysql/log/123.log
# 二进制Log文件,用于镜像服务器
log =f:/mysql/log/sql.log
# Log记录
另外,卸载的时候注意:将MYSQL原来的安装目录和windows目录下的my.ini都删掉。建议改用mysql免安装版本,解压缩后直接拷贝到c:\mysql下,双击winmysqladmin.exe就行。windows平台的免安装版本:
http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.2-alpha-win-noinstall.zip/from/pick
我试过了,还是不行,应该是我的系统有问题
先装了个SQLSERVER等重装系统再试试
谢谢各位帮忙,非常感谢mathematician(数学家)