fox2mike 05/08/25 07:47:00 Modified: xml/htdocs/doc/en mysql-howto.xml Log: Coding style + Typos + Minor content changes.
Revision Changes Path 1.2 +41 -42 xml/htdocs/doc/en/mysql-howto.xml 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 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 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 Index: mysql-howto.xml =================================================================== RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- mysql-howto.xml 25 Aug 2005 05:19:14 -0000 1.1 +++ mysql-howto.xml 25 Aug 2005 07:47:00 -0000 1.2 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE guide SYSTEM "/dtd/guide.dtd"> -<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.1 2005/08/25 05:19:14 fox2mike Exp $ --> +<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v 1.2 2005/08/25 07:47:00 fox2mike Exp $ --> <guide link="/doc/en/mysql-howto.xml"> <title>MySQL Startup Guide</title> @@ -23,7 +23,7 @@ <!-- See http://creativecommons.org/licenses/by-sa/2.5 --> <license/> -<version>1.0</version> +<version>1.1</version> <date>2005-08-25</date> <chapter> @@ -359,7 +359,7 @@ <p> This command is used to insert a record into table. table contains the MySQL table we wish to enter the information into. The table name may be followed by -the list of columns to insert data into and VALUE() contains the values you +the list of columns to insert data into and <c>VALUE()</c> contains the values you wish to insert into the table. You may omit the list of columns if you insert a value into each one and if you write the values in the same order the columns have been defined. In this case, we want to insert data into the developers @@ -390,8 +390,8 @@ </pre> <impo> -Be sure you know what data you're dealing with. It's very unsafe to use LOAD -DATA when you are uncertain of the file's contents! +Be sure you know what data you're dealing with. It's very unsafe to use <c>LOAD +DATA</c> when you are uncertain of the file's contents! </impo> <p> @@ -435,7 +435,7 @@ <p> Like <c>LOAD DATA</c>, be sure you can tell what <path>sqlfile</path> does. -<e>Failure to do so may cause your database to be compromised</e>! Another way +<e>Failure to do so may cause your database to be compromised!</e> Another way you can accomplish this is to use the <c>source</c> command. This command will run mysql commands from an sql file while in the mysql interactive mode. Here is how to source an sql file: @@ -447,7 +447,7 @@ <p> If you see a web application wanting you to run an sql file, the two above -commands can be used to accomplish that taks. We have our table setup, so how +commands can be used to accomplish that task. We have our table setup, so how do we check our fields? We do this by searching our table with queries. </p> @@ -562,7 +562,7 @@ <note> <c>GRANT</c> is considered to be the way to create a user. Later versions of -MySQL, however, do contain a <c>CREATE_USER</c> function, though GRANT is still +MySQL, however, do contain a <c>CREATE_USER</c> function, though <c>GRANT</c> is still preferred. </note> @@ -572,19 +572,20 @@ </p> <ul> - <li>ALL - Gives the all privlege control for the database</li> - <li>CREATE - Allows users to create tables</li> - <li>SELECT - Allows users to query tables</li> - <li>INSERT - Allows users to insert data into a table</li> - <li>SHOW DATABASES - Allows users to see a list of databases</li> - <li>USAGE - User has no privleges</li> - <li>GRANT OPTION - Allows users to grant privleges</li> + <li><c>ALL</c> - Gives the all privlege control for the database</li> + <li><c>CREATE</c> - Allows users to create tables</li> + <li><c>SELECT</c> - Allows users to query tables</li> + <li><c>INSERT</c> - Allows users to insert data into a table</li> + <li><c>SHOW DATABASES</c> - Allows users to see a list of databases</li> + <li><c>USAGE</c> - User has no privleges</li> + <li><c>GRANT OPTION</c> - Allows users to grant privleges</li> </ul> <note> -If you're running MySQL to communicate data to a web application, CREATE, -SELECT, INSERT (discussed here), DELETE and UPDATE (for further infomation look -up the <uri link="http://dev.mysql.com/doc/mysql/en/grant.html";> MySQL +If you're running MySQL to communicate data to a web application, <c>CREATE</c>, +<c>SELECT</c>, <c>INSERT</c> (discussed here), <c>DELETE</c> and <c>UPDATE</c> +(for further infomation look up the +<uri link="http://dev.mysql.com/doc/mysql/en/grant.html";> MySQL Reference Manual - GRANT and REVOKE Syntax</uri> section) are the only permissions you will most likely need. A lot of people make the mistake of granting all permissions when it's not really necessary. Check with the @@ -593,13 +594,13 @@ </note> <p> -For our admin user, ALL will do. For the guest user, SELECT will be sufficient -for read only access. database is the database we wish the user to have these -permissions on. In this example, gentoo is the database. The .* means all -tables. If you wanted to, you could apply per table access. user is the name of -the user and host is the hostname the user will be accessing from. In most -cases, this will be localhost. Finally, password is the user's password. Given -the information, let's go ahead and create our users. +For our admin user, ALL will do. For the guest user, <c>SELECT</c> will be +sufficient for read only access. database is the database we wish the user +to have these permissions on. In this example, gentoo is the database. The .* +means all tables. If you wanted to, you could apply per table access. user is +the name of the user and host is the hostname the user will be accessing from. +In most cases, this will be localhost. Finally, password is the user's +password. Given the information, let's go ahead and create our users. </p> <pre caption="Creating the admin and guest user"> @@ -742,7 +743,7 @@ The admin user can access the database as they please. Now sometimes, we need to get rid of user permissions. This could be anything from a problematic user to a retired employee. Let's take a look at how to disable user permissions -with the REVOKE command. +with the <c>REVOKE</c> command. </p> </body> @@ -807,7 +808,7 @@ And our problematic user is no longer able to access the gentoo database. Please note that the user was still able to login. That is because they remain in the main MySQL database. Let's take a look at how to completely remove an -account with DELETE and the MySQL user table. +account with <c>DELETE</c> and the MySQL user table. </p> </body> @@ -868,11 +869,10 @@ <p> Now that we have our information, we can get rid of the guest user. -This is done with the <c>DELETE command</c>. The format of the <c> -DELETE</c> command for our usage is as follows: +This is done with the <c>DELETE</c> command and the syntax is shown below. </p> -<pre caption="DELETE format"> +<pre caption="DELETE Syntax"> DELETE FROM table WHERE field='value'; </pre> @@ -921,19 +921,19 @@ <ul> <li> - <uri link="http://www.phpmyadmin.net/home_page/";>phpMyAdmin</uri> - Popular - php based MySQL administration tool. - </li> + <uri link="http://www.phpmyadmin.net/home_page/";>phpMyAdmin</uri> - Popular + php based MySQL administration tool. + </li> <li> - <uri - link="http://sourceforge.net/projects/mysqlnavigator/";>mysqlnavigator</uri> - - QT frontend to MySQL. - </li> + <uri + link="http://sourceforge.net/projects/mysqlnavigator/";>mysqlnavigator</uri> + - QT frontend to MySQL. + </li> <li> - <uri link="http://gmyclient.sourceforge.net/";>gmyclient</uri> - A GNOME - based MySQL client. - </li> - <li><uri link="http://www.knoda.org/";>knoda</uri> - A KDE MySQL client</li> + <uri link="http://gmyclient.sourceforge.net/";>gmyclient</uri> - A GNOME + based MySQL client. + </li> + <li><uri link="http://www.knoda.org/";>knoda</uri> - A KDE MySQL client.</li> </ul> <p> @@ -945,5 +945,4 @@ </body> </section> </chapter> - </guide> -- [email protected] mailing list
