unable to create MySQL db's

[kaelin]

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

 

[mickalo]

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

 

[Maistre]

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.