Changes for page MySQL Installation

Last modified by Thomas Mortagne on 2023/11/16

<
From version < 62.1 >
edited by Thomas Mortagne
on 2020/07/01
To version < 63.1 >
edited by Vincent Massol
on 2020/07/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
... ... @@ -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}}

Get Connected