注意:查看/tem文件权限是不是 777 ,再添加 install plugin innodb soname ‘ha_innodb.so’; ,它会在tmp文件中写一个文本,如果没有权限,则报出找不到文件错误。系统环境:linux
数据库版本:mysql 5.1.47
需要要安装innodb类型支持
先查看mysql是否安装了innodb插件
[root@localhost bin]# ./mysql mysql> show plugin; +| Name | Status | Type | Library | License | +| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL | | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | +
发现没有安装
mysql> install plugin innodb soname 'ha_innodb.so'; ERROR 1126 (HY000): Can't open shared library '/usr/local/mysql/lib/mysql/plugin/ha_innodb.so' (errno: 13 cannot restore segment prot after reloc: Permission denied)
发现权限有问题
[root@localhost plugin]
给权限再安装
mysql> install plugin innodb soname 'ha_innodb.so'; Query OK, 0 rows affected (0.36 sec) mysql> show plugin; +| Name | Status | Type | Library | License | +| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL | | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | InnoDB | ACTIVE | STORAGE ENGINE | ha_innodb.so | GPL | +6 rows in set, 1 warning (0.00 sec)
安装成功
修改mysql配置文件/etc/my.cnf为以下内容.只为安装.就用默认值了.
innodb_data_home_dir = /usr/local/mysql/var/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/var/ innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50
重启数据库
/etc/init.d/mysqld restart
如果您喜欢我写的博文,读后觉得收获很大,不妨小额赞助我一下,让我有动力继续写出高质量的博文,感谢您的赞赏!!!