Question About MySQL Version Installed

miramarfun

Member
Aug 17, 2015
9
0
1
france
cPanel Access Level
Website Owner
Hello everyone on the Forum,

Here is my problem. Having installed and whm cpanel which originally had Mysql 5.0.10.
I wanted to change for version 5.6.
Everything is good but there lies a mistake I do not understand and I would like to rectify.

My WHM shows: MySQL 5.6
papMyAdmin displayed: MySQL 5.6

Out on the page of my Web site root (public_html / www) with a php info.
This brings me Mysql 5.0.10

How to fix this problem so that at www, Mysql is the same (5.6)

Pending answers

Best regards
Patrick

ps: sorry for my bad English because I am not master French and English
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,225
463
Hello :)

Please post the output from:

Code:
rpm -qa|grep MySQL
Thank you.
 

miramarfun

Member
Aug 17, 2015
9
0
1
france
cPanel Access Level
Website Owner
Good evening,

Here is the answer:


MySQL56-client-5.6.23-3.cp1148.x86_64
cpanel-perl-514-MySQL-Diff-0.43-4.cp1146.x86_64
MySQL56-server-5.6.23-3.cp1148.x86_64
compat-MySQL50-shared-5.0.96-4.cp1136.x86_64
MySQL56-shared-5.6.23-3.cp1148.x86_64
MySQL56-test-5.6.23-3.cp1148.x86_64
compat-MySQL51-shared-5.1.73-1.cp1150.x86_64
MySQL56-devel-5.6.23-3.cp1148.x86_64

[Removed URL]

Mysql 5.0.10
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,225
463
I suggest rebuilding Apache/PHP via EasyApache to address this issue:

"WHM >> Software >> EasyApache"

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,225
463
Try moving the custom php.ini file from the account's public_html out of the way to see if the issue persists when using /usr/local/lib/php.ini. It's possible the local php.ini file is outdated.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,225
463
I'm not sure I understand your previous response. The initial URL you posted with your PHPINFO page showed the php.ini utilized was stored in the account's public_html directory. I'm suggesting that you move it out of the way so that /usr/local/lib/php.ini is used instead.

Thank you.
 

miramarfun

Member
Aug 17, 2015
9
0
1
france
cPanel Access Level
Website Owner
Hello,

If I understood correctly:

I just move /usr/local/lib/php.ini (php.ini) and I placed it on my test url http: ftp domain.com/test.php in the public_html folder / www.

And always the same. Mysql 5.0.10 is not the 5.6

Best regards

And I thank you for being there to help me and give advice
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,225
463
No, I am stating that you should temporarily move /home/$username/public_html/php.ini out of the way and see if you still receive the same result.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,225
463
Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.
 

miramarfun

Member
Aug 17, 2015
9
0
1
france
cPanel Access Level
Website Owner
I just created a support ticket.

By cons I do not know what I should do on WHM, ras ip ssh key and complex ... It is for me.

There would not it another way and give you direct access identifier with my MP?

Also I do not really master English, which makes things even more difficult
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,225
463
Was the link to that document in the error message helpful?

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,225
463
Hello :)

To update, the issue was not reproducible on the user's system (the phpinfo file was not accessible). The user was advised to run EasyApache to see if the issue continued.

Thank you.
 

feldon27

Well-Known Member
Mar 12, 2003
122
14
168
Houston, TX
I thought phpinfo() always displayed a much older version of MySQL than is actually running.

Under the MySQL block under phpinfo, mine says:
Client API version 5.5.42

However under other sections, it says:
PDO Driver for MySQL
Client API version mysqlnd 5.0.10
mysqlnd
Version mysqlnd 5.0.10 - 20111026​

Never had a problem.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,225
463