The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Percona 5.5 cpmysqladmin had an unknown error

Discussion in 'Database Discussions' started by rodz37, Dec 9, 2012.

  1. rodz37

    rodz37 Registered

    Joined:
    Nov 30, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    When creating a new user for a DB in WHM i have this error: cpmysqladmin had an unknown error.
    I suspect is could be something to do with my.cnf

    Any Idea's guys an girls?

    Rodz

    Code:
    [mysql]
    
    # CLIENT #
    port = 3306
    socket = /var/lib/mysql/mysql.sock
    
    [mysqld]
    innodb_file_per_table=1
    default_storage_engine = InnoDB
    socket = /var/lib/mysql/mysql.sock
    pid_file = /var/lib/mysql/mysql.pid
    local-infile=0
    
    # MyISAM #
    key_buffer_size = 32M
    myisam_recover = FORCE,BACKUP
    
    # SAFETY #
    max_allowed_packet = 16M
    max_connect_errors = 1000000
    skip_name_resolve
    sql_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_BY
    sysdate_is_now = 1
    innodb = FORCE
    innodb_strict_mode = 1
    
    # CACHES AND LIMITS #
    tmp_table_size = 64M
    max_heap_table_size = 64M
    query_cache_type = 1
    query_cache_size = 192M
    max_connections = 1000
    thread_cache_size = 70
    open_files_limit = 65535
    table_definition_cache = 8192
    table_open_cache = 2048
    
    # INNODB #
    innodb_flush_method = O_DIRECT
    innodb_log_files_in_group = 2
    innodb_flush_log_at_trx_commit = 1
    innodb_buffer_pool_size = 6G
    innodb_thread_concurrency=8
    
    # 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
     
Loading...

Share This Page