Summary

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

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.ThomasMortagne
	1	+XWiki.VincentMassol

Content

...	...	@@ -113,6 +113,12 @@
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	+* If your server timezone is ambiguous (such as ##CDT##) you'll get a {{code}}The server timezone value 'UTC' is unrecognized or represents more than one timezone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc timezone value if you want to utilize timezone support.{{/error}} error. You need to set the timezeon in the JDBC connection string, such as with ##jdbc:mysql://localhost:3306/myschema?serverTimezone=UTC##. See this [[explanation post>>https://stackoverflow.com/a/54256150/153102]].
	121	+
116	116	== Convert a database from latin1 (or collation utf8_ci) to utf8mb4/utf8mb4_bin ==
117	117
118	118	{{code}}
...	...	@@ -300,3 +300,5 @@
300	300	You can solve the problem by changing the innodb_log_file_size in the my.ini text file.
301	301	Find more details in the link below.
302	302	http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html
	309	+
	310	+