小弟我装了mysql后的,始终都会提示ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10057)的错误,在网上找了N多的资料都解决不了,但我用net start mysql会提示说我的服务已开启,但就是连接不了。
还有一个很严重的问题是,小弟我在控制面板那开了mysql的服务,但是一点启动,一闪而过就停止了,网上说是那个KB967723的问题,但是我在控制面板那找了很久,都没找到安装的信息,请问各位大侠,要怎么办才好
我是装在F盘,下面是错误信息:
请各位不吝赐教啊小弟万谢了
还有一个很严重的问题是,小弟我在控制面板那开了mysql的服务,但是一点启动,一闪而过就停止了,网上说是那个KB967723的问题,但是我在控制面板那找了很久,都没找到安装的信息,请问各位大侠,要怎么办才好
我是装在F盘,下面是错误信息:
请各位不吝赐教啊小弟万谢了
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100830 20:21:32 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100830 20:21:33 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 24 MB
InnoDB: Database physically writes the file full: wait...
100830 20:21:33 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 24 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
100830 20:21:34 InnoDB: Started; log sequence number 0 0
100830 20:21:34 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100830 20:21:34 [ERROR] Aborting100830 20:21:34 InnoDB: Starting shutdown...
100830 20:21:36 InnoDB: Shutdown completed; log sequence number 0 43655
100830 20:21:36 [Note] F:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete100830 20:21:42 InnoDB: Started; log sequence number 0 43655
100830 20:21:42 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100830 20:21:42 [ERROR] Aborting100830 20:21:42 InnoDB: Starting shutdown...
100830 20:21:44 InnoDB: Shutdown completed; log sequence number 0 43655
100830 20:21:44 [Note] F:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete100830 20:26:33 InnoDB: Started; log sequence number 0 43655
100830 20:26:33 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100830 20:26:33 [ERROR] Aborting100830 20:26:33 InnoDB: Starting shutdown...
100830 20:26:35 InnoDB: Shutdown completed; log sequence number 0 43655
100830 20:26:35 [Note] F:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete100830 20:27:17 InnoDB: Started; log sequence number 0 43655
100830 20:27:17 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100830 20:27:17 [ERROR] Aborting100830 20:27:17 InnoDB: Starting shutdown...
100830 20:27:19 InnoDB: Shutdown completed; log sequence number 0 43655
100830 20:27:19 [Note] F:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown completeInnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100830 20:30:22 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100830 20:30:22 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 24 MB
InnoDB: Database physically writes the file full: wait...
100830 20:30:24 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 24 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
100830 20:30:25 InnoDB: Started; log sequence number 0 0
100830 20:30:25 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100830 20:30:25 [ERROR] Aborting100830 20:30:25 InnoDB: Starting shutdown...
100830 20:30:27 InnoDB: Shutdown completed; log sequence number 0 43655
100830 20:30:27 [Note] F:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete100830 20:30:34 InnoDB: Started; log sequence number 0 43655
100830 20:30:34 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100830 20:30:34 [ERROR] Aborting100830 20:30:34 InnoDB: Starting shutdown...
100830 20:30:36 InnoDB: Shutdown completed; log sequence number 0 43655
100830 20:30:36 [Note] F:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete100830 20:31:14 InnoDB: Started; log sequence number 0 43655
100830 20:31:14 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100830 20:31:14 [ERROR] Aborting100830 20:31:14 InnoDB: Starting shutdown...
100830 20:31:16 InnoDB: Shutdown completed; log sequence number 0 43655
100830 20:31:16 [Note] F:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown completeInnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100830 20:31:49 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100830 20:31:49 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 24 MB
InnoDB: Database physically writes the file full: wait...
100830 20:31:50 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 24 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
100830 20:31:51 InnoDB: Started; log sequence number 0 0
100830 20:31:51 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100830 20:31:51 [ERROR] Aborting100830 20:31:51 InnoDB: Starting shutdown...
100830 20:31:53 InnoDB: Shutdown completed; log sequence number 0 43655
100830 20:31:53 [Note] F:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete100830 20:31:59 InnoDB: Started; log sequence number 0 43655
100830 20:31:59 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100830 20:31:59 [ERROR] Aborting100830 20:31:59 InnoDB: Starting shutdown...
100830 20:32:01 InnoDB: Shutdown completed; log sequence number 0 43655
100830 20:32:01 [Note] F:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
谢谢高手,MYSQL好像被删干净了,这个是新装的还有,那个3306的端口要怎么检查被占用?可不可以设为别的端口?
Application Management
Bluetooth Service
COM+ Event System
Computer Browser
Contrl Center of Storm Media
Cryptographic Services
DCOM Server Process Launcher
DHCP Client
Distributed Link Tracking Client
DNS Client
Event Log
Fast User Switching Compatibility
FTP Publishing
HID Input Service
IIS Admin
IPSEC Services
Java Quick Starter
Kingsoft Antivirus WebShield Service
Machine Debug Manager
Network Connections
Network Location Awareness (NLA)
NT LM Security Support Provider
NVIDIA Display Driver Service
Plug and Play
Print Spooler
Protected Storage
Rav Service
Remote Access Connection Manager
Remote Procedure Call (RPC)
RFW Service
Secondary Logon
Security Accounts Manager
Server
Shell Hardware Detection
Simple Mail Transfer Protocol (SMTP)
SQL Server (MSSQLSERVER)
SQL Server (SQLEXPRESS)
SQL Server Analysis Services (MSSQLSERVER)
SQL Server Browser
SQL Server FullText Search (MSSQLSERVER)
SQL Server VSS Writer
System Event Notification
TCP/IP NetBIOS Helper
Telephony
Terminal Services
Themes
WebClient
Windows Audio
Windows Firewall/Internet Connection Sharing (ICS)
Windows Image Acquisition (WIA)
Windows Management Instrumentation
Wireless Zero Configuration
Workstation
World Wide Web Publishing
主动防御命令成功完成。确实没有MYSQL服务,但是我在服务那打开MQL服务,系统几秒内就关了那服务
谢谢哦,关了后不会那个提示了,但是又出现了这个问题:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)崩溃中,这个又是什么问题???
[收集]mysql 无法联接故障现象及原因
set password ....MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖