新手求助!在线等!昨天刚装上MySql,试了一下可以用,今天打开的时候,输入密码后就闪退了~
通过 GUI可视化工具进去也出错“can't connect to MYSQL server on 'localhost'” ......
下面是.err文件:
130829 21:19:54 [Note] Plugin 'FEDERATED' is disabled.
130829 21:19:54 InnoDB: The InnoDB memory heap is disabled
130829 21:19:54 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130829 21:19:54 InnoDB: Compressed tables use zlib 1.2.3
130829 21:19:54 InnoDB: Initializing buffer pool, size = 47.0M
130829 21:19:54 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
130829 21:19:54 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130829 21:19:54 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...
130829 21:19:55 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: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130829 21:19:59 InnoDB: Waiting for the background threads to start
130829 21:20:00 InnoDB: 5.5.32 started; log sequence number 0
130829 21:20:00 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130829 21:20:00 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130829 21:20:00 [Note] Server socket created on IP: '0.0.0.0'.
130829 21:20:00 [Note] Event Scheduler: Loaded 0 events
130829 21:20:00 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections.
Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)
130829 22:20:11 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Normal shutdown130829 22:20:11 [Note] Event Scheduler: Purging the queue. 0 events
130829 22:20:11 InnoDB: Starting shutdown...
130829 22:20:14 InnoDB: Shutdown completed; log sequence number 1598476
130829 22:20:14 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete
求大神指导!!!!mysql闪退
通过 GUI可视化工具进去也出错“can't connect to MYSQL server on 'localhost'” ......
下面是.err文件:
130829 21:19:54 [Note] Plugin 'FEDERATED' is disabled.
130829 21:19:54 InnoDB: The InnoDB memory heap is disabled
130829 21:19:54 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130829 21:19:54 InnoDB: Compressed tables use zlib 1.2.3
130829 21:19:54 InnoDB: Initializing buffer pool, size = 47.0M
130829 21:19:54 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
130829 21:19:54 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130829 21:19:54 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...
130829 21:19:55 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: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130829 21:19:59 InnoDB: Waiting for the background threads to start
130829 21:20:00 InnoDB: 5.5.32 started; log sequence number 0
130829 21:20:00 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130829 21:20:00 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130829 21:20:00 [Note] Server socket created on IP: '0.0.0.0'.
130829 21:20:00 [Note] Event Scheduler: Loaded 0 events
130829 21:20:00 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections.
Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)
130829 22:20:11 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Normal shutdown130829 22:20:11 [Note] Event Scheduler: Purging the queue. 0 events
130829 22:20:11 InnoDB: Starting shutdown...
130829 22:20:14 InnoDB: Shutdown completed; log sequence number 1598476
130829 22:20:14 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete
求大神指导!!!!mysql闪退
Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)
130829 22:20:11 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Normal shutdown130829 21:20:00的时候启动完成,130829 22:20:11时候Normal shutdown,是不是有人停了服务?
你的mysql安装在自己电脑上的?服务没有设置为自动开启吧
你的mysql安装在自己电脑上的?服务没有设置为自动开启吧那时候应该是关机没有受到停止服务
你的mysql安装在自己电脑上的?服务没有设置为自动开启吧对,安装在自己的电脑上。也设置为自动开启了。我刚开始用mysql,完成一个作业
这个怎么弄额
然后mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini" --console --skip-grant-tables 打开第二个cmd窗口
mysql -uroot -p
出现
Enter password:
直接回车 看能进去不