How to change default storage engine in mysql

the default storage engine using in mysql is MyISAM and i need to change it.... how it can be done...???

Tags: MySQL
user image Author :   gabriel
1

Go to my.cnf config file, there defaultstorageengine will be MyISAM... change it as required and restart the mysql service....

Storage engine will be changed.

user image
jagan February 06, 2017
Add comment
0

Mysql is restarted successfully... where to check the current storage engine...???

user image
gabriel February 06, 2017
Add comment
0

Login to Mysql and run show engines; command....

There you can see the default is placed in the engine name which is mentioned in my.cnf file!!!

user image
jagan February 06, 2017
Add comment
0

For further reference follow the video:

Changing default storage engine in MySQL

user image
jagannatharumugam February 09, 2017
Add comment