MySQL

ZeroPage�� 하��

1. ��
2. �� 호 �� ( �� )
3. ��
4. DB��한 �� (��)
5. �� 항
6. Thread
7. MySQL & Transaction
8. MySQL Password 함��

http://www.mysql.com

MySQL �� : ZeroPage �� , MySQL�� 한 ��
MySQL ��

~cpp 
jdbc:mysql://localhost/database?user=user&password=xxx&useUnicode=true&characterEncoding=KSC5601

1. �� ¶

ZeroPage Server�� MySQL�� 토�� ~cpp /var/lib/mysql �� 해�� 토�� 하�� 하��. �� mysql�� 키�� 한��.

�� 하�� 할�� 토�� 해��하�� 토�� 하�� 하��.

-- �� root�� ? ��한�� -jeppy

�� 하�� 해 ��. �� 했�� --��

~cpp 
��������� DB ������ ������하���
mysqldump -p���호 -u��������� --database DB��� > mysqlbackup.sql

������ 테��������� ������하���
mysqldump -p���호 -u��������� DB��� TABLE��� > tablebackup.sql

������
mysql -p���호 -u��������� --database db��� < mysqlbackup.sql

2. �� 호 �� ( �� ) ¶

mysql> SET PASSWORD FOR ��@'%' = PASSWORD('�� 호');
mysql> SET PASSWORD FOR ��@'localhost' = PASSWORD('��호');

3. �� ¶

Database mysql�� user 테�� ~cpp flush privileges�� 행한��.
�� : myadmin shutdown -p
�� : safe_mysqld * MySQL/root��호��

4. DB��한 �� (��) ¶

~cpp 
insert user values('localhost', 'jeppy', password('���호'), 'y','y','y','y','y','y','y','y','y','y','y','y','y','y'); 
insert user values('%', 'jeppy', password('���호'), 'y','y','y','y','y','y','y','y','y','y','y','y','y','y'); 

FLUSH PRIVILEGES; 

CREATE DATABASE jeppy;

REVOKE all PRIVILEGES on *.* from jeppy@'localhost'; 
REVOKE all PRIVILEGES on *.* from jeppy@'%'; 

FLUSH PRIVILEGES; 

GRANT all on jeppy.* to jeppy@'localhost'; 
GRANT all on jeppy.* to jeppy@'%'; 
FLUSH PRIVILEGES;

5. �� 항 ¶

ZeroPage 회�� (99,neocoin)�� 해 ��.
�� 회�� ZeroPage �� 협��할 �� .

6. Thread ¶

~cpp 
mysql> select * from addressbook order by name asc;
+-----------+---------------+
| name      | phone         |
+-----------+---------------+
| ���희���    | 011-9143-8841 |
| ���������    | 011-9364-7855 |
| ���������    | 016-9583-1017 |
| ���������~^^ | 011-9908-0299 |
| ������호    | 011-9115-8338 |
| ���������    | 011-9808-5075 |
+-----------+---------------+
6 rows in set (0.00 sec)

�� , ORDER BY name (��트��) �� 하��, �� 해��.

�� 해�� 해��

~cpp 
mysql> select ('���' > '���');
+---------------+
| ('���' > '���') |
+---------------+
|             1 |
+---------------+
1 row in set (0.00 sec)

�� MySQL status ��

~cpp 
Client characterset:    latin1
Server characterset:    latin1

�� 하�� 해��. (�� ;) --1002

�� . �� 한 �� ~ ��~~;; ��호 통�� 험�� .. --neocoin

MySQL�� 한�� 하�� char �� char binary �� . 하�� char �� ORDER BY BINARY �� 하�� . MySQL�� char �� 한 ��키(0~127) �� 합��. �� char �� 해�� 한�� 하�� , �� 하�� . --��

Thanks.~ --1002

ㅎㅎ 형 ��~^^ --��

~cpp 
mysql> desc addressbook; 
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| name  | char(10) |      |     |         |       |  <-- name ��� char ��������������.
| phone | char(15) |      |     |         |       |
+-------+----------+------+-----+---------+-------+
2 rows in set (0.00 sec)

~cpp 
mysql> select * from addressbook ORDER BY BINARY name;
+-----------+---------------+
| name      | phone         |
+-----------+---------------+
| ������호    | 011-9115-8338 |
| ���������    | 011-9808-5075 |
| ���������    | 011-9364-7855 |
| ���희���    | 011-9143-8841 |
| ���������    | 016-9583-1017 |
| ���������~^^ | 011-9908-0299 |
+-----------+---------------+
6 rows in set (0.00 sec)

7. MySQL & Transaction ¶

MySQL�� Transaction 테�� InnoDB �� BSDDB �� 하�� Transaction �� 할 �� . (InnoDB ��)

8. MySQL Password 함�� ¶

MySQL �� 함�� PASSWORD �� 해�� 호화�� 한 ��. �� . �� , �� MySQL�� Password 함�� 해�� 해�� 할 �� .

http://navyism.com/main/memo.php?bd=lib&no=24

��, 3.23 �� 함. MySQL �� 4.1 �� PASSWORD 함�� .

�� & 파�� (�� 포팅한 ��)
MySQL/PasswordFunctionInPython
MySQL/PasswordFunctionInJava

�� PHP �� ? ��.. MySQL �� 한��.- UseTheSourceLuke --1002

��

Contents

1. ������ ������ ¶

2. ������ ���호 ������ ������ ( ��������� ������ ������ �������� ������) ¶

3. ������������ ������ ¶

4. DB���한 ������ (������������) ¶

5. ����� ������ ������ ���항 ¶