diff options
author | Ryan Hefner <ryanhefner@avocode.com> | 2018-09-13 16:27:57 +0200 |
---|---|---|
committer | Ryan Hefner <ryanhefner@avocode.com> | 2018-09-13 16:27:57 +0200 |
commit | 2906e09f3ab8df4a5f2baf88663fd9cf459554d1 (patch) | |
tree | d082c037cdcee1afb8a601f353da292b89abd6c0 | |
parent | c4009e643d3f7297d4eb53477ee7b71e25ac01bd (diff) | |
download | gitlab-ce-2906e09f3ab8df4a5f2baf88663fd9cf459554d1.tar.gz |
Add dbname to MySQL migration GRANT command
-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 7f012312819..f1466513d45 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). |