@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.
@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: @'localhost' \
9 mysql -u root << EOF
10 CREATE DATABASE cinder;
11 GRANT ALL PRIVILEGES ON cinder.* TO 'cinder'
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'; @'localhost' IDENTIFIED BY 'changeme'; @'localhost' ;
GRANT ALL PRIVILEGES ON cinder.* TO 'cinder'@'%';
CREATE USER 'cinder'
GRANT ALL PRIVILEGES ON cinder.* TO 'cinder'
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-privilege s-to-users- in-mysql- 8-0/