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. ������ ���문 ������ ������ ¶