系统出错。发生系统错误 1067进程意外终止。
在网上找了很多资料并都做了,也重装了好几次,还是没办法解决,那位高手指点下啊
.err文件内容如下
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100921 10:31:58 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100921 10:31:59 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100921 10:32:00 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 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
100921 10:32:02 InnoDB: Started; log sequence number 0 0
100921 10:32:10 [Note] mysqld: ready for connections.
Version: '5.1.6-alpha-max' socket: '' port: 3306 MySQL Community Edition (GPL)
在网上找了很多资料并都做了,也重装了好几次,还是没办法解决,那位高手指点下啊
.err文件内容如下
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100921 10:31:58 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100921 10:31:59 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100921 10:32:00 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 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
100921 10:32:02 InnoDB: Started; log sequence number 0 0
100921 10:32:10 [Note] mysqld: ready for connections.
Version: '5.1.6-alpha-max' socket: '' port: 3306 MySQL Community Edition (GPL)
[mysql]
skip-innodb看看能否启动MYSQL
Version: '5.1.6-alpha-max' socket: '' port: 3306 MySQL Community Edition (GPL)
上面这句显示,你的MYSQL服务已经启动成功并可以进行连接了。
你的问题是什么? 你是如何判断 “mysql安装后无法启动” 的?
我猜你并不是无法启动,而是你无法连接吧。
[收集]mysql 无法联接故障现象及原因
要是从日志看,服务已经开启了。如果服务已经开启的情况下,不可能再次开启服务。你可以在任务管理器中看有没有一个 mysqld.exe在运行。
然后再把错误日志中的内容贴出业。
MySQL: Table 'mysql.plugin' doesn't exist
100921 22:53:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100921 22:53:41 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100921 22:53:42 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...
100921 22:53:43 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
100921 22:53:45 InnoDB: Started; log sequence number 0 0
100921 22:53:46 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
MySQL: Table 'mysql.plugin' doesn't exist
100921 22:54:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
100921 22:54:35 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
100921 22:54:35 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
100921 22:54:36 InnoDB: Started; log sequence number 0 46409
100921 22:54:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist报错