<
From version < 56.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##:(((
... ... @@ -132,7 +132,7 @@
132 132  $mysql_cmd -e "USE $db;SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=DATABASE();"
133 133  {{/code}}
134 134  
135 -You can also look at a[[snippet to perform this conversion inside XWiki>>snippets:Extension.Migrate MySQL databases to utf8mb4]].
140 +You can also look at [[this snippet to perform this conversion inside XWiki>>snippets:Extension.Migrate MySQL databases to utf8mb4]].
136 136  
137 137  == Convert from MyISAM to InnoDB ==
138 138  

Get Connected