diff options
-rw-r--r-- | doc/install/installation.md | 2 | ||||
-rw-r--r-- | doc/raketasks/backup_restore.md | 8 |
2 files changed, 9 insertions, 1 deletions
diff --git a/doc/install/installation.md b/doc/install/installation.md index 614fbee..ef78f2d 100644 --- a/doc/install/installation.md +++ b/doc/install/installation.md @@ -73,7 +73,7 @@ You can use either MySQL or PostgreSQL. mysql> CREATE USER 'gitlab_ci'@'localhost' IDENTIFIED BY '$password'; # Grant proper permissions to the MySQL User - mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `gitlab_ci_production`.* TO 'gitlab_ci'@'localhost'; + mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON `gitlab_ci_production`.* TO 'gitlab_ci'@'localhost'; # Logout MYSQL mysql> exit; diff --git a/doc/raketasks/backup_restore.md b/doc/raketasks/backup_restore.md index efa95ef..5c54960 100644 --- a/doc/raketasks/backup_restore.md +++ b/doc/raketasks/backup_restore.md @@ -218,3 +218,11 @@ gitlab_ci['backup_keep_time'] = 604800 NOTE: This cron job does not [backup your omnibus-gitlab configuration](#backup-and-restore-omnibus-gitlab-configuration). +## Known issues + +If you’ve been using GitLab CI since 7.11 or before using MySQL and the official installation guide, you will probably get the following error while making a backup: `Dumping MySQL database gitlab_ci_production ... mysqldump: Got error: 1044: Access denied for user 'gitlab_ci'@'localhost' to database 'gitlab_ci_production' when using LOCK TABLES` .This can be resolved by adding a LOCK TABLES permission to the gitlab_ci MySQL user. Add this permission with: +``` +$ mysql -u root -p +mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON `gitlab_ci_production`.* TO 'gitlab_ci'@'localhost'; +``` + |