New mysql users cannot access databases after upgrade to 5.1

rulerofzu

Registered
Mar 20, 2011
4
1
53
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 [email protected]

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