Can not create MySQL database in CPANEL!

**anton_latvia** · 05-17-2006 05:03 AM

Hi,

I am running WHM 10.8.0 cPanel 10.8.2-R83, CentOS 4.3 x86_64 - WHM X v3.1.0. It's fresh installation. But it comes with serious problem. I can not create any database in CPANEL. And also I can not add new user. When I try to create it, CPANEL says - no problem, created user/database, but no database/user are being created!.

What kind of .. is it?

Anton

**anton_latvia** · 05-17-2006 05:08 AM

Update: There is the following error message in log.
/usr/bin/perl: symbol lookup error: /usr/lib/perl5/site_perl/5.8.7/x86_64-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init

How can I fix it without downgrading? And why it is there on the fresh installation?!

Also when I try to reinstall DBD::mysql I get these errors:

install_driver(mysql) failed: Can't load '/home/.cpan/build/DBD-mysql-3.0003/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /home/.cpan/build/DBD-mysql-3.0003/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/lib/perl5/5.8.7/x86_64-linux/DynaLoader.pm line 230.

**anton_latvia** · 05-18-2006 12:53 AM

I got it fixed from CPANEL. This is problem with 64-bit servers. Here is a solution.

cd /usr/src
wget http://ftp.osuosl.org/pub/CPAN/autho...-3.0003.tar.gz
tar xzvf DBD-mysql-3.0003.tar.gz
cd DBD-mysql-3.0003
perl Makefile.PL --libs="-L/usr/lib64/ -lmysqlclient"
make
make install

Also check /etc/ld.so.conf and make sure /usr/lib64 is one of the included paths.

**Berbox** · 06-09-2006 06:24 AM

It worked.

Thanks

**anton_latvia** · 06-09-2006 06:33 AM

Remember to disable WHM auto-update, otherwise it will overwrite it and tomorrow you will have to run this fix again.

**ydz.ru** · 02-05-2007 10:53 AM

Hello.
I am running WHM 10.8.0 cPanel 10.9.0-R118
Fedora i686 - WHM X v3.1.0
I can too not create any database in CPANEL from any user. And CPANEL says - no problem, created user/database, but no database/user are being created! (copyright by anton_latvia)
But i have not 64-bit server, and this fix not worked

Help me!

**anton_latvia** · 02-05-2007 01:16 PM

Try:

Code:

/scripts/perlinstaller --force Bundle::DBD::mysql
/usr/local/cpanel/bin/checkperlmodules
/scripts/upcp --force

**ydz.ru** · 02-05-2007 11:56 PM

Thank you! It's worked!

**Berbox** · 02-06-2007 02:16 AM

The problem still comes back even with cPanel Update disabled.
A shorter way is running following command

/scripts/mysqlup --force

This solves the problem by me.