hostname not set correctly on MySQL 5.6 on Korean Windows
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:
collation-server=euckr_korean_ci
character-set-server=euckr
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!
Jennifer
Subject
Views
Written By
Posted
hostname not set correctly on MySQL 5.6 on Korean Windows
2427
March 04, 2015 02:47PM
1262
March 06, 2015 09:57AM
1212
March 06, 2015 04:06PM
1171
March 08, 2015 12:06AM
1211
March 09, 2015 08:57AM
1360
March 12, 2015 04:49PM
1219
March 13, 2015 12:58PM
1146
March 14, 2015 10:29AM
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.