zuul
/
zuul
Code Issues Proposed changes

Merge "Don't use GRANT to create new MySQL users"

This commit is contained in:
Zuul 2018-06-21 20:06:26 +00:00 committed by Gerrit Code Review
parent 868e193cf9 b91d687777
commit c3c8078cff
1 changed files with 4 additions and 3 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

7
tests/base.py
View File

@ -1952,9 +1952,10 @@ class MySQLSchemaFixture(fixtures.Fixture):
db="openstack_citest")
cur = db.cursor()
cur.execute("create database %s" % self.name)
cur.execute(
"grant all on %s.* to '%s'@'' identified by '%s'" %
(self.name, self.name, self.passwd))
cur.execute("create user '{user}'@'' identified by '{passwd}'".format(
user=self.name, passwd=self.passwd))
cur.execute("grant all on {name}.* to '{name}'@''".format(
name=self.name))
cur.execute("flush privileges")
self.dburi = 'mysql+pymysql://{name}:{passwd}@{host}/{name}'.format(