1 |
fox2mike 05/08/25 07:47:00 |
2 |
|
3 |
Modified: xml/htdocs/doc/en mysql-howto.xml |
4 |
Log: |
5 |
Coding style + Typos + Minor content changes. |
6 |
|
7 |
Revision Changes Path |
8 |
1.2 +41 -42 xml/htdocs/doc/en/mysql-howto.xml |
9 |
|
10 |
file : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.2&content-type=text/x-cvsweb-markup&cvsroot=gentoo |
11 |
plain: http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml?rev=1.2&content-type=text/plain&cvsroot=gentoo |
12 |
diff : http://www.gentoo.org/cgi-bin/viewcvs.cgi/xml/htdocs/doc/en/mysql-howto.xml.diff?r1=1.1&r2=1.2&cvsroot=gentoo |
13 |
|
14 |
Index: mysql-howto.xml |
15 |
=================================================================== |
16 |
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v |
17 |
retrieving revision 1.1 |
18 |
retrieving revision 1.2 |
19 |
diff -u -r1.1 -r1.2 |
20 |
--- mysql-howto.xml 25 Aug 2005 05:19:14 -0000 1.1 |
21 |
+++ mysql-howto.xml 25 Aug 2005 07:47:00 -0000 1.2 |
22 |
@@ -1,6 +1,6 @@ |
23 |
<?xml version="1.0" encoding="UTF-8"?> |
24 |
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd"> |
25 |
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.1 2005/08/25 05:19:14 fox2mike Exp $ --> |
26 |
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.2 2005/08/25 07:47:00 fox2mike Exp $ --> |
27 |
|
28 |
<guide link="/doc/en/mysql-howto.xml"> |
29 |
<title>MySQL Startup Guide</title> |
30 |
@@ -23,7 +23,7 @@ |
31 |
<!-- See http://creativecommons.org/licenses/by-sa/2.5 --> |
32 |
<license/> |
33 |
|
34 |
-<version>1.0</version> |
35 |
+<version>1.1</version> |
36 |
<date>2005-08-25</date> |
37 |
|
38 |
<chapter> |
39 |
@@ -359,7 +359,7 @@ |
40 |
<p> |
41 |
This command is used to insert a record into table. table contains the MySQL |
42 |
table we wish to enter the information into. The table name may be followed by |
43 |
-the list of columns to insert data into and VALUE() contains the values you |
44 |
+the list of columns to insert data into and <c>VALUE()</c> contains the values you |
45 |
wish to insert into the table. You may omit the list of columns if you insert a |
46 |
value into each one and if you write the values in the same order the columns |
47 |
have been defined. In this case, we want to insert data into the developers |
48 |
@@ -390,8 +390,8 @@ |
49 |
</pre> |
50 |
|
51 |
<impo> |
52 |
-Be sure you know what data you're dealing with. It's very unsafe to use LOAD |
53 |
-DATA when you are uncertain of the file's contents! |
54 |
+Be sure you know what data you're dealing with. It's very unsafe to use <c>LOAD |
55 |
+DATA</c> when you are uncertain of the file's contents! |
56 |
</impo> |
57 |
|
58 |
<p> |
59 |
@@ -435,7 +435,7 @@ |
60 |
|
61 |
<p> |
62 |
Like <c>LOAD DATA</c>, be sure you can tell what <path>sqlfile</path> does. |
63 |
-<e>Failure to do so may cause your database to be compromised</e>! Another way |
64 |
+<e>Failure to do so may cause your database to be compromised!</e> Another way |
65 |
you can accomplish this is to use the <c>source</c> command. This command will |
66 |
run mysql commands from an sql file while in the mysql interactive mode. Here |
67 |
is how to source an sql file: |
68 |
@@ -447,7 +447,7 @@ |
69 |
|
70 |
<p> |
71 |
If you see a web application wanting you to run an sql file, the two above |
72 |
-commands can be used to accomplish that taks. We have our table setup, so how |
73 |
+commands can be used to accomplish that task. We have our table setup, so how |
74 |
do we check our fields? We do this by searching our table with queries. |
75 |
</p> |
76 |
|
77 |
@@ -562,7 +562,7 @@ |
78 |
|
79 |
<note> |
80 |
<c>GRANT</c> is considered to be the way to create a user. Later versions of |
81 |
-MySQL, however, do contain a <c>CREATE_USER</c> function, though GRANT is still |
82 |
+MySQL, however, do contain a <c>CREATE_USER</c> function, though <c>GRANT</c> is still |
83 |
preferred. |
84 |
</note> |
85 |
|
86 |
@@ -572,19 +572,20 @@ |
87 |
</p> |
88 |
|
89 |
<ul> |
90 |
- <li>ALL - Gives the all privlege control for the database</li> |
91 |
- <li>CREATE - Allows users to create tables</li> |
92 |
- <li>SELECT - Allows users to query tables</li> |
93 |
- <li>INSERT - Allows users to insert data into a table</li> |
94 |
- <li>SHOW DATABASES - Allows users to see a list of databases</li> |
95 |
- <li>USAGE - User has no privleges</li> |
96 |
- <li>GRANT OPTION - Allows users to grant privleges</li> |
97 |
+ <li><c>ALL</c> - Gives the all privlege control for the database</li> |
98 |
+ <li><c>CREATE</c> - Allows users to create tables</li> |
99 |
+ <li><c>SELECT</c> - Allows users to query tables</li> |
100 |
+ <li><c>INSERT</c> - Allows users to insert data into a table</li> |
101 |
+ <li><c>SHOW DATABASES</c> - Allows users to see a list of databases</li> |
102 |
+ <li><c>USAGE</c> - User has no privleges</li> |
103 |
+ <li><c>GRANT OPTION</c> - Allows users to grant privleges</li> |
104 |
</ul> |
105 |
|
106 |
<note> |
107 |
-If you're running MySQL to communicate data to a web application, CREATE, |
108 |
-SELECT, INSERT (discussed here), DELETE and UPDATE (for further infomation look |
109 |
-up the <uri link="http://dev.mysql.com/doc/mysql/en/grant.html"> MySQL |
110 |
+If you're running MySQL to communicate data to a web application, <c>CREATE</c>, |
111 |
+<c>SELECT</c>, <c>INSERT</c> (discussed here), <c>DELETE</c> and <c>UPDATE</c> |
112 |
+(for further infomation look up the |
113 |
+<uri link="http://dev.mysql.com/doc/mysql/en/grant.html"> MySQL |
114 |
Reference Manual - GRANT and REVOKE Syntax</uri> section) are the only |
115 |
permissions you will most likely need. A lot of people make the mistake of |
116 |
granting all permissions when it's not really necessary. Check with the |
117 |
@@ -593,13 +594,13 @@ |
118 |
</note> |
119 |
|
120 |
<p> |
121 |
-For our admin user, ALL will do. For the guest user, SELECT will be sufficient |
122 |
-for read only access. database is the database we wish the user to have these |
123 |
-permissions on. In this example, gentoo is the database. The .* means all |
124 |
-tables. If you wanted to, you could apply per table access. user is the name of |
125 |
-the user and host is the hostname the user will be accessing from. In most |
126 |
-cases, this will be localhost. Finally, password is the user's password. Given |
127 |
-the information, let's go ahead and create our users. |
128 |
+For our admin user, ALL will do. For the guest user, <c>SELECT</c> will be |
129 |
+sufficient for read only access. database is the database we wish the user |
130 |
+to have these permissions on. In this example, gentoo is the database. The .* |
131 |
+means all tables. If you wanted to, you could apply per table access. user is |
132 |
+the name of the user and host is the hostname the user will be accessing from. |
133 |
+In most cases, this will be localhost. Finally, password is the user's |
134 |
+password. Given the information, let's go ahead and create our users. |
135 |
</p> |
136 |
|
137 |
<pre caption="Creating the admin and guest user"> |
138 |
@@ -742,7 +743,7 @@ |
139 |
The admin user can access the database as they please. Now sometimes, we need |
140 |
to get rid of user permissions. This could be anything from a problematic user |
141 |
to a retired employee. Let's take a look at how to disable user permissions |
142 |
-with the REVOKE command. |
143 |
+with the <c>REVOKE</c> command. |
144 |
</p> |
145 |
|
146 |
</body> |
147 |
@@ -807,7 +808,7 @@ |
148 |
And our problematic user is no longer able to access the gentoo database. |
149 |
Please note that the user was still able to login. That is because they remain |
150 |
in the main MySQL database. Let's take a look at how to completely remove an |
151 |
-account with DELETE and the MySQL user table. |
152 |
+account with <c>DELETE</c> and the MySQL user table. |
153 |
</p> |
154 |
|
155 |
</body> |
156 |
@@ -868,11 +869,10 @@ |
157 |
|
158 |
<p> |
159 |
Now that we have our information, we can get rid of the guest user. |
160 |
-This is done with the <c>DELETE command</c>. The format of the <c> |
161 |
-DELETE</c> command for our usage is as follows: |
162 |
+This is done with the <c>DELETE</c> command and the syntax is shown below. |
163 |
</p> |
164 |
|
165 |
-<pre caption="DELETE format"> |
166 |
+<pre caption="DELETE Syntax"> |
167 |
DELETE FROM table WHERE field='value'; |
168 |
</pre> |
169 |
|
170 |
@@ -921,19 +921,19 @@ |
171 |
|
172 |
<ul> |
173 |
<li> |
174 |
- <uri link="http://www.phpmyadmin.net/home_page/">phpMyAdmin</uri> - Popular |
175 |
- php based MySQL administration tool. |
176 |
- </li> |
177 |
+ <uri link="http://www.phpmyadmin.net/home_page/">phpMyAdmin</uri> - Popular |
178 |
+ php based MySQL administration tool. |
179 |
+ </li> |
180 |
<li> |
181 |
- <uri |
182 |
- link="http://sourceforge.net/projects/mysqlnavigator/">mysqlnavigator</uri> |
183 |
- - QT frontend to MySQL. |
184 |
- </li> |
185 |
+ <uri |
186 |
+ link="http://sourceforge.net/projects/mysqlnavigator/">mysqlnavigator</uri> |
187 |
+ - QT frontend to MySQL. |
188 |
+ </li> |
189 |
<li> |
190 |
- <uri link="http://gmyclient.sourceforge.net/">gmyclient</uri> - A GNOME |
191 |
- based MySQL client. |
192 |
- </li> |
193 |
- <li><uri link="http://www.knoda.org/">knoda</uri> - A KDE MySQL client</li> |
194 |
+ <uri link="http://gmyclient.sourceforge.net/">gmyclient</uri> - A GNOME |
195 |
+ based MySQL client. |
196 |
+ </li> |
197 |
+ <li><uri link="http://www.knoda.org/">knoda</uri> - A KDE MySQL client.</li> |
198 |
</ul> |
199 |
|
200 |
<p> |
201 |
@@ -945,5 +945,4 @@ |
202 |
</body> |
203 |
</section> |
204 |
</chapter> |
205 |
- |
206 |
</guide> |
207 |
|
208 |
|
209 |
|
210 |
-- |
211 |
gentoo-doc-cvs@g.o mailing list |