New mysql users cannot access databases after upgrade to 5.1


Mar 20, 2011

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/ 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/ at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/ line 70.
at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBD/ 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/ line 39
at /usr/local/cpanel/Cpanel/ 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 version (v1.9600) available.
[Currently running version is v1.9402]
You might want to try
install CPAN
reload cpan
to both upgrade and run the new version without leaving
the current session.

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

Going to read '/home/.cpan/sources/modules/'
Out of memory!

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

I would appreciate any assistance.