cpanel show wrong MySQL version

shopcentar

Well-Known Member
PartnerNOC
Jul 10, 2004
55
1
158
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
 
Last edited:

celliott

Well-Known Member
Jan 2, 2006
459
0
166
United Kingdom
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

Active Member
Dec 7, 2003
31
0
156
/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
 

rhohan

Registered
Feb 21, 2006
4
0
151
If you have multiple users, you could use :

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

maysoft

Well-Known Member
Nov 10, 2005
64
0
156
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! :D
 

rogcan

Well-Known Member
Jun 7, 2004
48
0
156
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 ??
 
Jun 24, 2007
9
0
51
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

Well-Known Member
Jun 7, 2004
48
0
156
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.
 

Spiral

BANNED
Jun 24, 2005
2,018
8
193
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

Well-Known Member
May 27, 2003
70
0
156
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
 
Last edited:

velda

Well-Known Member
Aug 24, 2005
54
0
156
Utah
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.
 

handsonhosting

Well-Known Member
Feb 17, 2002
151
0
316
Omaha, NE
cPanel Access Level
Root Administrator
Older thread I know, but it's something that we actually just ran into ago and were able to resolve.

cPanel changed the location of the DATASTORE folder in version 11.

The new location is in /home/username/.cpanel/datastore

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

Will remove the version numbers and reset the next time the cpanel is loaded for the client.