Shulou(Shulou.com)06/01 Report--

How to view the mysql default storage engine? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The way to view the default storage engine of mysql is to first execute the [mysql-h localhost-u root-p] command to log in to mysql; and then execute the [show engines\ G] command to view the default storage engine.

First log in to the MYSQL database and use the command

Mysql-h localhost (address of mysql)-u user name-p

And then execute the command.

Show engines

Or

Show engines\ G

This gives you a clear view of the storage engine supported by MYSQL that you have installed.

The option for support:default is the default storage engine for MYSQL databases.

Thank you for reading! After reading the above, do you have a general idea of how to view the mysql default storage engine? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

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.