qq_33686679 2016-08-27 13:53 采纳率: 0%
浏览 3449

mysql服务启动报错1607 求助大神!

错误日志:
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
160817 17:41:01 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160817 17:41:02 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...
160817 17:41:02 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
160817 17:41:03 InnoDB: Started; log sequence number 0 0
160817 17:41:03 [Note] E:\mysqlserver\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
160826 16:38:33 [Note] E:\mysqlserver\bin\mysqld-nt: Normal shutdown

160826 16:38:35 InnoDB: Starting shutdown...
160826 16:38:38 InnoDB: Shutdown completed; log sequence number 0 133556
160826 16:38:38 [Note] E:\mysqlserver\bin\mysqld-nt: Shutdown complete

160826 16:40:24 InnoDB: Started; log sequence number 0 133556
160826 16:40:25 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 17:28:58 InnoDB: Started; log sequence number 0 133556
160827 17:28:58 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 19:25:59 InnoDB: Started; log sequence number 0 133556
160827 19:25:59 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 19:26:03 InnoDB: Started; log sequence number 0 133556
160827 19:26:03 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 19:26:07 InnoDB: Started; log sequence number 0 133556
160827 19:26:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 19:32:24 InnoDB: Started; log sequence number 0 133556
160827 19:32:24 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 19:36:18 InnoDB: Started; log sequence number 0 133556
160827 19:36:18 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 19:37:25 InnoDB: Started; log sequence number 0 133556
160827 19:37:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 19:40:55 InnoDB: Started; log sequence number 0 133556
160827 19:40:55 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
160827 19:50:49 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160827 19:50:49 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...
160827 19:50:50 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
160827 19:50:50 InnoDB: Started; log sequence number 0 0
160827 19:50:50 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 19:50:55 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...
160827 19:50:55 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
160827 19:50:55 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
160827 19:50:56 InnoDB: Started; log sequence number 0 43655
160827 19:50:56 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 19:58:23 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...
160827 19:58:23 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
160827 19:58:23 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
160827 19:58:24 InnoDB: Started; log sequence number 0 43655
160827 19:58:24 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
160827 20:00:24 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160827 20:00:24 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...
160827 20:00:24 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
160827 20:00:25 InnoDB: Started; log sequence number 0 0
160827 20:00:25 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 20:01:54 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...
160827 20:01:54 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
160827 20:01:54 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
160827 20:01:55 InnoDB: Started; log sequence number 0 43655
160827 20:01:55 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 20:02:09 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...
160827 20:02:09 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
160827 20:02:09 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
160827 20:02:10 InnoDB: Started; log sequence number 0 43655
160827 20:02:10 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
160827 21:37:52 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...
160827 21:37:52 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
160827 21:37:52 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
160827 21:37:52 InnoDB: Started; log sequence number 0 43655
160827 21:37:52 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

  • 写回答

1条回答 默认 最新

  • 鱼弦 全栈领域优质创作者 2016-08-27 14:33
    关注

    a、>bin下执行mysqladmin-u root -p shutdown,然后重新执行net start mysql

    b、如果上述方法无效,下面方法可能可行

    复制mysql目录下my-default.ini文件,重命名为my.ini

    basedir = .....

    datadir = .....

    字段,修改为实际目录,例如

    basedir = C:\Program Files (x86)\MySQL\MySQL Server 5.6
    datadir = C:\Program Files (x86)\MySQL\MySQL Server 5.6\data

    删除mysql服务mysqld -remove

    重新安装mysqld -install

    执行net start mysql

    评论

报告相同问题?

悬赏问题

  • ¥15 Stata 面板数据模型选择
  • ¥20 idea运行测试代码报错问题
  • ¥15 网络监控:网络故障告警通知
  • ¥15 django项目运行报编码错误
  • ¥15 请问这个是什么意思?
  • ¥15 STM32驱动继电器
  • ¥15 Windows server update services
  • ¥15 关于#c语言#的问题:我现在在做一个墨水屏设计,2.9英寸的小屏怎么换4.2英寸大屏
  • ¥15 模糊pid与pid仿真结果几乎一样
  • ¥15 java的GUI的运用