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. 기��� ������ ���구 ������ ¶