Home >Database >Mysql Tutorial >修改mysql的默认存储引擎_MySQL
修改mysql的默认存储引擎_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:49:11930browse
bitsCN.com
1、查看mysql存储引擎命令，在mysql>提示符下搞入show engines;字段 Support为 Default表示默认存储引擎
2、设置InnoDB为默认引擎：在配置文件my.cnf中的 [mysqld] 下面加入default-storage-engine=INNODB 一句
3、重启mysql服务器：mysqladmin -u root -p shutdown或者service mysqld restart 登录mysql数据库，
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql createtable errno 121 150 错误 建表错误 外键_MySQLNext article：设置mysql最大连接数的方法_MySQL