windows xp服务中启动mysql 提示本地计算机无法启动mysql服务错误3 系统找不到指定路径cmd里运行error 2003:Can't connect to MySQL server on 'localhost'(10061)卸载了mysql 文件夹删了 注册表里三项也删了 重装后第一次可以启动 重启电脑后就启动不了是不是和什么软件冲突 机子上有oracle
确认一下你的MYSQL是否安装完整。 你是如何启动的?通过widnows的服务管理器?还是通过命令? 看一下服务中的MYSQL服务的命令是什么? 比如 "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" MySQL然后检查一下这些相关的文件是否存在?
看一下是不是端口被占用了。dos下:netstat -a
data里有 xinnian-d0207ea.err 这个文件我是完整安装 从服务,dos,exlipse里启动都试过 全不行my.ini里配置:#Path to installation directory. All paths are usually resolved relative to this. basedir="D:/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/"
xinnian-d0207ea.err文件内容 090914 21:20:22 [Note] Plugin 'FEDERATED' is disabled. 090914 21:20:22 InnoDB: Started; log sequence number 0 124516 090914 21:20:22 [Note] Event Scheduler: Loaded 0 events 090914 21:20:23 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.36-community' socket: '' port: 3306 MySQL Community Server (GPL)
完整内容090914 14:28:48 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 090914 14:28:48 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 090914 14:28:49 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 16 MB InnoDB: Database physically writes the file full: wait... 090914 14:28:49 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 16 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 090914 14:28:50 InnoDB: Started; log sequence number 0 0 090914 14:28:50 [Note] Event Scheduler: Loaded 0 events 090914 14:28:50 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.36-community' socket: '' port: 3306 MySQL Community Server (GPL) 090914 14:34:10 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown090914 14:34:10 [Note] Event Scheduler: Purging the queue. 0 events 090914 14:34:10 InnoDB: Starting shutdown... 090914 14:34:10 InnoDB: Shutdown completed; log sequence number 0 46409 090914 14:34:10 [Warning] Forcing shutdown of 1 plugins 090914 14:34:10 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete090914 14:38:06 [Note] Plugin 'FEDERATED' is disabled. 090914 14:38:07 InnoDB: Started; log sequence number 0 46409 090914 14:38:07 [Note] Event Scheduler: Loaded 0 events 090914 14:38:07 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.36-community' socket: '' port: 3306 MySQL Community Server (GPL) 090914 17:16:34 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown090914 17:16:34 [Note] Event Scheduler: Purging the queue. 0 events 090914 17:16:34 InnoDB: Starting shutdown... 090914 17:16:36 InnoDB: Shutdown completed; log sequence number 0 124516 090914 17:16:36 [Warning] Forcing shutdown of 1 plugins 090914 17:16:36 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete090914 21:20:22 [Note] Plugin 'FEDERATED' is disabled. 090914 21:20:22 InnoDB: Started; log sequence number 0 124516 090914 21:20:22 [Note] Event Scheduler: Loaded 0 events 090914 21:20:23 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.36-community' socket: '' port: 3306 MySQL Community Server (GPL)
090914 21:20:23 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.36-community' socket: '' port: 3306 MySQL Community Server (GPL)从上述看,你的mysqld 服务已经 ready for connections.从你的任务管理器中看一下 mysqld.exe 有没有在运行?如果mysqld.exe 运行,则说明你的MYSQL服务已经没有问题了。 问题可能是你无关连接你的MYSQL服务。而不是“mysql 启动不起来”
$ mysql -u model -port=3306 -h 10.10.1.5 -p Enter password: *****加上端口 或者 $ mysql -u model -port=3306 -p Enter password: ***** 看能联通不
telnet 127.0.0.1 3306 输入后 提示不能打开到主机的链接,在端口 3306 :链接失败mysql.ini 里配置 # The TCP/IP Port the MySQL Server will listen on port=3306
今天没有 我刚启动了一下 但是没有发现err文件
哪里启动不都一样吗mysql command line clientdoseclipse都是一样
mysql -uroot -p123 testdb 这是连接MYSQL数据库的工具,不是启动MYSQL数据库啊。
你的mysqld.exe 在哪个目录中? my.ini 在哪个目录中?
mysqld.exe 在 D:\MySQL\MySQL Server 5.1\bin my.ini 在 D:\MySQL\MySQL Server 5.1
直接到DOS下执行。 "D:\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="D:\MySQL\MySQL Server 5.1\my.ini" 不是没有人帮你,而是大家基本上的回贴都是在问你的故障现象 问题说明越详细,回答也会越准确!参见如何提问。(提问的智慧)
晕 原来你是没启动服务还以为你只是连不上呢----------------- 这样处理:"开始"-->"运行"-->regedit-->HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services-->把mysql的对应服务那项全部删除掉然后在cmd窗口执行: cd D:\MySQL\MySQL Server 5.1\bin 接着再执行: mysqld --install mysql --defaults-file="D:\MySQL\MySQL Server 5.1\my.ini" 然后启动服务: net start mysql这样就可以连了
请直接回答,从命令行启动 mysql 是否成功2. 如果成功,请回答,在services.msc 中是否有 MYSQL 的服务?3。如果在services.msc 中是有 MYSQL 的服务, 则检查一下服务所对应命令,如果没有。太多IF THEN 了。
你是如何启动的?通过widnows的服务管理器?还是通过命令? 看一下服务中的MYSQL服务的命令是什么? 比如 "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" MySQL然后检查一下这些相关的文件是否存在?
basedir="D:/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/"
090914 21:20:22 [Note] Plugin 'FEDERATED' is disabled.
090914 21:20:22 InnoDB: Started; log sequence number 0 124516
090914 21:20:22 [Note] Event Scheduler: Loaded 0 events
090914 21:20:23 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.36-community' socket: '' port: 3306 MySQL Community Server (GPL)
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
090914 14:28:48 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090914 14:28:49 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 16 MB
InnoDB: Database physically writes the file full: wait...
090914 14:28:49 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 16 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
090914 14:28:50 InnoDB: Started; log sequence number 0 0
090914 14:28:50 [Note] Event Scheduler: Loaded 0 events
090914 14:28:50 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.36-community' socket: '' port: 3306 MySQL Community Server (GPL)
090914 14:34:10 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown090914 14:34:10 [Note] Event Scheduler: Purging the queue. 0 events
090914 14:34:10 InnoDB: Starting shutdown...
090914 14:34:10 InnoDB: Shutdown completed; log sequence number 0 46409
090914 14:34:10 [Warning] Forcing shutdown of 1 plugins
090914 14:34:10 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete090914 14:38:06 [Note] Plugin 'FEDERATED' is disabled.
090914 14:38:07 InnoDB: Started; log sequence number 0 46409
090914 14:38:07 [Note] Event Scheduler: Loaded 0 events
090914 14:38:07 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.36-community' socket: '' port: 3306 MySQL Community Server (GPL)
090914 17:16:34 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown090914 17:16:34 [Note] Event Scheduler: Purging the queue. 0 events
090914 17:16:34 InnoDB: Starting shutdown...
090914 17:16:36 InnoDB: Shutdown completed; log sequence number 0 124516
090914 17:16:36 [Warning] Forcing shutdown of 1 plugins
090914 17:16:36 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete090914 21:20:22 [Note] Plugin 'FEDERATED' is disabled.
090914 21:20:22 InnoDB: Started; log sequence number 0 124516
090914 21:20:22 [Note] Event Scheduler: Loaded 0 events
090914 21:20:23 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.36-community' socket: '' port: 3306 MySQL Community Server (GPL)
Version: '5.1.36-community' socket: '' port: 3306 MySQL Community Server (GPL)从上述看,你的mysqld 服务已经 ready for connections.从你的任务管理器中看一下 mysqld.exe 有没有在运行?如果mysqld.exe 运行,则说明你的MYSQL服务已经没有问题了。 问题可能是你无关连接你的MYSQL服务。而不是“mysql 启动不起来”
Enter password: *****加上端口 或者
$ mysql -u model -port=3306 -p
Enter password: *****
看能联通不
port=3306
这是连接MYSQL数据库的工具,不是启动MYSQL数据库啊。
my.ini 在哪个目录中?
my.ini 在 D:\MySQL\MySQL Server 5.1
"D:\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="D:\MySQL\MySQL Server 5.1\my.ini"
不是没有人帮你,而是大家基本上的回贴都是在问你的故障现象
问题说明越详细,回答也会越准确!参见如何提问。(提问的智慧)
你没有测试结果,别人根本没办法给你一套完全的方案。其中有很多IF THEN,要根据你的实际情况而定。
你这样的测试是成功还是不成功,事先没有人能猜到。
原来你是没启动服务还以为你只是连不上呢-----------------
这样处理:"开始"-->"运行"-->regedit-->HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services-->把mysql的对应服务那项全部删除掉然后在cmd窗口执行:
cd D:\MySQL\MySQL Server 5.1\bin
接着再执行:
mysqld --install mysql --defaults-file="D:\MySQL\MySQL Server 5.1\my.ini"
然后启动服务:
net start mysql这样就可以连了