As i understand the latest WHM notice below means there are 2 issues to deal with for NPTL based systems ?

Important Notice: Incompatible versions of Mysql 4.0.x and NPTL based systems.
If you are running a newer linux system which is NPTL based (CentOS 4, Fedora 3+, RHE 4, etc) and are having problems with MySQL 4.0.x (versions later then 4.0.23*), we recommend upgrading to MySQL 4.1.x as we have determined that there are compatibility issues on these platforms. You can easily upgrade to 4.1.x by changing the Mysql Version in Tweak Settings
If you are worried about compatibility with MySQL 4.0, be sure to check the box labeled: Use old style (4.0) passwords with mySQL 4.1. in Tweak Settings.
If you are unsure if your system is NPTL based, run getconf GNU_LIBPTHREAD_VERSION at the command line and see if it displays NPTL.
* 4.0.23 does not have any known issues, but is subject to security vulnerabilities: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-1516, http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-1517

Click to expand...

-----------------------------------------------------------Issue 1.​

For security issues fix is to update to MySQL 4.0.27 or 4.1.19 or 5.0.21 according to the mysql.com changelogs

Security fix: A malicious client, using specially crafted invalid login or COM_TABLE_DUMP packets was able to read uninitialized memory, which potentially, though unlikely in MySQL, could have led to an information disclosure. (CVE-2006-1516, CVE-2006-1517) Thanks to Stefano Di Paola <stefano.dipaola@wisec.it> for finding and reporting this bug.

Click to expand...

-----------------------------------------------------------Issue 2. ​

Compatibility issues with NPTL based systems with MySQL 4.0.24 and higher 4.0.xx versions. But only some folks are affected and some have no problems ? As you stated in what i highlighted in bold

If you are running a newer linux system which is NPTL based (CentOS 4, Fedora 3+, RHE 4, etc) and are having problems with MySQL 4.0.x (versions later then 4.0.23*)

Click to expand...

Can you elaborate on the 2nd issue ? there's been hundreds of CentOS 4 based servers running for ages with 4.0.25 at least with WHM users and most don't seem to have issues that I am aware of ???

I need help. I follow as per instruction in WHM to upgrade my MYSQL from 4.0.x to 4.1.18-standard. After the upgrade seem all my script not working correctly. Some never load, some not fully load and some loaded to login page but not login after enter correct password and user name.

I able to access via ssh and whm. No use even after I force update mysql. Server status all fine (green)

I need help. I follow as per instruction in WHM to upgrade my MYSQL from 4.0.x to 4.1.18-standard. After the upgrade seem all my script not working correctly. Some never load, some not fully load and some loaded to login page but not login after enter correct password and user name.

I able to access via ssh and whm. No use even after I force update mysql. Server status all fine (green)

After upgrading, update the grant tables to obtain the new longer Password column that is needed for more secure handling of passwords. The procedure uses mysql_fix_privilege_tables and is described in Section 5.5.1, “mysql_fix_privilege_tables — Upgrade MySQL System Tables”. If you do not do this, MySQL does not use the new more secure protocol to authenticate. Implications of the password-handling change for applications are given later in this section.

4.0.26 worked great for me until I tried to install software that required at least 4.1.13

I installed 4.1.19 and went through every process outlined here and at the MySQL site... restored my backup DB's, rebuilt Apache/PHP, ran the code to get longer password fields (successfully), I even rebooted the server...

Every login on my server is dead (500 HTTP). From phpBB to CubeCart to my own homegrown login scripts. The stores show products, stats from the DB show on my pages, everything else is fine...

I've toggled 4.0 and 4.1 passwords back and forth with no joy.

Any additional input?

Should I try 5.0 or will that just worsen matters? how would I go about reverting to 4.0.26?

okay, I've been having a few problems with(I believe) software on my server
I think it's a problem with php/msql because when I go into the root WHM I get an error about mysql but when I do what it says to fix it it stays the same. I also have been having trouble installing some php scripts, and I'm not entirely sure, but I think they've all been ones that used mysql and a few other scripts I had installed and working fine have just stopped working. My server is running CentOS 4.3

when I login to my WHM cpanel, I get the following message;

"Important Notice: Incompatible versions of Mysql 4.0.x and NPTL based systems.
If you are running a newer linux system which is NPTL based (CentOS 4, Fedora 3+, RHE 4, etc) and are having problems with MySQL 4.0.x (versions later then 4.0.23*), we recommend upgrading to MySQL 4.1.x as we have determined that there are compatibility issues on these platforms. You can easily upgrade to 4.1.x by changing the Mysql Version in Tweak Settings
If you are worried about compatibility with MySQL 4.0, be sure to check the box labeled: Use old style (4.0) passwords with mySQL 4.1. in Tweak Settings.
If you are unsure if your system is NPTL based, run getconf GNU_LIBPTHREAD_VERSION at the command line and see if it displays NPTL.
* 4.0.23 does not have any known issues, but is subject to security vulnerabilities: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-1516, http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-1517 "

I've done what it suggested two or three times, and it seems to show no change. I did the getconf and confirmed that the system is NPTL.

when I get to the install script on a php program, whether or not I've entered details manually into the config file, it'll usually show the first page that you're supposed to see but when I click next, in firefox it tries to save the install.php file but can't open it, in IE it says the connection was lost. I get the same result on my Windows XP desktop and laptop and on my Kubuntu Linux machine.

I tried to upgrade mysql to version 5, by searching the CentOS forums for info on it, but it didn't work, I think I didn't have the right addresses or something, and it just... didn't work(never installed it or anything) and I'm not sure why.

I restarted mysql and apache and I tried to reboot the server, first a graceful restart which failed, then a forceful reboot, which also failed.

Another small problem I've been having is with ftp accounts created through other accounts. Like, the main ftp account for a domain or whatever works fine, but when I try to create another one in the cpanel, I get a 530 Login incorrect error when I try to use it. I've tried this with several created ftp accounts, so it can't just be a typo. I don't know if this could possibly be related, so I included it as well.

I've contacted the company I rent my server from, and they indicated that updating and restarting all those things *should* have fixed the message at least, but it didn't, so short of reformatting and starting over, they suggested that I look at the cpanel forum.

PartnerNOC

"Important Notice: Incompatible versions of Mysql 4.0.x and NPTL based systems.
If you are running a newer linux system which is NPTL based (CentOS 4, Fedora 3+, RHE 4,

Click to expand...

Did you follow the instructions given on how to upgrade MySQL at WHM >> Server Configuration >> Tweak Settings >> MySQL
1) Seclect either v4.x or v5.x
2) check "Use old style (4.0) passwords with mySQL 4"