Changes for page MySQL Installation

Last modified by Thomas Mortagne on 2023/11/16

<
From version < 63.2 >
edited by Vincent Massol
on 2020/07/01
To version < 64.1 >
edited by Vincent Massol
on 2020/07/01
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -117,7 +117,11 @@
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 you get the following error then you'll need to force the timezone to use either by setting it in the MySQL conf file on the server or passing it in the JDBC URL string as in ##jdbc:mysql:~/~/localhost:3306/myschema?serverTimezone=UTC## (in XWiki's ##hibernate.cfg.xml## file):(((
120 +* If you get the following error then you'll need to force the timezone to use either by setting it in:(((
121 +* The MySQL conf file on the server
122 +* In the XWiki ##hibernate.cfg.xml## file in the ##hibernate.connection.serverTimezone## property (e.g. ##<property name="hibernate.connection.serverTimezone">Europe/Berlin</property>##).
123 +* In the XWiki ##hibernate.cfg.xml## file inside the JDBC URL string as in ##jdbc:mysql:~/~/localhost:3306/myschema?serverTimezone=UTC##
124 +
121 121  {{code language='none'}}
122 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 123  {{/code}}

Get Connected