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 使用C#,asp.net读取Excel文件并保存到Oracle数据库
  • ¥15 C# datagridview 单元格显示进度及值
  • ¥15 thinkphp6配合social login单点登录问题
  • ¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
  • ¥15 如何在scanpy上做差异基因和通路富集?
  • ¥20 关于#硬件工程#的问题,请各位专家解答!
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配