@Corey: the Eoan upload has a different but still cross arch SQL error:
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 'changeme'' at line 1
This test does:
9 mysql -u root << EOF
10 CREATE DATABASE cinder;
11 GRANT ALL PRIVILEGES ON cinder.* TO 'cinder'@'localhost' \
12 IDENTIFIED BY 'changeme';
13 GRANT ALL PRIVILEGES ON cinder.* TO 'cinder'@'%' \
14 IDENTIFIED BY 'changeme';
15 EOF
That is a common mysql8 issue, read e.g. [1].
Users are no more "implicitly" created by Grant+identified.
Instead you'd need it to be like:
CREATE USER 'cinder'@'%' IDENTIFIED BY 'changeme';
GRANT ALL PRIVILEGES ON cinder.* TO 'cinder'@'%';
CREATE USER 'cinder'@'localhost' IDENTIFIED BY 'changeme';
GRANT ALL PRIVILEGES ON cinder.* TO 'cinder'@'localhost';
Here is a debdiff with a suggestion, and given that it is a
mysql8-special you won't need it in Disco.
[1]: https://lefred.be/content/how-to-grant-privileges-to-users-in-
mysql-8-0/
** Patch added: "fix for mysql8 issues in eoan (debdiff)"
https://bugs.launchpad.net/ubuntu/+source/qemu/+bug/1845321/+attachment/5291379/+files/cinder-mysql8.debdiff
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1845321
Title:
cinder-daemons autopkgtest must override driver to use pymysql
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/cinder/+bug/1845321/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
