0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

MariaDBで日本語入力を行う

Posted at

EC2インスタンスで、MariaDBをダウンロードした後、データベースに日本語のデータを入れたかったのですが、その際にすべて???で表記されるということが起こりました。その際に対処したコマンドと内容を載せておきます。

export LC_ALL=ja_JP.UTF-8

export LANG=ja_JP.UTF-8

cd /etc/my.cnf.d/

cp server.cnf server.cnf.org

vi server.cnf

------------------------------
[mysqld]
character-set-server=utf8
------------------------------

systemctl restart mariadb

この設定をすれば、日本語入力の文字化けが解消されるかと思います。

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?