# /usr/bin/mysql: unknown variable 'default\_storage\_engine=InnoDB'

**URL:** <https://forums.percona.com/t/usr-bin-mysql-unknown-variable-default-storage-engine-innodb/1930>\
**Category:** Other MySQL® Questions\
**Created:** [November 19, 2012, 11:57am UTC](https://forums.percona.com/t/usr-bin-mysql-unknown-variable-default-storage-engine-innodb/1930 "2012-11-19T11:57:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rodz37](https://avatars.discourse-cdn.com/v4/letter/r/ecb155/32.png) [@rodz37](https://forums.percona.com/u/rodz37)\
**Post date:** [November 19, 2012, 11:57am UTC](https://forums.percona.com/t/usr-bin-mysql-unknown-variable-default-storage-engine-innodb/1930/1 "2012-11-19T11:57:13Z")

</div>

CentOS 6.3x64 - WHM/cPanel 11.34

Mysql removed an replaced with Percona Server.

Get this error below:

/usr/bin/mysql: unknown variable ‘default\_storage\_engine=InnoDB’  
Use of uninitialized value in numeric lt (\<) at /usr/local/cpanel/scripts/update\_db\_cache line 285.  
/usr/bin/mysqladmin: connect to server at ‘localhost’ failed  
error: ‘Access denied for user ‘root’@‘localhost’ (using password: YES)’

Do i Just need to update the root mysql password, seems not to be working well in WHM, so whats the correct command line to use?

Rod

---

<div class="post-metadata">

**Author:** ![bstrand](https://avatars.discourse-cdn.com/v4/letter/b/df788c/32.png) [@bstrand](https://forums.percona.com/u/bstrand)\
**Post date:** [November 20, 2012, 2:56pm UTC](https://forums.percona.com/t/usr-bin-mysql-unknown-variable-default-storage-engine-innodb/1930/2 "2012-11-20T14:56:53Z")

</div>

Perhaps the default\_storage\_engine option is in the wrong section of your config file? From the executable name (/usr/bin/mysql) it sounds like it’s in the [client] or [mysql] sections of your config file as opposed to the [mysqld] section.

---

<div class="post-metadata">

**Author:** ![rodz37](https://avatars.discourse-cdn.com/v4/letter/r/ecb155/32.png) [@rodz37](https://forums.percona.com/u/rodz37)\
**Post date:** [November 20, 2012, 6:21pm UTC](https://forums.percona.com/t/usr-bin-mysql-unknown-variable-default-storage-engine-innodb/1930/3 "2012-11-20T18:21:48Z")

</div>

Weird, this is my.cnf

# Generated by Percona Configuration Wizard ([http://tools.percona.com/](http://tools.percona.com/)) version REL5-20120208[mysql]# CLIENT #port = 3306socket = /var/lib/mysql/mysql.sock[mysql]# GENERAL #user = mysqldefault\_storage\_engine = InnoDBsocket = /var/lib/mysql/mysql.sockpid\_file = /var/lib/mysql/mysql.pid# MyISAM #key\_buffer\_size = 32Mmyisam\_recover = FORCE,BACKUP# SAFETY #max\_allowed\_packet = 16Mmax\_connect\_errors = 1000000skip\_name\_resolvesql\_mode = STRICT\_TRANS\_TABLES,ERROR\_FOR\_DIVISION\_BY\_ZERO,NO\_AUTO\_CREATE\_USER,NO\_AUTO\_VALUE\_ON\_ZERO,NO\_ENGINE\_SUBSTITUTION,NO\_ZERO\_DATE,NO\_ZERO\_IN\_DATE,ONLY\_FULL\_GROUP\_BYsysdate\_is\_now = 1innodb = FORCEinnodb\_strict\_mode = 1# DATA STORAGE #datadir = /var/lib/mysql# BINARY LOGGING #log\_bin = /var/lib/mysql/data/mysql-binexpire\_logs\_days = 14sync\_binlog = 1# CACHES AND LIMITS #tmp\_table\_size = 32Mmax\_heap\_table\_size = 32Mquery\_cache\_type = 0query\_cache\_size = 0max\_connections = 500thread\_cache\_size = 50open\_files\_limit = 65535table\_definition\_cache = 4096table\_open\_cache = 1024# INNODB #innodb\_flush\_method = O\_DIRECTinnodb\_log\_files\_in\_group = 2innodb\_log\_file\_size = 512Minnodb\_flush\_log\_at\_trx\_commit = 1innodb\_file\_per\_table = 1innodb\_buffer\_pool\_size = 20G# LOGGING #log\_error = /var/lib/mysql/mysql-error.loglog\_queries\_not\_using\_indexes = 1slow\_query\_log = 1slow\_query\_log\_file = /var/lib/mysql/mysql-slow.log