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.

Cpanel does not show mysql databases

Discussion in 'Database Discussions' started by rajinnasik, Mar 30, 2012.

  1. rajinnasik

    rajinnasik Member

    Joined:
    Nov 14, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Hello

    While creating the database via cpanel I get the following errors:

    -------------------------------------------------------
    root@server [~]# tail -fvn0 /usr/local/cpanel/logs/error_log
    ==> /usr/local/cpanel/logs/error_log <==
    info [cpmysqladmin] Creating MySQL database user1_db1 for user user1
    DBD::mysql::db do failed: Field 'ssl_cipher' doesn't have a default value at /usr/local/cpanel/Cpanel/Mysql.pm line 1139.
    DBD::mysql::db do failed: Field 'ssl_cipher' doesn't have a default value at /usr/local/cpanel/Cpanel/Mysql.pm line 1139.
    warn [cpanel] Cpanel::AdminBin::adminrun(cpmysql) set error in context mysql
    warn [mysql::initcache] Encountered error in mysql::initcache: The mysql server is offline.
    -------------------------------------------------------

    The database are created but can not display in cpanel. I have done the followings but still not fixed.

    # /scripts/checkperlmodules --full --force
    # /scripts/upcp --force
    # /scripts/update_db_cache
    # /scripts/checkperlmodules --full --force
    # /scripts/perlinstaller --force DBD::mysql
    # /scripts/mysqlup --force
    # /scripts/upcp --force
    # /usr/local/cpanel/bin/setupdbmap

    Any advice? Please help.
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello,

    Do you have the following set in /etc/my.cnf file?

    Code:
    grep sql-mode /etc/my.cnf
    If you have it set to "sql-mode=TRADITIONAL" in /etc/my.cnf then this will force MySQL to error when values are not specifically inserted for every column.

    If this is set into your /etc/my.cnf file, please comment it out and restart MySQL, then see if you are able to properly add MySQL database users.

    Thanks!
     
  3. rajinnasik

    rajinnasik Member

    Joined:
    Nov 14, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Thanks for reply.
    Yes, there was problem with /etc/my.cnf which was fixed.
    :)
     
Loading...

Share This Page