Set mysql Korean in Ubuntu

Asked 2 years ago, Updated 2 years ago, 47 views

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

2022-09-22 16:55

1 Answers

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/.


2022-09-22 16:55

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.