MySQL 8.0.12 64bit
Posted by: Otomatic (Moderator)
Date: July 30, 2018 07:12PM

Hi,

In the addons message of the latest versions of MySQL: 5.7.23, 5.6.41 and 5.5.61, I wrote:
Quote
Otomatic
There will be no MySQL 8.0.12 64 bit addon.
I discovered and reported a bug on version 8.0.4 RC :
https://bugs.mysql.com/bug.php?id=90383
No options taken into account from the [wampmysqld64] section of the my.ini file.
When the official version 8.0.11 was released, then the version 8.0.12, I naively thought that the bug had been fixed, but it is not and MySQL 8.0.12, used as a service, is unusable under Windows.
An 8.0.xx addon will only be released when this bug is fixed.
The bug has not been fixed and is still present.
However, by "tweaking" I was able to create a MySQL 8.0.12 addon that works on both Windows 10 64bit and Windows 7 64bit and with Wampserver 3.1.3 64bit.
This is a "tweak" and I am not sure that all MySQL 8.0.12 features as well as the MySQL settings by Wampserver are fully functional.
If you wish, I can put this addon only on the secondary repository, with the necessary warnings

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.3 32 bit - Apache 2.4.34 - PHP 7.2.8/7.1.20/7.0.31/5.6.37 - MySQL 5.7.23 - MariaDB 10.3.8
Wampserver 3.1.3 64 bit - Apache 2.4.34 - PHP 7.2.8/7.1.20/7.0.31/5.6.37 - MySQL 5.7.23 - MariaDB 10.3.8
PhPMyadmin 4.8.2 - 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: MySQL 8.0.12 64bit
Posted by: WarriorGov9791 (---.hawaii.res.rr.com)
Date: August 01, 2018 01:51AM

Thank you for the update! I would've liked to try out MySQL 8.xx, but the current issue with the bug you reported would only create problems for me and many other devoted WAMPServer users. I would prefer to keep it off the repository until it is fixed. A stable and fully functioning version of MySQL would be much better. I am very happy at the moment with the performance of MariaDB and keep MySQL 5.7.x only as a backup.

Thanks for all you do. Keep us posted. Aloha!

Windows 7 Ultimate 64-bit • WAMPServer 3.1.3 64-bit
Apache 2.4.34 • PHP 5.6.37 (CLI) | 7.0.31 | 7.1.20 | 7.2.8 (active) • xDebug 2.6.1
phpMyAdmin 4.8.2 • MariaDB (Default DBMS) 10.3.8 • MySQL 5.7.23
AdMiner 4.6.3 • PHPSysInfo 3.2.10 • OpenSSL 1.1.0h
All of the latest VC++ packages installed correctly

Options: ReplyQuote
Re: MySQL 8.0.12 64bit
Posted by: Otomatic (Moderator)
Date: August 01, 2018 03:05PM

Hi,

In my humble opinion, there is no risk in trying the MySQL 8.0.12 addon.
The bug is that the group options of the service name ([wampmysqld64]) of the my.ini file are not taken into account.
To overcome this problem, when installing addon 8.0.12, the my.ini file is modified:
[mysqld]
is replaced by
;[mysqld]
and
[wampmysqld64]
is replaced by
[wampmysqld64]
[mysqld]

Of course, for Wampmanager this poses a problem for the MySQL options, because the PHP function parse_ini_file() gives an empty result for the [wampmysqld64] group of the my.ini file.

To overcome this problem, the wamp64\scripts\refreshMySQL.php file is also modified when installing the MySQL 8.0.12 addon.
$mysqliniS = parse_ini_file($c_mysqlConfFile, true);
$mysqlini = $mysqliniS[$c_mysqlService];
is replaced by
$mysqliniS = parse_ini_file($c_mysqlConfFile, true);
//To correct MySQL 8.0 bug
$mysqlini = (count($mysqliniS[$c_mysqlService]) > 0) ? $mysqliniS[$c_mysqlService] : $mysqliniS['mysqld'];
which still works for MySQL 5.7.x versions

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.3 32 bit - Apache 2.4.34 - PHP 7.2.8/7.1.20/7.0.31/5.6.37 - MySQL 5.7.23 - MariaDB 10.3.8
Wampserver 3.1.3 64 bit - Apache 2.4.34 - PHP 7.2.8/7.1.20/7.0.31/5.6.37 - MySQL 5.7.23 - MariaDB 10.3.8
PhPMyadmin 4.8.2 - 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.