O
O
OM12017-03-05 09:27:10
MySQL
OM1, 2017-03-05 09:27:10

Ubuntu mysql: have memory and encoding setting, how-to?

1. Mysql has memory, and immediately after rebooting the server:
5b1c06632d274ab5b5b90159d957cdb3.PNG
2. Encoding setting, by default in phpMyAdmin I see: utf8mb4_bin, when scripts are running:

\u0411\u0435\u0441\u0441\u043c\u0435\u0440\u0442\u043d\u044

Tried to edit configs in /ect/mysql/
ef97653062dc40d0b25267f3758a5a93.PNG
something like:
[mysql]
character-set-server=utf8
collation-server=utf8_general_ci
init-connect="SET NAMES utf8"

table_open_cache = 1024
query_cache_limit = 2M
query_cache_size = 56M
query_cache_type = 1
thread_cache_size = 16

max_heap_table_size = 56M
tmp_table_size = 56M

I restart the mysql server and nothing changes, where and what to register?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question