如题,mysql服务已经启动,但是在安装完配置安全设置的时候不行了。报错:
ERROR2003:Can't connect to MySQL server on 'localhost'<10061> 原来是可以启动的,后来我把服务停了一阵儿,再打开就不行了。重装也不行,不知道是不是因为杀毒软件的原因!再次卸载后清理了注册表,重启后安装还是不行。服务能起来,3306端口正常,就是连不上。
==用如下方法处理过,也不行
进入CMD(命令窗口)
cd mysql 回车
cd bin 回车
mysqld-nt --install 回车
mysql 回车 还将my.ini手动拷贝到了windows目录下。==========
求教各位高手!
ERROR2003:Can't connect to MySQL server on 'localhost'<10061> 原来是可以启动的,后来我把服务停了一阵儿,再打开就不行了。重装也不行,不知道是不是因为杀毒软件的原因!再次卸载后清理了注册表,重启后安装还是不行。服务能起来,3306端口正常,就是连不上。
==用如下方法处理过,也不行
进入CMD(命令窗口)
cd mysql 回车
cd bin 回车
mysqld-nt --install 回车
mysql 回车 还将my.ini手动拷贝到了windows目录下。==========
求教各位高手!
解决方案 »
- 求教:什么情况下才用视图,存储过程或query_cache或memcache? 想生成临时表
- 棘手的问题。PostgreSQL 数据库查询问题。在java中居然不能查询中文。。。。。。
- 请问这个sql怎么写
- MYSQL的client charactor set 为何被改了?
- 请问查找当某个属性值不为空的记录的sql语句怎么写呀
- !!!连接四个表!!!
- 在XP下能用Mysql吗?
- 一个容纳5000个品种的mysql数据库设计(b/s),需要注意写什么!(有兴趣请进) /
- 高分求教,有可视化创建mysql数据库的开发工具么
- mysql 中的update 语法?
- 问一个mysql的排序问题,where code in('108','001','191')
- 服务器重启后 MYSQL 不能用
[收集]mysql 无法联接故障现象及原因
cmd下netstat -na 可以看到是哪个进程占用了3306端口, 然后启动任务管理器,视图 ,启用进程列,找到占用3306的端口,把他杀死就可以了
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)C:\Program Files\MySQL\MySQL Server 5.1\bin>
[/code][code=BatchFile]C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -u root -p123 csdn
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.33-community-log MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql>[/code]
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.11-alpha-community MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
===
以上是我的mysql信息……
Connection id: 2
Current database: *** NONE ***====
是不是因为我没有数据库引起的啊?
+----------------+---------------------+
| user() | now() |
+----------------+---------------------+
| root@localhost | 2009-11-01 22:48:34 |
+----------------+---------------------+
1 row in set (0.13 sec)mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.44 sec)mysql>=====显示出来的信息好像是重装前的配置!可视化的工具都不能连上
至少现在说明,你的mysql服务启动没有问题。你的可视化工具估计没有配置好。
事件来源: MySQL
事件种类: 无
事件 ID: 100
日期: 2009-11-2
事件: 8:50:22
用户: N/A
计算机: G
描述:
事件 ID ( 100 )的描述(在资源( MySQL )中)无法找到。本地计算机可能没有必要的注册信息或消息 DLL 文件来从远端计算机显示消息。您可能可以使用 /AUXSOURCE= 标识来检索词描述;查看帮助和支持以了解详细信息。下列信息是事件的一部分: D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL).
事件类型: 信息
事件来源: MySQL
事件种类: 无
事件 ID: 100
日期: 2009-11-2
事件: 8:50:22
用户: N/A
计算机: G
描述:
事件 ID ( 100 )的描述(在资源( MySQL )中)无法找到。本地计算机可能没有必要的注册信息或消息 DLL 文件来从远端计算机显示消息。您可能可以使用 /AUXSOURCE= 标识来检索词描述;查看帮助和支持以了解详细信息。下列信息是事件的一部分: Event Scheduler: Loaded 0 events.--------------以上是我从事件查看器里找出来的信息。
找不到指定的模块。 Service Control Manager错误
---------------系统错误
http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#log-files
5.11. MySQL日志文件
5.11.1. 错误日志
5.11.2. 通用查询日志
5.11.3. 二进制日志
5.11.4. 慢速查询日志
5.11.5. 日志文件维护
091031 15:54:04 [Note] Falcon: creating new system data files.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
091031 15:54:05 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
091031 15:54:06 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
091031 15:54:06 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 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
091031 15:54:07 InnoDB: Started; log sequence number 0 0
091031 15:54:08 [Note] Event Scheduler: Loaded 0 events
091031 15:54:08 [Note] C:\Program Files\MySQL\MySQL Server 6.0\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091031 15:55:13 [Note] C:\Program Files\MySQL\MySQL Server 6.0\bin\mysqld: Normal shutdown091031 15:55:13 [Note] Event Scheduler: Purging the queue. 0 events
091031 15:55:14 InnoDB: Starting shutdown...
091031 15:55:15 InnoDB: Shutdown completed; log sequence number 0 46409
091031 15:55:17 [Warning] Forcing shutdown of 1 plugins
091031 15:55:17 [Note] C:\Program Files\MySQL\MySQL Server 6.0\bin\mysqld: Shutdown complete091031 15:56:06 InnoDB: Started; log sequence number 0 46409
091031 15:56:06 [Note] Event Scheduler: Loaded 0 events
091031 15:56:06 [Note] C:\Program Files\MySQL\MySQL Server 6.0\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091031 16:04:03 [Note] C:\Program Files\MySQL\MySQL Server 6.0\bin\mysqld: Normal shutdown091031 16:04:03 [Note] Event Scheduler: Purging the queue. 0 events
091031 16:04:04 InnoDB: Starting shutdown...
091031 16:04:05 InnoDB: Shutdown completed; log sequence number 0 46409
091031 16:04:05 [Warning] Forcing shutdown of 1 plugins
091031 16:04:05 [Note] C:\Program Files\MySQL\MySQL Server 6.0\bin\mysqld: Shutdown complete091031 16:04:09 InnoDB: Started; log sequence number 0 46409
091031 16:04:09 [Note] Event Scheduler: Loaded 0 events
091031 16:04:09 [Note] C:\Program Files\MySQL\MySQL Server 6.0\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091031 16:16:01 [Note] C:\Program Files\MySQL\MySQL Server 6.0\bin\mysqld: Normal shutdown091031 16:16:01 [Note] Event Scheduler: Purging the queue. 0 events
091031 16:16:02 InnoDB: Starting shutdown...
091031 16:16:02 InnoDB: Shutdown completed; log sequence number 0 46409
091031 16:16:03 [Warning] Forcing shutdown of 1 plugins
091031 16:16:03 [Note] C:\Program Files\MySQL\MySQL Server 6.0\bin\mysqld: Shutdown complete091031 16:36:39 InnoDB: Started; log sequence number 0 46409
091031 16:36:39 [Note] Event Scheduler: Loaded 0 events
091031 16:36:39 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091031 20:39:43 [ERROR] Falcon: can't open file "C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 6.0\Data\falcon_master.fts": Permission denied (13)
091031 20:39:43 [ERROR] Plugin 'Falcon' init function returned error.
091031 20:39:43 [ERROR] Plugin 'Falcon' registration as a STORAGE ENGINE failed.
091031 20:39:44 InnoDB: Error: unable to create temporary file; errno: 13
091031 20:39:44 [ERROR] Plugin 'InnoDB' init function returned error.
091031 20:39:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
091031 20:39:44 [ERROR] Unknown/unsupported table type: INNODB
091031 20:39:44 [ERROR] Aborting091031 20:39:44 [Warning] Forcing shutdown of 1 plugins
091031 20:39:44 [Note] mysqld: Shutdown complete091031 20:51:10 [Note] D:\javasoft\mysql\bin\mysqld: Normal shutdown091031 20:51:11 [Note] Event Scheduler: Purging the queue. 0 events
091031 20:51:16 InnoDB: Starting shutdown...
091031 20:51:18 InnoDB: Shutdown completed; log sequence number 0 46409
091031 20:51:19 [Warning] Forcing shutdown of 1 plugins
091031 21:45:07 InnoDB: Started; log sequence number 0 46409
091031 21:45:07 [Note] Event Scheduler: Loaded 0 events
091031 21:45:07 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091101 0:54:55 [Note] D:\javasoft\mysql\bin\mysqld: Normal shutdown091101 0:54:56 [Note] Event Scheduler: Purging the queue. 0 events
091101 0:54:58 InnoDB: Starting shutdown...
091101 0:55:04 InnoDB: Shutdown completed; log sequence number 0 46409
091101 0:55:07 [Warning] Forcing shutdown of 1 plugins
091101 0:55:07 [Note] D:\javasoft\mysql\bin\mysqld: Shutdown complete091101 10:40:50 InnoDB: Started; log sequence number 0 46409
091101 10:40:50 [Note] Event Scheduler: Loaded 0 events
091101 10:40:50 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091101 19:30:25 [Note] D:\javasoft\mysql\bin\mysqld: Normal shutdown091101 19:30:25 [Note] Event Scheduler: Purging the queue. 0 events
091101 19:30:27 InnoDB: Starting shutdown...
091101 19:30:28 InnoDB: Shutdown completed; log sequence number 0 46409
091101 19:30:32 [Warning] Forcing shutdown of 1 plugins
091101 19:30:33 [Note] D:\javasoft\mysql\bin\mysqld: Shutdown complete091101 19:30:38 InnoDB: Started; log sequence number 0 46409
091101 19:30:38 [Note] Event Scheduler: Loaded 0 events
091101 19:30:38 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091102 0:27:15 [Note] D:\javasoft\mysql\bin\mysqld: Normal shutdown091102 0:27:17 [Note] Event Scheduler: Purging the queue. 0 events
091102 0:27:28 InnoDB: Starting shutdown...
091102 8:50:22 InnoDB: Started; log sequence number 0 46409
091102 8:50:22 [Note] Event Scheduler: Loaded 0 events
091102 8:50:22 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091102 14:39:14 [Note] D:\javasoft\mysql\bin\mysqld: Normal shutdown091102 14:39:14 [Note] Event Scheduler: Purging the queue. 0 events
091102 14:39:15 InnoDB: Starting shutdown...
091102 14:39:18 InnoDB: Shutdown completed; log sequence number 0 46409
091102 14:39:24 [Warning] Forcing shutdown of 1 plugins
091102 14:39:24 [Note] D:\javasoft\mysql\bin\mysqld: Shutdown complete091102 14:39:44 InnoDB: Started; log sequence number 0 46409
091102 14:39:45 [Note] Event Scheduler: Loaded 0 events
091102 14:39:45 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091102 14:41:12 [Note] D:\javasoft\mysql\bin\mysqld: Normal shutdown091102 14:41:12 [Note] Event Scheduler: Purging the queue. 0 events
091102 14:41:12 InnoDB: Starting shutdown...
091102 14:41:13 InnoDB: Shutdown completed; log sequence number 0 46409
091102 14:41:14 [Warning] Forcing shutdown of 1 plugins
091102 14:41:14 [Note] D:\javasoft\mysql\bin\mysqld: Shutdown complete091102 14:41:17 InnoDB: Started; log sequence number 0 46409
091102 14:41:18 [Note] Event Scheduler: Loaded 0 events
091102 14:41:18 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091102 15:01:10 [Note] D:\javasoft\mysql\bin\mysqld: Normal shutdown091102 15:01:10 [Note] Event Scheduler: Purging the queue. 0 events
091102 15:01:11 InnoDB: Starting shutdown...
091102 15:01:13 InnoDB: Shutdown completed; log sequence number 0 46409
091102 15:01:14 [Warning] Forcing shutdown of 1 plugins
091102 15:01:15 [Note] D:\javasoft\mysql\bin\mysqld: Shutdown complete091102 15:01:23 InnoDB: Started; log sequence number 0 46409
091102 15:01:23 [Note] Event Scheduler: Loaded 0 events
091102 15:01:23 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091102 15:02:27 [Note] D:\javasoft\mysql\bin\mysqld: Normal shutdown091102 15:02:27 [Note] Event Scheduler: Purging the queue. 0 events
091102 15:02:28 InnoDB: Starting shutdown...
091102 15:02:29 InnoDB: Shutdown completed; log sequence number 0 46409
091102 15:02:29 [Warning] Forcing shutdown of 1 plugins
091102 15:02:29 [Note] D:\javasoft\mysql\bin\mysqld: Shutdown complete
091102 21:20:55 [Note] Falcon: creating new system data files.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
091102 21:21:00 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
091102 21:21:01 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
091102 21:21:02 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 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
091102 21:21:07 InnoDB: Started; log sequence number 0 0
091102 21:21:07 [Note] Event Scheduler: Loaded 0 events
091102 21:21:07 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091102 21:23:23 [Note] D:\javasoft\mysql\bin\mysqld: Normal shutdown091102 21:23:23 [Note] Event Scheduler: Purging the queue. 0 events
091102 21:23:23 InnoDB: Starting shutdown...
091102 21:23:24 InnoDB: Shutdown completed; log sequence number 0 46409
091102 21:23:25 [Warning] Forcing shutdown of 1 plugins
091102 21:23:25 [Note] D:\javasoft\mysql\bin\mysqld: Shutdown complete091102 21:24:13 InnoDB: Started; log sequence number 0 46409
091102 21:24:13 [Note] Event Scheduler: Loaded 0 events
091102 21:24:13 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091102 21:24:45 [Note] D:\javasoft\mysql\bin\mysqld: Normal shutdown091102 21:24:45 [Note] Event Scheduler: Purging the queue. 0 events
091102 21:24:45 InnoDB: Starting shutdown...
091102 21:24:46 InnoDB: Shutdown completed; log sequence number 0 46409
091102 21:24:47 [Warning] Forcing shutdown of 1 plugins
091102 21:24:47 [Note] D:\javasoft\mysql\bin\mysqld: Shutdown complete091102 21:24:49 InnoDB: Started; log sequence number 0 46409
091102 21:24:49 [Note] Event Scheduler: Loaded 0 events
091102 21:24:49 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)
091102 21:30:09 [Note] D:\javasoft\mysql\bin\mysqld: Normal shutdown091102 21:30:09 [Note] Event Scheduler: Purging the queue. 0 events
091102 21:30:10 InnoDB: Starting shutdown...
091102 21:30:11 InnoDB: Shutdown completed; log sequence number 0 46409
091102 21:30:12 [Warning] Forcing shutdown of 1 plugins
091102 21:30:12 [Note] D:\javasoft\mysql\bin\mysqld: Shutdown complete091102 21:30:15 InnoDB: Started; log sequence number 0 46409
091102 21:30:16 [Note] Event Scheduler: Loaded 0 events
091102 21:30:16 [Note] D:\javasoft\mysql\bin\mysqld: ready for connections.
Version: '6.0.11-alpha-community' socket: '' port: 3306 MySQL Community Server (GPL)