blob: bf9f47b9f56871ff8a7fdf65b0535d1bf4aa94fa (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
mysql 4.0.25 �Ǥμ¹���
0) mysql �����Ȥ����롣
/etc/rc.d/mysql start
1) localhost ���� root �ǤΥ����������ǧ
% su root
# mysqlaccess localhost root mysql
1.1) localhost ����Υ桼�� fml���ѥ���� uja ��ͭ���ˤ��롣
�ǡ����١��� mysql �����Ƥơ��ơ��֥� user �Υե����ޥå�
���ǧ���롣
# mysqldump mysql
�桼�� root �����������ԡ�����Ŭ�ڤʥǡ������ꡢ
�ǡ����١����˥桼�� fml �������ή�����ࡣ
�桼��������ѹ������� reload ����Τ�˺�줺�ˡ�
# mysql mysql
INSERT INTO user VALUES ('localhost','fml',Password('uja'), ..ά..);
# mysqladmin reload
[INFO] adduser.sql �������θ��ܡ�
2) �ǡ����١��� fml ���롣
# mysqladmin create fml
2.1) �ǡ����١��� fml �ؤΥ����������ǧ
# mysqlaccess localhost fml fml -U root -P -H localhost
3) �ơ��֥� ml ���롣
# mysql fml
create table ml (
fml_ml char(64),
fml_domain char(64),
fml_address char(64),
fml_member int,
fml_recipient int
);
�ǡ��������줿�ꡢ�ǡ���������뤫��Ƥߤ롣
# mysql fml
select * from ml;
[INFO] �ʲ��Σ��ĤΥ���ץ뤬���롣
create_table.sql �ơ��֥���롣
test.sql ���롢������Ѳ��롣
droptable.sql �ơ��֥��ä���
4) test
./getline.pl
��Ͽa) �ƥ��Ȥ˻Ȥä��ǡ����١�����ä���
# mysqladmin drop fml
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.
Do you really want to drop the 'fml' database [y/N] y
Database "fml" dropped
��Ͽb) root �ѥ���ɤ�Ĥ���
# mysqladmin -u root password "�������ѥ����"
����ʹߤϥ��ޥ�ɤ� -p ���ץ�����Ĥ��ѥ�������Ϥ�
����ɬ�פ����롣
��:
# mysqladmin -p create fml
# mysql -p mysql < adduser.sql
# mysql -h �ۥ��� -u �桼�� --password="�ѥ����" �ǡ����١���
------------------------------------------------------------
$FML$
|
