Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. ThomasMortagne1 +XWiki.VincentMassol - Content
-
... ... @@ -117,8 +117,14 @@ 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 'CDT' 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.{{/code}} 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 +* If you get the following error then you'll need to force the timezone to use either by setting it in the MySQL conf file or passing it in the JDBC URL string as in ##jdbc:mysql:~/~/localhost:3306/myschema?serverTimezone=UTC##:((( 121 +{{code language='none'}} 122 +The server timezone value 'CDT' 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. 123 +{{/code}} 121 121 125 +For more details see [[this explanation post>>https://stackoverflow.com/a/54256150/153102]]. 126 +))) 127 + 122 122 == Convert a database from latin1 (or collation utf8_ci) to utf8mb4/utf8mb4_bin == 123 123 124 124 {{code}}