/usr/bin/mysql: unknown variable 'default_storage_engine=InnoDB'

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?


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.

Weird, this is my.cnf

Generated by Percona Configuration Wizard (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