Changes for page MySQL Installation

Last modified by Thomas Mortagne on 2023/11/16

<
From version < 57.1 >
edited by Guillaume Delhumeau
on 2020/04/16
To version < 58.1 >
edited by Thomas Mortagne
on 2020/05/28
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.gdelhumeau
1 +XWiki.ThomasMortagne
Content
... ... @@ -31,9 +31,14 @@
31 31  mysql -u root -e "create database xwiki default character set utf8mb4 collate utf8mb4_bin"
32 32  {{/code}}
33 33  )))
34 +* Create the ##xwiki## user with password ##xwiki##(((
35 +{{code}}
36 +CREATE USER 'xwiki'@'localhost' IDENTIFIED BY 'xwiki';
37 +{{/code}}
38 +)))
34 34  * Give privileges to the ##xwiki## user for accessing and creating databases (for the multi wiki support). Specifically the ##xwiki## users needs permissions to be able to execute {{code}}CREATE DATABASE{{/code}}, {{code}}DROP SCHEMA{{/code}}, and then all CRUD operations on tables. Note that the command below should be tuned to be more restrictive as granting all permissions is not required:(((
35 35  {{code}}
36 -mysql -u root -e "grant all privileges on *.* to xwiki@localhost identified by 'xwiki'"
41 +mysql -u root -e "grant all privileges on *.* to xwiki@localhost"
37 37  {{/code}}
38 38  )))
39 39  * If the above command fails with a password-does-not-meet-requirements error, uninstall the MySQL password_validate plugin or pick a more complex password and update the password used by default in ##hibernate.cfg.xml##:(((

Get Connected