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 安装的在安装的过程中就生成了系统数据库
阅读(1910) | 评论(0) | 转发(0) |