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.

unable to create MySQL db's

Discussion in 'General Discussion' started by kaelin, Jul 9, 2004.

  1. kaelin

    kaelin Member

    Joined:
    Jun 6, 2003
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Texas USA
    I was setting up for a client at their home last night
    when I found this problem -- was using Fantastico
    auto installer and received this error after trying to install
    Install phpWebSite (3/3)

    /home/ba1979/public_html/conf/config.php configured
    /home/ba1979/public_html/data.sql configured


    ERROR 1049: Unknown database 'ba1979_wbst1'
    =================================
    It is not creating the database

    So I went back in through cpanel to set it up - it
    tells me it's created but it's not there.

    In looking at my nightly logs I am getting these errors:
    /usr/bin/mysqladmin: ERROR: unknown variable 'local-infile=1'
    /usr/bin/mysqladmin: ERROR: unknown variable 'local-infile=1'
    Grabbing mysql dbs.../usr/bin/mysqldump: ERROR: unknown variable 'local-infile=1'
    /usr/bin/mysqldump: ERROR: unknown variable 'local-infile=1'

    I have restarted MySQL - no avail

    We are running WHM 9.4.0 cPanel 9.4.0-R21

    This problem is recent as I just created new databases
    a few days ago - nothing else has changed.

    All existing databases are working.

    Looking forward to some help

    Thank You
    Lorri Nevil
    KaelinWeb
     
  2. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    find the my.cnf file, either in the /etc folder or the /var/lib/mysql folder and look for that line: 'local-infile=1' and comment it out or remove it.

    try creating the database from the command line.

    Mickalo
     
  3. Maistre

    Maistre Member

    Joined:
    Feb 22, 2003
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Las Vegas
    I have the same issue...

    MySQL Account Manager does not show created databases.

    Creating databases is from command line is NOT an option on a server with hundreds of users that want to create databases for their applications.

    This function used to work flawlessly.
     
Loading...

Share This Page