第一:把你的my.ini文件复制到 c:/window 下面 (申明: 一般你安装mysql的地方里面的my.ini设置跟 window下面是一样的)
第二:设置my.ini 文件
[mysqld]
# generic configuration options
port = 3306
socket = /tmp/mysql.sock
#default-character-set=gbk
basedir=D:/server/mysql
datadir=D:/server/mysql/data
# *** INNODB Specific options ***
#skip-innodb (必须)
innodb_additional_mem_pool_size = 2M (必须)
innodb_buffer_pool_size = 16M (必须)
innodb_data_file_path = ibdata1:10M:autoextend (必须)
innodb_data_home_dir = "D:/server/mysql/" (必须)
innodb_file_io_threads = 4
#innodb_force_recovery=1
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1 (必须)
#innodb_fast_shutdown
innodb_log_buffer_size = 8M (必须)
innodb_log_file_size = 5M (必须)
innodb_log_files_in_group = 3
innodb_log_group_home_dir = "D:/server/mysql/" (必须)
innodb_max_dirty_pages_pct = 90
#innodb_flush_method=O_DSYNC
innodb_lock_wait_timeout = 50 (必须)
innodb_log_arch_dir = "D:/server/mysql/" (必须)
第三:从新启动你的phpmyadmin OK
第四:要是启动不了phpmyadmin 那就移除,从新安装一下 在从新启动 phpmyadmijn
另外收录到的:
我想用外键功能,是否必须用innoDB引擎? 但我用phpMyAdmin查看时,innoDB是灰色的,点击进去以后,上面写着: InnoDB has been disabled for this MySQL server. 请问我的MYSQL里是否没有这个引擎?我是否需要去下载安装?怎么安装?
我已经在MYSQL安装目录下的skip-innodb的左边加了个#,但还是没法用innoDB.使用alter table replyarticle type=innoDB; 就提示The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working
不是安装,你的MY.INI或者MY.CNF文件里面,有个skip innoDB的语句,删除了就有了