Y
Y
Yuri Shchegolikhin2018-03-08 18:23:51
MySQL
Yuri Shchegolikhin, 2018-03-08 18:23:51

How to change mariadb values?

I bought a VPS, I want to set up replication,
but I need to change the following values

character_set_server utf8_unicode_ci
collation_server utf8_unicode_ci
character_set_server utf8_unicode_ci
character_set_database utf8_unicode_ci
character_set_connection utf8_unicode_ci
character_set_client utf8_unicode_ci
collation_server utf8_unicode_ci
collation_database utf8_unicode_ci
collation_connection utf8_unicode_ci

The hoster reported that this can be done in the following folder:
/etc/my.cnf.d files
in this folder
client.cnf
enable_encryption.preset
mysql-clients.cnf
server.cnf
tokudb.cnf

Where can I read where and what to contribute?
The matter is that in these files there are no these lines...
Tried to register them in each file.
When checking replication, error, no data changed....

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Boris Korobkov, 2018-03-08
@BorisKorobkov

Where can I read where and what to contribute?

I'll tell you a secret: you need to read the documentation.
Specifically https://dev.mysql.com/doc/refman/5.7/en/charset-se...
It says
Initially, the server character set and collation depend on the options that you use when you start mysqld

Accordingly, it must be registered in the [mysqld]config section.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question