1. Mysql 환경설정 - 한글개발환경(euckr)일 경우
window -> C:\Windows 밑에 my.ini 파일에 추가
ubuntu -> /etc/mysql/my.cnf 파일에 추가
[mysql]
default-character-set = euckr
[mysqld]
character-set-client-handshake=FALSE
init_connect="SET collation_connection = euckr_korean_ci"
init_connect="SET NAMES euckr"
default-character-set = euckr
character-set-server = euckr
collation-server = euckr_korean_ci
[client]
default-character-set = euckr
[mysqldump]
default-character-set = euckr
Mysql Restart
root 계정으로 mysql 접속후
mysql>status
아래와 같이 나오면 설정 OK.
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.37, for Win32 (ia32)
Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.0.37-community MySQL Community Edition (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: euckr
Db characterset: euckr
Client characterset: euckr
Conn. characterset: euckr
TCP port: 3306
Uptime: 10 sec
Threads: 1 Questions: 4 Slow queries: 0 Opens: 12 Flush tables: 1 Open tabl
es: 6 Queries per second avg: 0.400
--------------
root 계정 초기 비밀번호 지정하기
C:>mysql -uroot mysql
mysql>update user set password=password('새비밀번호') where user='root';
mysql>flush privileges;
mysql>exit
C:>mysql -uroot -p새비밀번호
데이터베이스 생성 및 사용자 생성
C:>mysql -uroot -p비밀번호
mysql>CREATE DATABASE myproject_kr DEFAULT CHARACTER SET euckr COLLATE euckr_korean_ci;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'javamaster'@'localhost' IDENTIFIED BY '1234' WITH GRANT OPTION;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'javamaster'@'%' IDENTIFIED BY '1234' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
mysql>exit
C:>mysql -ujavamaster -p myproject_kr
2. Mysql 환경설정 - 다국어 개발환경(utf-8)일 경우
window -> C:\Windows 밑에 my.ini 파일에 추가
ubuntu -> /etc/mysql/my.cnf 파일에 추가
[mysql]
default-character-set = utf8
[mysqld]
character-set-client-handshake=FALSE
init_connect="SET collation_connection = utf8_general_ci"
init_connect="SET NAMES utf8"
default-character-set = utf8
character-set-server = utf8
collation-server = utf8_general_ci
[client]
default-character-set = utf8
[mysqldump]
default-character-set = utf8
Mysql Restart
root 계정으로 mysql 접속후
mysql>status
아래와 같이 나오면 설정 OK.
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.37, for Win32 (ia32)
Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.0.37-community MySQL Community Edition (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 10 sec
Threads: 1 Questions: 4 Slow queries: 0 Opens: 12 Flush tables: 1 Open tabl
es: 6 Queries per second avg: 0.400
--------------
mysql>
root 계정 초기 비밀번호 지정하기
C:>mysql -uroot mysql
mysql>update user set password=password('새비밀번호') where user='root';
mysql>flush privileges;
mysql>exit
C:>mysql -uroot -p새비밀번호
mysql>CREATE DATABASE myproject_utf8 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'javamaster'@'localhost' IDENTIFIED BY '1234' WITH GRANT OPTION;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'javamaster'@'%' IDENTIFIED BY '1234' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
mysql>exit
C:>mysql -ujavamaster -p1234 myproject_utf8
mysql>set names euckr;
utf8 환경일 경우 도스프롬프트에서 테이블에 한글문자를 등록(insert)하거나 한글을 조회(select)시 깨져보임. set names euckr; 로 설정을 바꾸면 한글이 제대로 보임(Mysql 5일 경우)
Trackback Address :: http://www.ssial.com/trackback/7
