<
From version < 58.1 >
edited by Thomas Mortagne
on 2020/05/28
To version < 60.1 >
edited by Vincent Massol
on 2020/06/01
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.ThomasMortagne
1 +XWiki.VincentMassol
Content
... ... @@ -33,7 +33,7 @@
33 33  )))
34 34  * Create the ##xwiki## user with password ##xwiki##(((
35 35  {{code}}
36 -CREATE USER 'xwiki'@'localhost' IDENTIFIED BY 'xwiki';
36 +mysql -u root -e "CREATE USER 'xwiki'@'localhost' IDENTIFIED BY 'xwiki'";
37 37  {{/code}}
38 38  )))
39 39  * 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:(((
... ... @@ -113,6 +113,11 @@
113 113  
114 114  = Tips =
115 115  
116 +== MySQL 8 ==
117 +
118 +* If you're using MySQL 8+ you'll need to configure MySQL with native password: ##default-authentication-plugin=mysql_native_password##.
119 +* You'll also be able to switch from ##com.mysql.jdbc.Driver## to ##com.mysql.cj.jdbc.Driver## JDBC driver (since the previous driver class is now deprecated).
120 +
116 116  == Convert a database from latin1 (or collation utf8_ci) to utf8mb4/utf8mb4_bin ==
117 117  
118 118  {{code}}

Get Connected