|
1 所谓的初始化数据库脚本运行错误 /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql ps1：mysql安装在/usr/local/mysql/ ps2：没有打印任何日志 2 /usr/local/mysql/目录权限已经全部设定ok，全部为mysql:mysql（mysql用户和mysql群组） 3 另外有个很奇怪的现象是很多人都不提需要把my.cnf拷贝到/etc/目录下，自己拷贝了一下，否则日志也没法生成的。 顺便加了配置项，与上面初始化数据库脚本一致的信息： [mysqld] basedir = /usr/local/mysql datadir = /usr/local/mysql/data log-error = /usr/local/mysql/mysql_error.log pid-file = /usr/local/mysql/mysql.pid user = mysql tmpdir = /tmp 3 无视最上面脚本运行错误，直接运行mysqld_safe --user=mysql & 日志： ********************************************************************* 130205 11:17:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist130205 11:17:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.130205 11:17:58 InnoDB: The InnoDB memory heap is disabled130205 11:17:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins130205 11:17:58 InnoDB: Compressed tables use zlib 1.2.3130205 11:17:58 InnoDB: Using Linux native AIO130205 11:17:58 InnoDB: CPU does not support crc32 instructions130205 11:17:58 InnoDB: Initializing buffer pool, size = 16.0M130205 11:17:58 InnoDB: Completed initialization of buffer poolInnoDB: Error: auto-extending data file /usr/local/mysql/data/ibdata1 is of a different sizeInnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!130205 11:17:58 InnoDB: Could not open or create data files.130205 11:17:58 InnoDB: If you tried to add new data files, and it failed here,130205 11:17:58 InnoDB: you should now edit innodb_data_file_path in my.cnf back130205 11:17:58 InnoDB: to what it was, and remove the new ibdata files InnoDB created130205 11:17:58 InnoDB: in this failed attempt. InnoDB only wrote those files full of130205 11:17:58 InnoDB: zeros, but did not yet use them in any way. But be careful: do not130205 11:17:58 InnoDB: remove old data files which contain your precious data!130205 11:17:58 [ERROR] Plugin 'InnoDB' init function returned error.130205 11:17:58 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.130205 11:17:58 [ERROR] Unknown/unsupported storage engine: InnoDB130205 11:17:58 [ERROR] Aborting 130205 11:17:58 [Note] Binlog end130205 11:17:58 [Note] Shutting down plugin 'partition'130205 11:17:58 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'130205 11:17:58 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'130205 11:17:58 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'130205 11:17:58 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'130205 11:17:58 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'130205 11:17:58 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'130205 11:17:58 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'130205 11:17:58 [Note] Shutting down plugin 'INNODB_SYS_TABLES'130205 11:17:58 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'130205 11:17:58 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'130205 11:17:58 [Note] Shutting down plugin 'INNODB_FT_CONFIG'130205 11:17:58 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'130205 11:17:58 [Note] Shutting down plugin 'INNODB_FT_DELETED'130205 11:17:58 [Note] Shutting down plugin 'INNODB_FT_INSERTED'130205 11:17:58 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'130205 11:17:58 [Note] Shutting down plugin 'INNODB_METRICS'130205 11:17:58 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'130205 11:17:58 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'130205 11:17:58 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'130205 11:17:58 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'130205 11:17:58 [Note] Shutting down plugin 'INNODB_CMPMEM'130205 11:17:58 [Note] Shutting down plugin 'INNODB_CMP_RESET'130205 11:17:58 [Note] Shutting down plugin 'INNODB_CMP'130205 11:17:58 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'130205 11:17:58 [Note] Shutting down plugin 'INNODB_LOCKS'130205 11:17:58 [Note] Shutting down plugin 'INNODB_TRX'130205 11:17:58 [Note] Shutting down plugin 'CSV'130205 11:17:58 [Note] Shutting down plugin 'MEMORY'130205 11:17:58 [Note] Shutting down plugin 'MRG_MYISAM'130205 11:17:58 [Note] Shutting down plugin 'MyISAM'130205 11:17:58 [Note] Shutting down plugin 'mysql_old_password'130205 11:17:58 [Note] Shutting down plugin 'mysql_native_password': ************************************************************************ (责任编辑：IT) |