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.

New mysql users cannot access databases after upgrade to 5.1

Discussion in 'Database Discussions' started by rulerofzu, Mar 20, 2011.

  1. rulerofzu

    rulerofzu Registered

    Joined:
    Mar 20, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Hello

    Ive tried several posts here and have re-ran easy apache as recommended.

    All new mysql users that I create cannot access the tables they are allocated too.

    1044 access denied for the user@localhost

    The error log shows the following


    [2011-03-20 12:18:14 +0000] warn [mysqladmin] Error while connecting to MySQL. Failover enacted. at /usr/local/cpanel/Cpanel/Mysql.pm line 44
    Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/bin/mysqladmin line 65
    [2011-03-20 12:18:14 +0000] warn [mysqladmin] install_driver(mysql) failed: Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql$
    x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so) at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/XSLoader.pm line 70.
    at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBD/mysql.pm line 14
    Compilation failed in require at (eval 13) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at /usr/local/cpanel/Cpanel/Mysql.pm line 39
    at /usr/local/cpanel/Cpanel/Mysql.pm line 45

    Any ideas?

    I upgraded mysql then ran easy apache to the latest stable. php 5.3.5

    Also I checked the perl modules and installed is DBD::mysql 4.018. If I click on upgrade or reinstall I get..

    New CPAN.pm version (v1.9600) available.
    [Currently running version is v1.9402]
    You might want to try
    install CPAN
    reload cpan
    to both upgrade CPAN.pm and run the new version without leaving
    the current session.

    CPAN: Time::HiRes loaded ok (v1.9721)

    .............................................................DONE
    Going to read '/home/.cpan/sources/modules/03modlist.data.gz'
    Out of memory!

    Which I find hard to believe as this is a server with 24GB of DDR3 ram.

    I would appreciate any assistance.

    Thanks
     
  2. rulerofzu

    rulerofzu Registered

    Joined:
    Mar 20, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Resolved.

    For those that stumble across this. Had to reinstall DBD::mysql through SSH.
     
Loading...

Share This Page