setup script needs fix for MySQL 8.0
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
wordpress (Ubuntu) |
Fix Released
|
Undecided
|
Unassigned | ||
Eoan |
Fix Released
|
Undecided
|
Unassigned | ||
Focal |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
[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/
bash /usr/share/
The last command should run without error, and after restarting apache, wordpress should be available at http://
[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/
# bash /usr/share/
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.
/etc/wordpress/
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://
Changed in wordpress (Ubuntu Eoan): | |
status: | New → Confirmed |
Changed in wordpress (Ubuntu Focal): | |
status: | New → Confirmed |
description: | updated |
Changed in wordpress (Ubuntu Focal): | |
status: | Confirmed → Fix Committed |
Changed in wordpress (Ubuntu Eoan): | |
status: | Confirmed → In Progress |
This bug was fixed in the package wordpress - 5.3.2+dfsg1- 1ubuntu1
--------------- dfsg1-1ubuntu1) focal; urgency=medium
wordpress (5.3.2+
* Fix compatibility with MySQL 8.0 (LP: #1852775) password authentication.
- debian/setup-mysql: create the user before granting privileges, and
use mysql_native_
-- Marc Deslauriers <email address hidden> Mon, 27 Jan 2020 11:51:19 -0500