Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 11 of 11
  1. #1
    cPanel Partner NOC cPanel Partner NOC Badge anton_latvia's Avatar
    Join Date
    May 2004
    Posts
    277

    Unhappy Can not create MySQL database in CPANEL!

    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
    * http://www.aleksandrov.eu/ - just a simple personal homepage.

  2. #2
    cPanel Partner NOC cPanel Partner NOC Badge anton_latvia's Avatar
    Join Date
    May 2004
    Posts
    277

    Default

    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.
    Last edited by anton_latvia; 05-17-2006 at 05:31 AM.
    * http://www.aleksandrov.eu/ - just a simple personal homepage.

  3. #3
    cPanel Partner NOC cPanel Partner NOC Badge anton_latvia's Avatar
    Join Date
    May 2004
    Posts
    277

    Default

    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.
    * http://www.aleksandrov.eu/ - just a simple personal homepage.

  4. #4
    Member
    Join Date
    Apr 2005
    Location
    Belgium
    Posts
    55

    Default

    It worked.

    Thanks

  5. #5
    cPanel Partner NOC cPanel Partner NOC Badge anton_latvia's Avatar
    Join Date
    May 2004
    Posts
    277

    Default

    Remember to disable WHM auto-update, otherwise it will overwrite it and tomorrow you will have to run this fix again.
    * http://www.aleksandrov.eu/ - just a simple personal homepage.

  6. #6
    Registered User
    Join Date
    Feb 2007
    Posts
    2

    Default

    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!

  7. #7
    cPanel Partner NOC cPanel Partner NOC Badge anton_latvia's Avatar
    Join Date
    May 2004
    Posts
    277

    Default

    Try:
    Code:
    /scripts/perlinstaller --force Bundle::DBD::mysql
    /usr/local/cpanel/bin/checkperlmodules
    /scripts/upcp --force
    * http://www.aleksandrov.eu/ - just a simple personal homepage.

  8. #8
    Registered User
    Join Date
    Feb 2007
    Posts
    2

    Default

    Thank you! It's worked!

  9. #9
    Member
    Join Date
    Apr 2005
    Location
    Belgium
    Posts
    55

    Default

    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.

  10. #10
    Registered User
    Join Date
    Jul 2007
    Posts
    1

    Default

    Quote Originally Posted by anton_latvia View Post
    cd DBD-mysql-3.0003
    perl Makefile.PL --libs="-L/usr/lib64/ -lmysqlclient"
    make
    make install
    I had same problem, with small different:
    perl Makefile.PL --libs="-L/usr/lib/ -lmysqlclient"

    And it works now, thanks!!

  11. #11
    Member
    Join Date
    Apr 2007
    Posts
    26

    Default

    "/scripts/mysqlup --force" worked today. We'll see how it looks tomorrow.

Similar Threads & Tags
Similar threads

  1. I can't create mySQL database at cPanel.
    By monsterazor in forum Database Discussions
    Replies: 2
    Last Post: 08-29-2011, 04:08 PM
  2. Unable to create new MySQL Database in Cpanel or PHPmyAdmin
    By tim1 in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 01-10-2011, 11:18 PM
  3. create mysql database
    By dave2k in forum Database Discussions
    Replies: 2
    Last Post: 01-23-2005, 05:58 AM
  4. How to create MySQL database by using Cpanel?
    By Oleks in forum Database Discussions
    Replies: 6
    Last Post: 07-07-2004, 01:09 AM
  5. Will Pay >> Create a MySQL database remotely with cPanel info?
    By Admin_user in forum cPanel and WHM Discussions
    Replies: 4
    Last Post: 06-07-2004, 04:15 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube