Can't switch from MySQL 5.7 to 5.6?
Posted by: JohnyBeGood (---.marinko.us)
Date: October 24, 2017 05:11PM

Hi,

I need MySQL 5.6 and I've installed addon without problem. When I switch and go in PHPmyadmin it still shows 5.7. When I rename 5.7 I get an error from PHPMyadim that its can't connect. It completely ignores 5.6
No error in MySQL log?

Here are the screenshots [imgur.com]

TIA

Options: ReplyQuote
Re: Can't switch from MySQL 5.7 to 5.6?
Posted by: bjmag94 (58.178.200.---)
Date: October 24, 2017 05:15PM

Restart all services, if that doesn't work then exit the application and then open it back up

Options: ReplyQuote
Re: Can't switch from MySQL 5.7 to 5.6?
Posted by: Otomatic (Moderator)
Date: October 24, 2017 05:21PM

Hi,

And clear browser cache (Ctrl-F5)

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - 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: Can't switch from MySQL 5.7 to 5.6?
Posted by: JohnyBeGood (---.marinko.us)
Date: October 24, 2017 06:41PM

Thanks for the replies!

I did restart all services, F5, cleared cookies, exited entire WAMP and rebooted Windows still same issue.
What I did found is that [localhost] shows correct chosen version but not in PHPmyadmin?
Here's the video [screencast-o-matic.com]

Options: ReplyQuote
Re: Can't switch from MySQL 5.7 to 5.6?
Posted by: Otomatic (Moderator)
Date: October 24, 2017 08:11PM

Hi,

I do not understand. I do not know where the problem may be.

Install PhpMyAdmin 4.7.5 whose installer you will find here: [wampserver.aviatechno.net]

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - 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: Can't switch from MySQL 5.7 to 5.6?
Posted by: Otomatic (Moderator)
Date: October 24, 2017 08:31PM

Hi,

What is the result of:

Right-Click Wampmanager tray icon -> Tools -> Check Compiler VC, compatibility...

And no video or image to give the result, I want text.
You have the option to type y then Enter to get the whole result in the clipboard. Just paste here by Ctrl-V.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - 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: Can't switch from MySQL 5.7 to 5.6?
Posted by: JohnyBeGood (---.marinko.us)
Date: October 24, 2017 08:43PM

I'm lost as weel. Does it show correct version on your computer?

Its is odd that it shows "MySQL Ver 5.6.37 for Win64" ?Should be Win32?



Compiler Visual C++ versions used:

PHP 5.6.31 Compiler => MSVC11 (Visual C++ 2012)
Architecture => x86
is compatible with Apache 2.4.27

PHP 7.0.23 Compiler => MSVC14 (Visual C++ 2015)
Architecture => x86
is compatible with Apache 2.4.27

PHP 7.1.9 Compiler => MSVC14 (Visual C++ 2015)
Architecture => x86
is compatible with Apache 2.4.27



MySQL Ver 5.6.37 for Win64 on x86_64 (MySQL Community Server (GPL))
MySQL Ver 5.7.19 for Win32 on AMD64 (MySQL Community Server (GPL))


MariaDB Ver 10.2.8-MariaDB for Win32 on AMD64 (mariadb.org binary distribution)


Apache 2.4.27 Apache Lounge VC15 Server built: Jul 7 2017 11:43:51
Architecture: 32-bit

WARNING - WARNING - WARNING
It is IMPERATIVE that all versions are the SAME TYPE
There are:
4 version(s) for x86 (32-bit)
1 version(s) for x64 (64-bit)
32 bit versions are
apache2.4.27
php5.6.31
php7.0.23
php7.1.9
64 bit versions are
mysql5.6.37

Options: ReplyQuote
Re: Can't switch from MySQL 5.7 to 5.6?
Posted by: Otomatic (Moderator)
Date: October 24, 2017 09:02PM

Hi,

> MySQL Ver 5.6.37 for Win64 on x86_64 (MySQL Community Server (GPL))

If you use Wampserver addons, you can not install a 64-bit version on a 32-bit Wampserver.
The localhost page gives the version numbers seen from the folders, for example wamp / bin / mysl / mysql5.6.37 / while the tool you used gives the version numbers of the executable httpd.exe, mysqld. exe or php.exe.

I am really sorry and I apologize.
I just checked, the mistake is my fault. I compiled the MySQL 5.6.37 32 bit installer with mysql 5.6.37 64 bit executables.
I will correct tomorrow. In the meantime, I delete the version 5.6.37 at fault.

For you, go back to version 5.7.19 then delete version 5.6.37 by:
Right Click -> Tools -> Delete Unused Versions

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - 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: Can't switch from MySQL 5.7 to 5.6?
Posted by: Otomatic (Moderator)
Date: October 24, 2017 09:27PM

Hi,

Correct MySQL 5.6.37 32 bit is here : [wampserver.aviatechno.net]

Sorry

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - 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: Can't switch from MySQL 5.7 to 5.6?
Posted by: JohnyBeGood (---.marinko.us)
Date: October 24, 2017 11:46PM

No worries! Installed provided version and now it shows correct version in PHPMyadmin!
Thanks for your help!

Options: ReplyQuote


Sorry, only registered users may post in this forum.