cpanel show wrong MySQL version

[shopcentar]

Hello,

please can somebody have fix for "cpanel show wrong MySQL version".

We have 4.1.21 and that can I check via SSH or WHM but cpanel say:

MySQL version 4.0.27-standard-log

How to fix that?

And here is more details:
account is trasfered from older version MySQL, I wont to say others account via cpanel shown correct MySQL version so only one account that we restored from older server shown 4.0.27 standard.

So, please cpanel stuff, can you make some tests and check that, please.

And second the same problem are with PHP, we found fix for that:
#fix php version
pico /usr/local/apache/conf/php.version

BUT question is for cpanel stuff, whay you dont fix that???
This error is to old.

bye, SC

[celliott]

I agree this is an error which has been around for a long time. I have noticed this affects both PHP Version and MySQL version. On a few of my accounts I have MySQl 4.1.19 displayed in cPanel when 4.1.21 is actually installed on the server.

[gal3ler]

/home/username/.cpanel-datastore/_usr_sbin_mysqld_--version


That is the file you will want to change

You can use:

replace "/usr/sbin/mysqld Ver 4.0.27-standard for pc-linux-gnu on i686 (Official MySQL RPM)" "/usr/sbin/mysqld Ver 4.1.21-standard for pc-linux-gnu on i686 (MySQL Community Edition - Standard (GPL))" -- /home/*/.cpanel-datastore/_usr_sbin_mysqld_--version

to fix

[shopcentar]

great.

many thanks!

regards, SC

[rhohan]

If you have multiple users, you could use :

find ./*/.cpanel-datastore/ | grep _usr_sbin_mysqld_--version | awk '{system ("rm " $1)}'

[maysoft]

There's even easier way to fix wrong mysql version in cpanel:

rm -f /home/*/.cpanel-datastore/_usr_sbin_mysqld_--version

File will be recreated with actual data when user logs into cpanel.

Enjoy!

[rogcan]

Ive tried all of the above and it still shows the wrong version in phpmyadmin

phpMyAdmin shows this >>> Server version: 5.0.27-standard MySQL client version: 4.1.10
Cpanel shows this >>> MySQL version 5.0.27-standard
SSH shows this >>> MySQL version 5.0.27-standard

Anyone else have any ideas to fix what it should say for client version ??

[cPanelBrandonM]

If you completely remove the datastore directory it will be recreated upon next login. This is a real quick fix for this problem:

rm -rf /home/*/.cpanel/

refresh your cpanel.

[rogcan]

That doesnt work either

I even had cPanel look at this problem and they couldnt resolve it.
When they did fix it it came right back as soon as the next cpanel update was auto installed.

[rachweb]

do /scripts/makecpphp. Phpmyadmin use the internal php version of cpanel

[Spiral]

Client version shown in phpMyAdmin is something totally different and has to
do with your MySQL linking library version and not your MySQL version.

You can just symlink to the newer library in /usr/lib to display the newer version

[Interdit]

Hello,

What would be the exact command ? what's the name of the library to link ?

ln -s ...

I have the same problem after installing Mysql 5.0.45 but phpinfo and phpmyadmin are still showing the old version.
The version 5.0.45 is correctly shown in WHM.

Thanks,
Francois

EDIT: fixed by:

# cd /usr/lib
# cp libmysqlclient.* /usr/lib/mysql/
# cd /usr/lib/mysql/

then recompiling Php 5.2.3

[velda]

That doesnt work either

I even had cPanel look at this problem and they couldnt resolve it.
When they did fix it it came right back as soon as the next cpanel update was auto installed.

Did you get this resolved? I've tried the tips here and am getting the same thing.

[erik@delphi]

it is ....

/home/username/.cpanel/datastore 
rm -rf _usr_sbin_mysqld_--version

refresh your Cpanel and ...... voila

[velda]

it is ....

/home/username/.cpanel/datastore 
rm -rf _usr_sbin_mysqld_--version

refresh your Cpanel and ...... voila

weird. I tried it; no dice. I am thinking this has to do with a cpanel skin issue I'm having so I'll go back to that