Home > database >  Mysql to view the default storage engine, there is an error
Mysql to view the default storage engine, there is an error

Time:10-07


As shown in figure: see the Mysql storage engines, empty, in my. Ini file to add '# default - storage - engine=InnoDB', and then restart to find less than the default engine or;
And warm-hearted friends help solve, thank!

CodePudding user response:

# default - storage - engine=InnoDB

Remove the # in front, the meaning of this is a comment

CodePudding user response:

And then perform the show warnings;

CodePudding user response:

Show variables like '% engine;

CodePudding user response:

Even if there is no explicit setting mysql using the default engine, mysql will automatically to set a default engine, he certainly is not here, that problem is normal, you perform the show the variables like does not exist, even if the variable is only returns null, he has returned the warnings,

CodePudding user response:

Ask how to solve this problem, I also met the same problem
  • Related