I installed mysql5.7 version in Ubuntu 16.04LTS.
But now the Korean is broken, so I'm going to set it up in Korean
Entered vi /etc/mysql/my.cnf.
Do you usually want to change from my.cnf to UTF-8?
But when I go into my.cnf,
That's what came out TT: I've been doing this and that, but I couldn't find the answer.
ubuntu mysql
Recently, there was an include rule in mysql's my.cnf, so it was changed.
Settings files that belong to clients, servers, etc
It should be in /etc/mysql.conf.d
. (This usually includes settings for MariaDB, which replaces MySQL.)
For older MySQL-only settings files
It will be included in /etc/mysql/mysql.conf.d/
Each directory has the necessary settings to read and process all files ending in .cnf, but if they don't exist, you can create and set them up in one of the above two directories.
For example, change the default character set for Clytherton.
### This file can be placed with client.cnf in /etc/mysql/mysql.conf.d/.
[client]
default-character-set = utf8
MariaDB only setting
## This file should be placed with client.cnf in /etc/mysql/conf.d/.
[client-mariadb]
default-character-set = utf8
Of course, it doesn't matter if you make a single file without the above distinction. It's just for management.
And if you have my.cnf that you used before, you can copy it to /etc/mysql/mysql.conf.d/.
© 2024 OneMinuteCode. All rights reserved.