zosokat — 2014-02-13T12:43:20-05:00 — #1
I just upgraded MySQL but when I log into phpMyAdmin, it still shows the old MySQL server. How can I associate phpMyAdmin with the latest version of MySQL just installed? Any recommendations will be greatly appreciated.
zosokat — 2014-02-14T10:21:34-05:00 — #2
No one else has run into this issue? I am using phpMyAdmin 4.0.10 and I just installed MySQL 5.6. PHPMyAdmin is showing Server version: 5.5.23 when I log in, which is the previous MySQL version.
Any help is appreciated.
spacephoenix — 2014-02-14T14:47:14-05:00 — #3
Have you rebooted the server?
zosokat — 2014-02-18T12:16:20-05:00 — #4
Thanks for your response. It is much appreciated. Unfortunately I have tried rebooting the server to no avail. Any other recommendations are appreciated.
kiwiheretic — 2014-02-18T12:34:03-05:00 — #5
How do you know the new version installed correctly? If it didn't and it was installed through a package manager then it may have even been rollws back automatically
cheesedude — 2014-02-18T13:48:25-05:00 — #6
Did you try updating phpMyAdmin? You can check your MySQL server version through the command line. Is it your phpMyAdmin client library that is showing a previous version? I am just learning Linux myself. From what I have read, sometimes you have update, reinstall, or recompile something against a newer version of something else. For example, if you install a new version of MySQL, you may need to update your PHP as well.
kiwiheretic — 2014-02-18T14:06:28-05:00 — #7
I wouldn't have thought you would need to do that if you're using a package manager like yum or apt-get. I recently upgraded mysql on centos using yum and it went and found and upgraded all dependencies for me. I should think it would be not much different for Ubuntu. For the far majority of cases you shouldn't need to compile from source these days and it should be avoided if at all possible.
kiwiheretic — 2014-02-18T14:14:18-05:00 — #8
If you type the following into the shell you should see what version you have installed.
$ mysql --version
See the dot seperated numbers after the "Distrib" string. This is your mysql version number.
zosokat — 2014-02-19T16:47:51-05:00 — #9
I installed using the Windows installer (ref: http://dev.mysql.com/downloads/installer/) and I have since discovered that even after a successful install, the only Windows service was the old one 5.5. As a result, i stopped that service and re-installed and it created a new Windows service for the new version. I made sure the service for the old version was stopped and the new service started but now I can't login to phpMyAdmin even with the root user. I am getting the "#2002 Cannot log in to the MySQL server" error. At least now I know the new version is running and I can log into the MySQL 5.6 Command Line Client using the root user password that won't work in phpMyAdmin. I have added the following code to the config.inc.php file but it still won't let me login to phpMyAdmin.
$cfg['Servers'][$i]['user'] = 'root'; //mysql username here
$cfg['Servers'][$i]['password'] = 'password'; //mysql password here
Also once I solve the login issue, how do I get rid of the old MySQL windows service?
cheesedude — 2014-02-19T18:02:33-05:00 — #10
I assumed you were using Linux. When I was installing a development server on a new computer last year I went with XAMPP because it was impossible to find recent versions of Windows binaries for Apache, PHP, and MySQL that would work together. XAMPP is so much easier and everything is relatively current.
Did you try uninstalling it in the Windows uninstall feature in Control Panel?
To uninstall a MySQL where you have used the MSI packages, you must use the Add/Remove Programs tool within Control Panel.
zosokat — 2014-02-21T14:50:26-05:00 — #11
I had to uninstall both versions of MySQL (5.1 and 5.6) and then re-install 5.6 using the Windows installer.
After uninstalling both versions of MySQL, then successfully re-installing 5.6, I was able to login to PHPMyAdmin. Next I created the phpmyadmin db and ran the script that came with phpmyadmin code to create the tables for phpmyadmin and I created a pma user. After doing all that, now I can't login to phpMyAdmin! I get two errors:
" #2002 Cannot log in to the MySQL server" AND "Connection for controluser as defined in your configuration failed."
If I comment out this code, the "Connection for controluser as defined in your configuration failed." error message goes away.
$cfg['Servers'][$i]['controlhost'] = '';
$cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'insert_password_here';
Should I uninstall phpMyAdmin and re-install? Really getting frustrated at this point. Thanks for all the replies - it has helped me get this far.
zosokat — 2014-02-21T15:57:56-05:00 — #12
Something keeps causing the MySQL Windows service to stop so I have to restart it manually.
spacephoenix — 2014-02-22T01:15:59-05:00 — #13
Is there any recurring entries in any error logs?
cheesedude — 2014-02-22T11:14:48-05:00 — #14
A quick Yahoo search shows a few complaints for MySQL 5.6 stopping on Windows 8. Original poster did not provide OS version.
zosokat — 2014-03-04T10:54:26-05:00 — #15
I guess I didn't post the OS because I am working with multiple environments, but they are Win 7 and Win Server 2008 R2. Interesting note about MySQL 5.6 and Win 8 issues.
champ — 2014-03-04T17:40:48-05:00 — #16
It happened to me recently. I believe phpMyAdmin caches some general settings/attributes within a cookie (or localStorage) which includes the MySQL version number. I resolved it by clearing my browser's cookies. If that doesn't work, clear your local storage.
zosokat — 2014-03-05T18:30:11-05:00 — #17
Thx for that information. It is much appreciated.