hostname not set correctly on MySQL 5.6 on Korean Windows
Posted by: Jennifer Roos
Date: March 04, 2015 02:47PM

I am new to mysql, so apologies if my question is extremely basic. I am having problems with getting the hostname to be displayed correctly in my MySQL 5.6 isntallation on a Korean Windows 2012 server. Someone else did the installation of this box, but I have attempted to get the hostname shown correct by updating the collation and character set in the my.ini file after installation.

select @@hostname returns ????
show variables like 'hostname' returns nothing

Here is the information about the system that I have:

1. 'localhost' on the windows command prompt returns '한국어'.

2. Doing 'show variables like 'char%' on the mysql command prompt with no database selected shows:
character_set_client euckr
character_set_connection euckr
character_set_database euckr
character_set_filesystem binary
character_set_results euckr
character_set_server euckr
character_set_system utf8
character_set_dir (this is the correct dir)

3. I have a database in this installation with Korean characters, and a show databases results in the following in the output:

4. I have the following set in my.ini:

We need to be able to get the correct hostname from our application, so I'm wondering if anyone can suggest something else for me to try?

thank you!

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.