https://planeshift.top-ix.org//pswiki/index.php?action=history&feed=atom&title=Errors_in_Database_connection 2026-04-06T13:00:30Z Revision history for this page on the wiki MediaWiki 1.43.1 https://planeshift.top-ix.org//pswiki/index.php?title=Errors_in_Database_connection&diff=24444&oldid=prev 2022-07-02T22:11:13Z

<p>Created page with &quot; == Error: Can&#039;t initialize character set unknown (path: compiled_in) == LogSQL: Error: Failed to connect to database: Error: Can&#039;t initialize character set unknown (path: compiled_in) This happened after we upgraded on Windows the mysql DB from 5.5 to 8.0.29. This error was present when starting the PSUnreal server. We have seen the DB was using a character set utf8_mb4, collation: utf8mb4_0900_ai_ci , checking production db on linux MariaDB [planeshift_prod2]&gt; SELE...&quot;</p> <p><b>New page</b></p><div><br /> == Error: Can&#039;t initialize character set unknown (path: compiled_in) ==<br /> LogSQL: Error: Failed to connect to database: Error: Can&#039;t initialize character set unknown (path: compiled_in)<br /> This happened after we upgraded on Windows the mysql DB from 5.5 to 8.0.29. This error was present when starting the PSUnreal server.<br /> <br /> We have seen the DB was using a character set utf8_mb4, collation: utf8mb4_0900_ai_ci , checking production db on linux <br /> MariaDB [planeshift_prod2]&gt; SELECT @@character_set_database, @@collation_database;<br /> +--------------------------+----------------------+<br /> | @@character_set_database | @@collation_database |<br /> +--------------------------+----------------------+<br /> | utf8mb4                  | utf8mb4_general_ci   |<br /> +--------------------------+----------------------+<br /> 1 row in set (0.000 sec)<br /> <br /> <br /> We edited mysql.ini file adding these two lines:<br /> character-set-server = utf8mb4<br /> collation-server = utf8mb4_general_ci<br /> and ensured that the db startup was using the proper ini file:<br /> mysqld --defaults-file=&quot;E:/MySQL80Data/my.ini&quot; --datadir=&quot;E:/MySQL80Data/Data&quot;</div>

Talad