diff options
author | Andreas Brandl <abrandl@gitlab.com> | 2018-10-23 12:30:14 +0000 |
---|---|---|
committer | Andreas Brandl <abrandl@gitlab.com> | 2018-10-23 12:30:14 +0000 |
commit | a84469a34596d0f3588f7ae16646489441241bc6 (patch) | |
tree | 477fe179e93328d0168527d0ce581ef30214751f | |
parent | 708875ae9ed2a9da0669ebca2bf68259a57bc056 (diff) | |
parent | 2906e09f3ab8df4a5f2baf88663fd9cf459554d1 (diff) | |
download | gitlab-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.rb | 2 |
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). |