Hestia always Add Db in utf8mb4_general_ci encoding

How to replace it from “utf8mb4_general_ci” to “utf8mb4_unicode_ci” by default?

I think problem is here in query

For example

SET NAMES utf8mb4;
CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

It needs to be added as a new feature…

Can be added via mariadb server settings


User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. As of MySQL 8.0.33, the server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued when the server is started with --collation-server set equal to the name of a user-defined collation.

Mysql Is about to drop support for it…

1 Like

Hello @hestia,

As @eris said, you can modify conf manually, collation_server directive is here:



@eris @sahsanu Thank you!

but doesn’t work


this problem has been around for many years, I can’t do anything about it, only change the encoding manually every time after creating the database, I’m just tired of doing this…

Update my.cnf

1 Like