Chinaunix首页 | 论坛 | 博客
  • 博客访问: 200658
  • 博文数量: 87
  • 博客积分: 10
  • 博客等级: 民兵
  • 技术积分: 840
  • 用 户 组: 普通用户
  • 注册时间: 2012-07-18 21:12
文章分类

全部博文(87)

文章存档

2014年(86)

我的朋友

分类: Mysql/postgreSQL

2014-06-27 16:10:44

140627 15:51:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

140627 15:44:34 mysqld_safe Starting mysqld daemon with databases from /app/mysql/data
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
140627 15:44:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140627 15:44:34 InnoDB: The InnoDB memory heap is disabled
140627 15:44:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140627 15:44:34 InnoDB: Compressed tables use zlib 1.2.3
140627 15:44:34 InnoDB: Initializing buffer pool, size = 512.0M
140627 15:44:34 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /app/mysql/data/ibdata1 did not exist:
InnoDB: a new database to be created!
140627 15:44:34  InnoDB: Setting file /app/mysql/data/ibdata1 size to 512 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
140627 15:44:36  InnoDB: Log file /app/mysql/data/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /app/mysql/data/ib_logfile0 size to 512 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
140627 15:44:38  InnoDB: Log file /app/mysql/data/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /app/mysql/data/ib_logfile1 size to 512 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
140627 15:44:41  InnoDB: Waiting for the background threads to start
140627 15:44:42 InnoDB: 5.5.37 started; log sequence number 0
140627 15:44:42 [Note] Recovering after a crash using /app/mysql/data/mysqld-bin
140627 15:44:42 [Note] Starting crash recovery...
140627 15:44:42 [Note] Crash recovery finished.
140627 15:44:42 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140627 15:44:42 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
140627 15:44:42 [Note] Server socket created on IP: '0.0.0.0'.
140627 15:44:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

解决方案:没有安装系统数据库 因而找不到系统权限表  
安装系统数据库: /usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/app/mysql/data/ --basedir=/usr/local/mysql &
ps :编译安装的mysql 需要单独运行生成系统数据库的命令
rpm或者yum 安装的在安装的过程中就生成了系统数据库
阅读(1896) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~