<
From version < 59.1 >
edited by Thomas Mortagne
on 2020/05/28
To version < 61.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
... ... @@ -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 +

Get Connected