commit e0d541073da06a583681774b2ecb61bf5a9bd2d1
Author: Ghanshyam Mann <email address hidden>
Date: Tue Jun 30 21:21:39 2020 -0500
Fix user creation with GRANT in MySQL 8.0(Ubuntu Focal)
In Ubuntu Bionic (18.04) mysql 5.7 version used to create
the user implicitly when using using the GRANT.
Ubuntu Focal (20.04) has mysql 8.0 and with mysql 8.0 there
is no implicit user creation with GRANT. We need to
create the user first before using GRANT command.
Nova unit and functional tests job using tools/test-setup.sh
script start failing when running on Ubuntu Focal
Error log:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1064 (42000) at line 4: 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 'openstack_citest' WITH GRANT OPTION' at line 2
Reviewed: https:/ /review. opendev. org/738723 /git.openstack. org/cgit/ openstack/ nova/commit/ ?id=e0d541073da 06a583681774b2e cb61bf5a9bd2d1
Committed: https:/
Submitter: Zuul
Branch: master
commit e0d541073da06a5 83681774b2ecb61 bf5a9bd2d1
Author: Ghanshyam Mann <email address hidden>
Date: Tue Jun 30 21:21:39 2020 -0500
Fix user creation with GRANT in MySQL 8.0(Ubuntu Focal)
In Ubuntu Bionic (18.04) mysql 5.7 version used to create
the user implicitly when using using the GRANT.
Ubuntu Focal (20.04) has mysql 8.0 and with mysql 8.0 there
is no implicit user creation with GRANT. We need to
create the user first before using GRANT command.
Nova unit and functional tests job using tools/test-setup.sh
script start failing when running on Ubuntu Focal
https:/ /zuul.opendev. org/t/openstack /build/ 8b0f4fcc2185465 5a638c413b6fe1a 91
Error log:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1064 (42000) at line 4: 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 'openstack_citest' WITH GRANT OPTION' at line 2
Story: #2007865
Task: #40200
Change-Id: I97b0dcbb88c6ef 7c22e3c55970211 bed792bbd0d
Closes-Bug: #1885825