Summary

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

Details

Page properties

Content

...	...	@@ -117,6 +117,7 @@
117	117
118	118	* If you're using MySQL 8+ you'll need to configure MySQL with native password: ##default-authentication-plugin=mysql_native_password##.
119	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]].
120	120
121	121	== Convert a database from latin1 (or collation utf8_ci) to utf8mb4/utf8mb4_bin ==
122	122
...	...	@@ -305,3 +305,5 @@
305	305	You can solve the problem by changing the innodb_log_file_size in the my.ini text file.
306	306	Find more details in the link below.
307	307	http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html
	309	+
	310	+