summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndreas Brandl <abrandl@gitlab.com>2018-10-23 12:30:14 +0000
committerAndreas Brandl <abrandl@gitlab.com>2018-10-23 12:30:14 +0000
commita84469a34596d0f3588f7ae16646489441241bc6 (patch)
tree477fe179e93328d0168527d0ce581ef30214751f
parent708875ae9ed2a9da0669ebca2bf68259a57bc056 (diff)
parent2906e09f3ab8df4a5f2baf88663fd9cf459554d1 (diff)
downloadgitlab-ce-a84469a34596d0f3588f7ae16646489441241bc6.tar.gz
Merge branch 'mysql-migration-trigger-permissions' into 'master'
Add dbname to MySQL migration GRANT command See merge request gitlab-org/gitlab-ce!21719
-rw-r--r--lib/gitlab/database/migration_helpers.rb2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/gitlab/database/migration_helpers.rb b/lib/gitlab/database/migration_helpers.rb
index 30541ee3553..a17f27a3147 100644
--- a/lib/gitlab/database/migration_helpers.rb
+++ b/lib/gitlab/database/migration_helpers.rb
@@ -937,7 +937,7 @@ database (#{dbname}) using a super user and running:
For MySQL you instead need to run:
- GRANT ALL PRIVILEGES ON *.* TO #{user}@'%'
+ GRANT ALL PRIVILEGES ON #{dbname}.* TO #{user}@'%'
Both queries will grant the user super user permissions, ensuring you don't run
into similar problems in the future (e.g. when new tables are created).