{"action":"opened","issue":{"url":"https://api.github.com/repos/flarum/core/issues/1364","repository_url":"https://api.github.com/repos/flarum/core","labels_url":"https://api.github.com/repos/flarum/core/issues/1364/labels{/name}","comments_url":"https://api.github.com/repos/flarum/core/issues/1364/comments","events_url":"https://api.github.com/repos/flarum/core/issues/1364/events","html_url":"https://github.com/flarum/core/issues/1364","id":296000514,"number":1364,"title":"Documentation:  Mysql/MariaDB Settings and/or issues in Installation Instructions","user":{"login":"grettenberg","id":32497088,"avatar_url":"https://avatars1.githubusercontent.com/u/32497088?v=4","gravatar_id":"","url":"https://api.github.com/users/grettenberg","html_url":"https://github.com/grettenberg","followers_url":"https://api.github.com/users/grettenberg/followers","following_url":"https://api.github.com/users/grettenberg/following{/other_user}","gists_url":"https://api.github.com/users/grettenberg/gists{/gist_id}","starred_url":"https://api.github.com/users/grettenberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/grettenberg/subscriptions","organizations_url":"https://api.github.com/users/grettenberg/orgs","repos_url":"https://api.github.com/users/grettenberg/repos","events_url":"https://api.github.com/users/grettenberg/events{/privacy}","received_events_url":"https://api.github.com/users/grettenberg/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-09T20:23:33Z","updated_at":"2018-02-09T20:23:33Z","closed_at":null,"author_association":"NONE","body":" I am very interested in the this software.  I support numerous webserver application packages such as Drupal 7, Drupal 8, WordPress and others.  Each generally has in the installation guide a clear section of information on the creation of the database.\r\n\r\nI ran into a installation problem found in the forums after the fact on MariaDB 10.2.x, which failed.\r\n\r\nI am open to taking responsibility for creating a database section for the installation instructions if I can get clarity on the best approach.\r\n\r\nFor instance:\r\n\r\n1)  What versions of mysql or mariadb are supported, or break with the installer?\r\n2)  What is the preferred setting for\r\n  a.  CHARACTER SET   (should this be utf8mb4 like many cms applications?)\r\n  b.  COLLATE (if any)   (should this be utf8mb4_general_ci like many cms applications?)\r\n  c.  What are the minimum desired GRANT rights?\r\n(for example in Drupal 8 you might expect:  (WITH LOCK TABLES if you use git)\r\nGRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password';\r\n\r\nWith alternates for a specific remote server or server cluster.\r\n\r\n3)  Are there patches for common failed installs of the current version?\r\n\r\nThis belongs in the installation documentation going forward...\r\n\r\nIs there a time line for version 8?  "}}
{"actor":{"display_login":"grettenberg"}}