Summary

• Page properties (2 modified, 0 added, 0 removed)

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}}