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!

Cpanel does not show mysql databases

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

  1. rajinnasik

    rajinnasik Member

    Joined:
    Nov 14, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    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,609
    Likes Received:
    32
    Trophy Points:
    238
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. rajinnasik

    rajinnasik Member

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

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