mysqld启动失败
来源:互联网 发布:chinanet登陆软件 编辑:程序博客网 时间:2024/06/05 07:06
[root@localhost /]# /usr/libexec/mysqld
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
160413 11:57:35 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160413 11:57:35 InnoDB: Initializing buffer pool, size = 8.0M
160413 11:57:35 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
160413 11:57:35 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160413 11:57:35 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...
160413 11:57:35 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
160413 11:57:36 InnoDB: Started; log sequence number 0 0
160413 11:57:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
[root@localhost /]# /usr/libexec/mysqld start]
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
160413 11:58:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160413 11:58:15 InnoDB: Initializing buffer pool, size = 8.0M
160413 11:58:15 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
160413 11:58:15 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 44233
160413 11:58:15 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 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
160413 11:58:15 InnoDB: Started; log sequence number 0 44233
/usr/libexec/mysqld: Too many arguments (first extra is 'start]').
Use --verbose --help to get a list of available options
160413 11:58:15 [ERROR] Aborting
160413 11:58:15 InnoDB: Starting shutdown...
160413 11:58:21 InnoDB: Shutdown completed; log sequence number 0 44233
160413 11:58:21 [Note] /usr/libexec/mysqld: Shutdown complete
[root@localhost /]# /usr/libexec/mysqld start
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
160413 11:58:24 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160413 11:58:24 InnoDB: Initializing buffer pool, size = 8.0M
160413 11:58:24 InnoDB: Completed initialization of buffer pool
160413 11:58:24 InnoDB: Started; log sequence number 0 44233
/usr/libexec/mysqld: Too many arguments (first extra is 'start').
Use --verbose --help to get a list of available options
160413 11:58:24 [ERROR] Aborting
160413 11:58:24 InnoDB: Starting shutdown...
160413 11:58:29 InnoDB: Shutdown completed; log sequence number 0 44233
160413 11:58:29 [Note] /usr/libexec/mysqld: Shutdown complete
[root@localhost /]# ps aux|grep mysqld
root 7149 1.0 0.1 4356 740 pts/0 S+ 11:58 0:00 grep mysqld
[root@localhost /]# /usr/libexec/mysqld --help
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
160413 11:58:49 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld Ver 5.1.73 for redhat-linux-gnu on i386 (Source distribution)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Starts the MySQL database server.
Usage: /usr/libexec/mysqld [OPTIONS]
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
160413 11:57:35 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160413 11:57:35 InnoDB: Initializing buffer pool, size = 8.0M
160413 11:57:35 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
160413 11:57:35 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160413 11:57:35 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...
160413 11:57:35 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
160413 11:57:36 InnoDB: Started; log sequence number 0 0
160413 11:57:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
[root@localhost /]# /usr/libexec/mysqld start]
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
160413 11:58:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160413 11:58:15 InnoDB: Initializing buffer pool, size = 8.0M
160413 11:58:15 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
160413 11:58:15 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 44233
160413 11:58:15 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 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
160413 11:58:15 InnoDB: Started; log sequence number 0 44233
/usr/libexec/mysqld: Too many arguments (first extra is 'start]').
Use --verbose --help to get a list of available options
160413 11:58:15 [ERROR] Aborting
160413 11:58:15 InnoDB: Starting shutdown...
160413 11:58:21 InnoDB: Shutdown completed; log sequence number 0 44233
160413 11:58:21 [Note] /usr/libexec/mysqld: Shutdown complete
[root@localhost /]# /usr/libexec/mysqld start
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
160413 11:58:24 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160413 11:58:24 InnoDB: Initializing buffer pool, size = 8.0M
160413 11:58:24 InnoDB: Completed initialization of buffer pool
160413 11:58:24 InnoDB: Started; log sequence number 0 44233
/usr/libexec/mysqld: Too many arguments (first extra is 'start').
Use --verbose --help to get a list of available options
160413 11:58:24 [ERROR] Aborting
160413 11:58:24 InnoDB: Starting shutdown...
160413 11:58:29 InnoDB: Shutdown completed; log sequence number 0 44233
160413 11:58:29 [Note] /usr/libexec/mysqld: Shutdown complete
[root@localhost /]# ps aux|grep mysqld
root 7149 1.0 0.1 4356 740 pts/0 S+ 11:58 0:00 grep mysqld
[root@localhost /]# /usr/libexec/mysqld --help
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
160413 11:58:49 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld Ver 5.1.73 for redhat-linux-gnu on i386 (Source distribution)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Starts the MySQL database server.
Usage: /usr/libexec/mysqld [OPTIONS]
For more help options (several pages), use mysqld --verbose --help.
--------------------------------------------------------------------------------------------
启动mysqld时,出现以上错误
原因是不存在当前mysql用户的表。执行 /usr/bin/mysql_install_db --user=mysql
在重新启动即可
1 0
- mysqld启动失败
- mysqld --initialize 执行失败
- 故障案例,db启动失败,报错mysqld: File binlog not found (Errcode: 2)
- 怎样正确启动mysqld服务
- 命令行mysqld启动不了数据库
- centos7 mysql 启动mysqld.service
- Linux Mysql无法启动 /var/run/mysqld/mysqld.sock
- 如何在linux中自动启动mysqld?
- 手动启动和停止mysqld.exe
- MySQL源码详解一 mysqld启动
- mysql 源码学习笔记:mysqld启动流程
- centos6.8安装mysqld后无法启动
- mysql启动方式:service mysqld start
- mysqld got signal 6 数据库无法启动
- wampserver 安装错误: mysqld.exe无法启动
- mysql 启动报错 /usr/local/mysql//libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid'
- MySQL的mysqld-nt.exe或者mysqld.exe启动不起来的原因
- mysql启动不了报 /var/run/mysqld/mysqld.sock无法连接的解决办法
- Activity、Fragment传值利器。Courier框架使用详解
- 让当前网页完全包含另一个页面
- [Memory] A look at the x86 "Self-referencing Page Directory trick"
- Qt相关数据类型转换
- 电容器在电路中的作用(很全)
- mysqld启动失败
- Wireshark表达式
- request中的各种方法
- Animation动画讲解文章
- CSS文字溢出部分显示为省略号
- 51 nod 1182 完美字符串
- Git初级使用教程
- 水果消除-----15HNUST校赛
- Updating local specs repositories/Creating shallow clone of spec repo `master` from