•  

Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
Conversation Detail Module
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts

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

    #1
    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
    Tags: None
  • #2
    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.

    Comment

    • #3
      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_S UBSTITUTION,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

      Comment

      • #4
        Yeah, you have two [mysql] sections. The second one should be [mysqld] like bstrand mentioned. The [mysql] section holds client configuration, while the [mysqld] section holds server configuration.

        Comment

        • #5
          Hello,

          We have a same problem on CentOS 6.3 :

          mysql -u root -pmypassword
          mysql: unknown variable 'default_storage_engine=InnoDB'


          I have generated a my.cnf on percona tools web site but my problem persist.
          my.cnf is :

          Quote:
          # Generated by Percona Configuration Wizard version REL5-20120208
          # Configuration name frdb998 generated for SGS at 2012-12-18 13:01:47

          [mysql]

          # CLIENT #
          port = 3306
          socket = /var/lib/mysql/mysql.sock

          [mysqld]

          # GENERAL #
          user = mysql
          default_storage_engine = InnoDB
          socket = /var/lib/mysql/mysql.sock
          pid_file = /var/lib/mysql/mysql.pid

          # MyISAM #
          key_buffer_size = 32M
          myisam_recover = FORCE,BACKUP

          # SAFETY #
          max_allowed_packet = 16M
          max_connect_errors = 1000000

          # DATA STORAGE #
          datadir = /var/lib/mysql/

          # BINARY LOGGING #
          log_bin = /var/lib/mysql/mysql-bin
          expire_logs_days = 14
          sync_binlog = 1

          # CACHES AND LIMITS #
          tmp_table_size = 32M
          max_heap_table_size = 32M
          query_cache_type = 0
          query_cache_size = 0
          max_connections = 500
          thread_cache_size = 50
          open_files_limit = 65535
          table_definition_cache = 1024
          table_open_cache = 2048

          # INNODB #
          innodb_flush_method = O_DIRECT
          innodb_log_files_in_group = 2
          innodb_log_file_size = 256M
          innodb_flush_log_at_trx_commit = 1
          innodb_file_per_table = 1
          innodb_buffer_pool_size = 2G

          # LOGGING #
          log_error = /var/lib/mysql/mysql-error.log
          log_queries_not_using_indexes = 1
          slow_query_log = 1
          slow_query_log_file = /var/lib/mysql/mysql-slow.log
          And when I start Percona server with /etc/init.d/mysql, I have this error :

          ERROR! MySQL (Percona Server) is not running, but lock file (/var/lock/subsys/mysql) exists

          I delete the lock file but the problem persist. So I have seen a basic config file in /usr/share/mysql and the first line of file indicate this :

          Quote:
          [client]
          #password = your_password
          port = 3306
          socket = /var/lib/mysql/mysql.sock

          # Here follows entries for some specific programs

          # The MySQL server
          [mysqld]
          port = 3306
          socket = /var/lib/mysql/mysql.sock
          It's [client] and [mysqld] and when you compare with percona tools, it's not the same entry.

          Could you help me ?

          Thank you in advance,

          G3r0m3G

          Comment

          • #6
            Hello,

            I have found the solution in topic of Percona forum (in attachment because the forum don't allow me to publish the link before to post 10 messages...)

            It's just to reset the ib_logfile before to start Percona and it's works

            Have a nice weekend.

            Comment

            Working...
            X