141125 1:12:34 [Note] Plugin 'FEDERATED' is disabled.
141125 1:12:34 [Note] Plugin 'InnoDB' is disabled.
141125 1:12:35 [Note] Event Scheduler: Loaded 0 events
141125 1:12:35 [Note] F:\BBS\bin\mysqld: ready for connections.
Version: '5.1.41-community' socket: '' port: 3306 MySQL Community Server (GPL)
141125 9:20:18 [Note] F:\BBS\bin\mysqld: Normal shutdown错误日志如上,打算用PHP +mysql 安装DZ论坛的,没想到提示PHP has encountered an Access Violation at 028DABDA,一直不知道原因所在,查了下MYSQL的错误信息,请各位提供一个思路或者方法怎么解决这个错误,谢谢。
141125 1:12:34 [Note] Plugin 'InnoDB' is disabled.
141125 1:12:35 [Note] Event Scheduler: Loaded 0 events
141125 1:12:35 [Note] F:\BBS\bin\mysqld: ready for connections.
Version: '5.1.41-community' socket: '' port: 3306 MySQL Community Server (GPL)
141125 9:20:18 [Note] F:\BBS\bin\mysqld: Normal shutdown错误日志如上,打算用PHP +mysql 安装DZ论坛的,没想到提示PHP has encountered an Access Violation at 028DABDA,一直不知道原因所在,查了下MYSQL的错误信息,请各位提供一个思路或者方法怎么解决这个错误,谢谢。
141125 13:46:31 [Note] Event Scheduler: Purging the queue. 0 events
141125 13:46:33 [Warning] F:\BBS\bin\mysqld: Forcing close of thread 2 user: 'root'141125 13:46:33 [Note] F:\BBS\bin\mysqld: Shutdown completeInnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
141125 13:48:59 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
141125 13:49:00 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...
141125 13:49:01 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
141125 13:49:02 InnoDB: Started; log sequence number 0 0
141125 13:49:02 [Note] Event Scheduler: Loaded 0 events
141125 13:49:02 [Note] F:\BBS\bin\mysqld: ready for connections.
Version: '5.1.41-community' socket: '' port: 3306 MySQL Community Server (GPL)
141125 13:49:56 [Note] F:\BBS\bin\mysqld: Normal shutdown141125 13:49:56 [Note] Event Scheduler: Purging the queue. 0 events
141125 13:49:58 [Warning] F:\BBS\bin\mysqld: Forcing close of thread 5 user: 'root'141125 13:49:58 InnoDB: Starting shutdown...
141125 13:49:59 InnoDB: Shutdown completed; log sequence number 0 44233
141125 13:49:59 [Note] F:\BBS\bin\mysqld: Shutdown complete麻烦各位看看
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
141125 13:48:59 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
141125 13:49:00 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...
141125 13:49:01 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB上面让你删除ib_logfile开头的文件,怎么把ibdata1也删了。这个文件可是默认的数据文件,删了自然就没有系统表,所以你的SHOW DATABASES什么都没有。
官网有恢复系统表的方法,不过我觉得还是卸了重装一下恢复比较简单。
我没有进行删除,sql重装过好几次了,5.1 5.5版本的都装了。。MYSQL重装后也没有看到ibdata1 这个东西。。这个东西是通常是放到哪里的?
这种应该属于连接成功了吧。。所以,就不需要继续在MYSQL方向花时间了。 MYSQL数据库本身没有任何问题。检查你的PHP
我没有进行删除,sql重装过好几次了,5.1 5.5版本的都装了。。MYSQL重装后也没有看到ibdata1 这个东西。。这个东西是通常是放到哪里的?
ibdata1是innodb引擎的默认数据文件,innodb引擎的数据都存储在这里,应该是在/var/lib/mysql下面,没有这个文件很奇怪。