How to check innoDb engine is enabled or not in MySQL

[Isaac]

Hi,
How do I check whether innoDb engine is enabled in MySQL?
Any help will be really appreciated.

[KelvinSmith]

Hello,

1. Sign in to shell to fire the command – mysql

After firing the above command you will see:

************************************************** **
[root@vps ~]# mysql
Welcome to the MySQL monitor. Commands end with; or \g.
Your MySQL connection id is xxxx
Server version: x.x.xx-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

************************************************** **

After this fire the following command:

mysql> SHOW VARIABLES LIKE 'have_innodb';

The output will be like the below:

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb | YES |
+---------------+-------+
1 row in set (0.00 sec)

If it is "YES" then the server has innoDb engine enabled, and if "No" then vise-versa.

Now exit by executing the quit command.