From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.43) id 1E8kF1-0005V6-7M for garchives@archives.gentoo.org; Fri, 26 Aug 2005 19:51:55 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.4/8.13.4) with SMTP id j7QJoMEm017397; Fri, 26 Aug 2005 19:50:22 GMT Received: from smtp.gentoo.org (smtp.gentoo.org [134.68.220.30]) by robin.gentoo.org (8.13.4/8.13.4) with ESMTP id j7QJoL0p032313 for ; Fri, 26 Aug 2005 19:50:21 GMT Message-Id: <200508261950.j7QJoL0p032313@robin.gentoo.org> Received: from lark.gentoo.osuosl.org ([140.211.166.177] helo=lark.gentoo.org) by smtp.gentoo.org with smtp (Exim 4.43) id 1E8kEt-0001ia-4h for gentoo-doc-cvs@lists.gentoo.org; Fri, 26 Aug 2005 19:51:47 +0000 Received: by lark.gentoo.org (sSMTP sendmail emulation); Fri, 26 Aug 2005 19:51:26 +0000 From: "Shyam Mani" Date: Fri, 26 Aug 2005 19:51:26 +0000 To: gentoo-doc-cvs@lists.gentoo.org Subject: [gentoo-doc-cvs] cvs commit: mysql-howto.xml Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-doc-cvs@gentoo.org Reply-to: docs-team@lists.gentoo.org X-Archives-Salt: 8a89165e-9c96-48d6-9abf-764b3676b816 X-Archives-Hash: 5197ce42f781c75bac561f36a574f478 fox2mike 05/08/26 19:51:26 Modified: xml/htdocs/doc/en mysql-howto.xml Log: Typo fix, s/privlege/privilege/g. Thanks to rane for reporting. Revision Changes Path 1.3 +11 -11 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.3&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.3&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.2&r2=1.3&cvsroot=gentoo Index: mysql-howto.xml =================================================================== RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-howto.xml,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- mysql-howto.xml 25 Aug 2005 07:47:00 -0000 1.2 +++ mysql-howto.xml 26 Aug 2005 19:51:26 -0000 1.3 @@ -1,6 +1,6 @@ - + MySQL Startup Guide @@ -24,7 +24,7 @@ 1.1 -2005-08-25 +2005-08-27 Getting Started With MySQL @@ -557,7 +557,7 @@ 

-GRANT [privleges] ON database.* TO '[user]'@'[host]' IDENTIFIED BY '[password]';
+GRANT [privileges] ON database.* TO '[user]'@'[host]' IDENTIFIED BY '[password]';
@@ -567,18 +567,18 @@

-First we have the privleges we wish to assign. With what we've learned so far, -here are some of the privleges you can set: +First we have the privileges we wish to assign. With what we've learned so far, +here are some of the privileges you can set:

    -
  • ALL - Gives the all privlege control for the database
    • +
  • ALL - Gives the all privilege control for the database
  • CREATE - Allows users to create tables
  • SELECT - Allows users to query tables
  • INSERT - Allows users to insert data into a table
  • SHOW DATABASES - Allows users to see a list of databases
    • -
  • USAGE - User has no privleges
    • -
  • GRANT OPTION - Allows users to grant privleges
    • +
  • USAGE - User has no privileges
    • +
  • GRANT OPTION - Allows users to grant privileges
@@ -632,7 +632,7 @@

We shall now attempt to login as the guest user. Currently, the guest user has -SELECT only privleges. This basically comes down to being able to search +SELECT only privileges. This basically comes down to being able to search and nothing more. Go ahead and login with the guest account.

@@ -759,14 +759,14 @@ 

-REVOKE [privleges] ON database.* FROM '[user]'@'[host]';
+REVOKE [privileges] ON database.* FROM '[user]'@'[host]';

Options here are explained in the GRANT command section. In this section however, we're going to deny full access to a user. Let's say we find out the guest account is causing some problems security wise. We decide to revoke all -privleges. We login as root and do the needful. +privileges. We login as root and do the needful. 




-- 
gentoo-doc-cvs@gentoo.org mailing list