Changing the character set of MySQL to utf8 from lain1

php
phpmyadmin
mysql

#1

I need to be able to store and retrieve data in Korean on MySQL using PHP.

After some searching on Stack Overflow, I learned that I need to change the character_set_database and character_set_server to utf8.

I also learned that I need to do this via changing the my.cnf file, but I can’t seem to locate it, nor am I allowed to write one.

This is the configuration I got it down to so far:

mysql> show variables like "char%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

Someone help me out please!