setup script needs fix for MySQL 8.0

[Marc Deslauriers]

[Impact]
Users can't setup wordpress on Ubuntu because of an incompatibility with MySQL 8.0.

[Test Case]
apt install mysql-server
apt install wordpress php-gd libapache2-mod-php
ln -s /usr/share/wordpress /var/www/html/wordpress
bash /usr/share/doc/wordpress/examples/setup-mysql -n wordpress localhost

The last command should run without error, and after restarting apache, wordpress should be available at http://localhost/wordpress

[Regression potential]
The script currently fails to run at all. The fixed script should allow setting up a working wordpress installation. If the script introduces a regression, it would not be worse off than it currently is.

[Original description]
In eoan+, running the wordpress setup script provided with the package fails:

# ln -s /usr/share/wordpress /var/www/html/wordpress
# bash /usr/share/doc/wordpress/examples/setup-mysql -n wordpress localhost
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.058 ms

--- localhost ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.058/0.058/0.058/0.000 ms
/etc/wordpress/config-localhost.php written
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'uMA8fZa7'' at line 4
Goto http://localhost to setup Wordpress

[Launchpad Janitor (janitor)]

This bug was fixed in the package wordpress - 5.3.2+dfsg1-1ubuntu1

---------------
wordpress (5.3.2+dfsg1-1ubuntu1) focal; urgency=medium

  * Fix compatibility with MySQL 8.0 (LP: #1852775)
    - debian/setup-mysql: create the user before granting privileges, and
      use mysql_native_password authentication.

 -- Marc Deslauriers <email address hidden> Mon, 27 Jan 2020 11:51:19 -0500

[Timo Aaltonen (tjaalton)]

Hello Marc, or anyone else affected,

Accepted wordpress into eoan-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/wordpress/5.2.2+dfsg1-1ubuntu0.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested and change the tag from verification-needed-eoan to verification-done-eoan. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-eoan. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

[Marc Deslauriers (mdeslaur)]

I have tested the package in proposed on eoan, and it works as expected.

[Łukasz Zemczak (sil2100)]

Please be sure to mention the version number of the package that has been tested next time!

[Launchpad Janitor (janitor)]

This bug was fixed in the package wordpress - 5.2.2+dfsg1-1ubuntu0.1

---------------
wordpress (5.2.2+dfsg1-1ubuntu0.1) eoan; urgency=medium

  * Fix compatibility with MySQL 8.0 (LP: #1852775)
    - debian/setup-mysql: create the user before granting privileges, and
      use mysql_native_password authentication.

 -- Marc Deslauriers <email address hidden> Mon, 27 Jan 2020 12:39:44 -0500

[Łukasz Zemczak (sil2100)]

The verification of the Stable Release Update for wordpress has completed successfully and the package is now being released to -updates. Subsequently, the Ubuntu Stable Release Updates Team is being unsubscribed and will not receive messages about this bug report. In the event that you encounter a regression using the package from -updates please report a new bug using ubuntu-bug and tag the bug report regression-update so we can easily find any regressions.