mysql安装后刚开始是成功的,可是过会后再链接的时候就报错了,重启后又可以链接成功,但是一会后又出现不能链接的错误C:\Documents and Settings\Administrator>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。C:\Documents and Settings\Administrator>C:\mysql\bin\mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.48-community MySQL Community Server (GPL)Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 licenseType 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> exit
ByeC:\Documents and Settings\Administrator>C:\mysql\bin\mysql -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)然后有的重启mysql才能链接成功数据库求助高手!!!!
MySQL 服务正在启动 .
MySQL 服务已经启动成功。C:\Documents and Settings\Administrator>C:\mysql\bin\mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.48-community MySQL Community Server (GPL)Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 licenseType 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> exit
ByeC:\Documents and Settings\Administrator>C:\mysql\bin\mysql -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)然后有的重启mysql才能链接成功数据库求助高手!!!!
[收集]mysql 无法联接故障现象及原因
刚开始是有启动的,任务管理器里也是有进程的,只是过了一会再看就发现没有mysqld的进程了,需要重新net start mysql才行!!!!
电脑算得上是裸机,没有什么杀毒软件,也没有防火墙之类的mysql启动一会后总是自动停止
100713 15:30:37 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100713 15:30:38 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100713 15:30:38 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...
100713 15:30:38 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
100713 15:30:38 InnoDB: Started; log sequence number 0 0
100713 15:30:39 [Note] Event Scheduler: Loaded 0 events
100713 15:30:39 [Note] C:\mysql\bin\mysqld: ready for connections.
Version: '5.1.48-community' socket: '' port: 3306 MySQL Community Server (GPL)