Ubuntu
cinder package

  1. Bug #1845321
  2. Comment #7

Comment 7 for bug 1845321

Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

@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/