PHPMYADMIN doesn't see MYSQL 8 upgrade
Posted by: gamattox (47.205.99.---)
Date: January 03, 2019 04:32PM

Windows 10
Wamp 3.1.6
PHP 7.3.0
Apache 2.4.37
phpMyAdmin 4.8.4
MySQL 8.0.13


I just upgraded MySQL. THE WEBSITE CONTINUES TO WORK FINE. However, phpMyAdmin is still attached to the older MySQL 5.7.23 and doesn't recognize MySQL 8. I need to perform the import of my site to complete the MySQL upgrade. Also, Apache continues to display the site correctly but I know it is from the older database since I have yet to complete the MySQL import into version 8. The MySQL version checkmark in WAMP is set to 8.0.13 and I have restarted services many times but phpMyAdmin and Apache both only recognize the older MySQL 5.7.23.

What steps am I missing to complete the MySQL upgrade to version 8.0.13?

Thanks for the advice.

Options: ReplyQuote
Re: PHPMYADMIN doesn't see MYSQL 8 upgrade
Posted by: Otomatic (Moderator)
Date: January 03, 2019 06:18PM

Hi,

There is no problem with PhpMayAdmin and MySQL 8.0.13 :


------------------------------------------------------------------------------------------------------------
Wampserver 3.1.9 32 bit - Apache 2.4.39 - PHP 7.3.6/7.2.19/7.1.30/7.0.33/5.6.40 - MySQL 5.7.26 - MariaDB 10.3.15
Wampserver 3.1.9 64 bit - Apache 2.4.39 - PHP 7.3.6/7.2.19/7.1.30/7.0.33/5.6.40 - MySQL 5.7.26/8.0.16 - MariaDB 10.3.15
PhPMyadmin 4.9.0.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: PHPMYADMIN doesn't see MYSQL 8 upgrade
Posted by: WarriorGov9791 (---.hawaii.res.rr.com)
Date: January 04, 2019 01:18PM

Quote
gamattox Wrote:
I just upgraded MySQL. THE WEBSITE CONTINUES TO WORK FINE. However, phpMyAdmin is still attached to the older MySQL 5.7.23 and doesn't recognize MySQL 8.

After installing the upgrade, did you remember to switch to the new version?
    Backup your database in 5.7.23.
    Left click the Wampserver icon in the system tray.
    Highlight MySQL --> Version --> check 8.0.13
    Proceed to import your database in 8.0.13.
Hope this helps.

Options: ReplyQuote
Re: PHPMYADMIN doesn't see MYSQL 8 upgrade
Posted by: gamattox (47.205.99.---)
Date: January 04, 2019 01:59PM

As stated in the initial problem statement, the MySql version checkmark is set to 8.0.13.

phpMyAdmin however, continues to access the previous MySQL version, 5.7.23. I am therefore unable to complete the MySQL upgrade and continue to display a fully functional website but from the older database. I cannot access the new MySQL version from phpMyAdmin.

Options: ReplyQuote
Re: PHPMYADMIN doesn't see MYSQL 8 upgrade
Posted by: Otomatic (Moderator)
Date: January 04, 2019 03:17PM

Hi,

In the MySQL Console, what is the version number seen ?
- Left-Click -> MySQL -> MySQL Console Keep root as user
At the password prompt type the password you have for root - If no password just it enter.
In the MySQL console, you can see Server version 8.0.13
Enter password: **************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.13 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.9 32 bit - Apache 2.4.39 - PHP 7.3.6/7.2.19/7.1.30/7.0.33/5.6.40 - MySQL 5.7.26 - MariaDB 10.3.15
Wampserver 3.1.9 64 bit - Apache 2.4.39 - PHP 7.3.6/7.2.19/7.1.30/7.0.33/5.6.40 - MySQL 5.7.26/8.0.16 - MariaDB 10.3.15
PhPMyadmin 4.9.0.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.