Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Percona 5.5 cpmysqladmin had an unknown error

Discussion in 'Database Discussion' 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
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice