"MySQL" MySQL 5.1.46 open InnoDB engine

It is well known that the Mysql5.1.46 default engine is MyISAM, so how do I turn on the InnoDB engine? I have a lot of errors in installing the database and turning on the InnoDB engine, we will list them for your reference only.

1. System environment

5.4 (Final)软件：MySQL-server-community-5.1.46-1.rhel5MySQL-shared-compat-5.1.37-0.rhel5MySQL-client-community-5.1.46-1.rhel5

2. Turn on InnoDB error

 Add the following in the configuration file  #cat /etc/my  Cnfdefault-storage  -engine  =  innodbdefault-table  -type  =  innodbdefault-character  -set  =  utf8character-set  -server  =  utf8collation-server  =  utf8_general_ci start failure log  #tail  -f /var /log /mysqld log  

3. Troubleshooting

See if MYQL supportsInnoDBEngine mysql>SHOWVariables like"have_%";+-------------------------+----------+|variable_name|Value|+-------------------------+----------+| have_community_features | YES|| have_compress | YES|| have_crypt | YES|| have_csv | YES|| have_dynamic_loading | YES|| have_geometry | YES|| have_innodb | NO|| have_ndbcluster | NO|| have_openssl | DISABLED|| have_partitioning | YES|| have_query_cache | YES|| have_rtree_keys | YES|| have_ssl | DISABLED|| have_symlink | YES|+-------------------------+----------+ -Rows in Set (0.00Sec

安装innodb插件提示初始化错误问题：mysql>  ‘ha_innodb_plugin1123 (HY000): Can‘tfunction‘InnoDBfunction failed.解决：把ibdata1,ib_datafile0,ib_datafile1重命名，让系统重新生成数据文件和两个日志文件；

"MySQL" MySQL 5.1.46 open InnoDB engine