Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Mysql Upgrade from 5.0 to 5.1 (PMA thinks it is 5.0) SOLVED
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
hanj
Veteran
Veteran


Joined: 19 Aug 2003
Posts: 1418

PostPosted: Wed Sep 01, 2010 4:27 pm    Post subject: Mysql Upgrade from 5.0 to 5.1 (PMA thinks it is 5.0) SOLVED Reply with quote

Hello All

I upgraded mysql from 5.0 to 5.1 this morning. Overall, the upgrade went smooth. Some DB name issues, some DB perm issues, but all services are now up, etc. I logged into phpmyadmin (3.3.5.1) but I noticed the following error:

Code:
Your PHP MySQL library version 5.1.50 differs from your MySQL server version 5.0.90. This may cause unpredictable behavior.


Someone else had something similar in the past:
https://forums.gentoo.org/viewtopic-t-614618-highlight-differs+mysql.html

That particular issue was related to PMA control pass. I created a new PMA control pass and updated permissions table. No dice. I also re-emerged phpmyadmin, just in case, still no dice. The box is definitely running the newer version of mysql:

Code:
# mysql -V
mysql  Ver 14.14 Distrib 5.1.50, for pc-linux-gnu (i686) using readline 5.1


I noticed there were issues with DB names and '-' hypens. I did have a hypen in the root password, so I updated that as well. I also made sure I ran mysql-update as well.

Any ideas??

Thanks!
hanji
_________________
Server Admin Blog - Uno-Code.com


Last edited by hanj on Wed Sep 01, 2010 5:09 pm; edited 1 time in total
Back to top
View user's profile Send private message
hanj
Veteran
Veteran


Joined: 19 Aug 2003
Posts: 1418

PostPosted: Wed Sep 01, 2010 5:08 pm    Post subject: Reply with quote

I was able to track it down to the PMA_cacheExists in libraries/database_interface.lib.php. I checked /tmp and removed all sess_* files in there.. and sure enough, it picked up the new server value.

Thanks!
hanji
_________________
Server Admin Blog - Uno-Code.com
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum