diff options
author | Sean McGivern <sean@mcgivern.me.uk> | 2017-07-07 23:31:00 +0300 |
---|---|---|
committer | Sean McGivern <sean@mcgivern.me.uk> | 2017-07-07 23:31:00 +0300 |
commit | 69e17c225e53feaa7449e468e89aca3f084ab9f9 (patch) | |
tree | 1881596d438dc9c3a86488b80d3fe6e68fb90c0c /doc/update | |
parent | 5f8f555a6649c8463c66551af2948f1e56e7ce6a (diff) | |
parent | 9a8130f9e257c9f4e7d43d8d494ec740d857da30 (diff) |
Merge branch 'dm-mysql-log_bin_trust_function_creators' into 'master'
Mention that 9.3 also needs `log_bin_trust_function_creators` on MySQL.
See merge request !12687
Diffstat (limited to 'doc/update')
-rw-r--r-- | doc/update/9.2-to-9.3.md | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/doc/update/9.2-to-9.3.md b/doc/update/9.2-to-9.3.md index 097b996ec31..910539acc70 100644 --- a/doc/update/9.2-to-9.3.md +++ b/doc/update/9.2-to-9.3.md @@ -164,6 +164,19 @@ permissions on the database: ```bash mysql -u root -p -e "GRANT TRIGGER ON \`gitlabhq_production\`.* TO 'git'@'localhost';" ``` + +If you use MySQL with replication, or just have MySQL configured with binary logging, +you will need to also run the following on all of your MySQL servers: + +```bash +mysql -u root -p -e "SET GLOBAL log_bin_trust_function_creators = 1;" +``` + +You can make this setting permanent by adding it to your `my.cnf`: + +``` +log_bin_trust_function_creators=1 +``` ### 11. Update configuration files |