Shulou(Shulou.com)05/31 Report--

Mysql how to modify the default storage engine, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Modify the default storage engine for mysql

1. View mysql storage engine commands

Enter show engines at the mysql > prompt

Field Support: Default indicates the default storage engine

Www.2cto.com

2. Set InnoDB as the default engine:

Add under [mysqld] in the configuration file my.cnf

Default-storage-engine=INNODB one sentence

3. Restart the mysql server:

Mysqladmin-u root-p shutdown

Or log in to mysql with service mysqld restart

After reading the above, have you mastered how to modify the default storage engine in mysql? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.