| List: | Commits | « Previous MessageNext Message » | |
| From: | mcbrown | Date: | August 30 2007 6:03pm |
| Subject: | svn commit - mysqldoc@docsrva: r7606 - in trunk: refman-5.0 refman-5.1 refman-5.2 | ||
| View as plain text | |||
Author: mcbrown Date: 2007-08-30 18:03:05 +0200 (Thu, 30 Aug 2007) New Revision: 7606 Log: Docs Bug #20653 Modified: trunk/refman-5.0/installing-cs.xml trunk/refman-5.1/installing.xml trunk/refman-5.2/installing.xml Modified: trunk/refman-5.0/installing-cs.xml =================================================================== --- trunk/refman-5.0/installing-cs.xml 2007-08-30 15:05:07 UTC (rev 7605) +++ trunk/refman-5.0/installing-cs.xml 2007-08-30 16:03:05 UTC (rev 7606) Changed blocks: 3, Lines Added: 3, Lines Deleted: 32; 2572 bytes @@ -12464,33 +12464,6 @@ </para> <para> - The other way to assign passwords to the anonymous accounts is - by using <literal>UPDATE</literal> to modify the - <literal>user</literal> table directly. Connect to the server as - <literal>root</literal> and issue an <literal>UPDATE</literal> - statement that assigns a value to the - <literal>Password</literal> column of the appropriate - <literal>user</literal> table records. The procedure is the same - for Windows and Unix. The following <literal>UPDATE</literal> - statement assigns a password to both anonymous accounts at once: - </para> - -<programlisting> -shell> <userinput>mysql -u root</userinput> -mysql> <userinput>UPDATE mysql.user SET Password = PASSWORD('<replaceable>newpwd</replaceable>')</userinput> - -> <userinput>WHERE User = '';</userinput> -mysql> <userinput>FLUSH PRIVILEGES;</userinput> -</programlisting> - - <para> - After you update the passwords in the <literal>user</literal> - table directly using <literal>UPDATE</literal>, you must tell - the server to re-read the grant tables with <literal>FLUSH - PRIVILEGES</literal>. Otherwise, the change goes unnoticed until - you restart the server. - </para> - - <para> <emphasis role="bold">Anonymous Account Removal</emphasis> </para> @@ -12501,12 +12474,11 @@ <programlisting> shell> <userinput>mysql -u root</userinput> -mysql> <userinput>DELETE FROM mysql.user WHERE User = '';</userinput> -mysql> <userinput>FLUSH PRIVILEGES;</userinput> +mysql> <userinput>DROP USER ''; </programlisting> <para> - The <literal>DELETE</literal> statement applies both to Windows + The <literal>DROP</literal> statement applies both to Windows and to Unix. On Windows, if you want to remove only the anonymous account that has the same privileges as <literal>root</literal>, do this instead: @@ -12514,8 +12486,7 @@ <programlisting> shell> <userinput>mysql -u root</userinput> -mysql> <userinput>DELETE FROM mysql.user WHERE Host='localhost' AND User='';</userinput> -mysql> <userinput>FLUSH PRIVILEGES;</userinput> +mysql> <userinput>DROP USER ''@'localhost';</userinput> </programlisting> <para> Modified: trunk/refman-5.1/installing.xml =================================================================== --- trunk/refman-5.1/installing.xml 2007-08-30 15:05:07 UTC (rev 7605) +++ trunk/refman-5.1/installing.xml 2007-08-30 16:03:05 UTC (rev 7606) Changed blocks: 3, Lines Added: 3, Lines Deleted: 32; 2575 bytes @@ -11828,33 +11828,6 @@ </para> <para> - The other way to assign passwords to the anonymous accounts is - by using <literal>UPDATE</literal> to modify the - <literal>user</literal> table directly. Connect to the server as - <literal>root</literal> and issue an <literal>UPDATE</literal> - statement that assigns a value to the - <literal>Password</literal> column of the appropriate - <literal>user</literal> table records. The procedure is the same - for Windows and Unix. The following <literal>UPDATE</literal> - statement assigns a password to both anonymous accounts at once: - </para> - -<programlisting> -shell> <userinput>mysql -u root</userinput> -mysql> <userinput>UPDATE mysql.user SET Password = PASSWORD('<replaceable>newpwd</replaceable>')</userinput> - -> <userinput>WHERE User = '';</userinput> -mysql> <userinput>FLUSH PRIVILEGES;</userinput> -</programlisting> - - <para> - After you update the passwords in the <literal>user</literal> - table directly using <literal>UPDATE</literal>, you must tell - the server to re-read the grant tables with <literal>FLUSH - PRIVILEGES</literal>. Otherwise, the change goes unnoticed until - you restart the server. - </para> - - <para> <emphasis role="bold">Anonymous Account Removal</emphasis> </para> @@ -11865,12 +11838,11 @@ <programlisting> shell> <userinput>mysql -u root</userinput> -mysql> <userinput>DELETE FROM mysql.user WHERE User = '';</userinput> -mysql> <userinput>FLUSH PRIVILEGES;</userinput> +mysql> <userinput>DROP USER '';</userinput> </programlisting> <para> - The <literal>DELETE</literal> statement applies both to Windows + The <literal>DROP</literal> statement applies both to Windows and to Unix. On Windows, if you want to remove only the anonymous account that has the same privileges as <literal>root</literal>, do this instead: @@ -11878,8 +11850,7 @@ <programlisting> shell> <userinput>mysql -u root</userinput> -mysql> <userinput>DELETE FROM mysql.user WHERE Host='localhost' AND User='';</userinput> -mysql> <userinput>FLUSH PRIVILEGES;</userinput> +mysql> <userinput>DROP USER ''@'localhost';</userinput> </programlisting> <para> Modified: trunk/refman-5.2/installing.xml =================================================================== --- trunk/refman-5.2/installing.xml 2007-08-30 15:05:07 UTC (rev 7605) +++ trunk/refman-5.2/installing.xml 2007-08-30 16:03:05 UTC (rev 7606) Changed blocks: 3, Lines Added: 3, Lines Deleted: 32; 2575 bytes @@ -11802,33 +11802,6 @@ </para> <para> - The other way to assign passwords to the anonymous accounts is - by using <literal>UPDATE</literal> to modify the - <literal>user</literal> table directly. Connect to the server as - <literal>root</literal> and issue an <literal>UPDATE</literal> - statement that assigns a value to the - <literal>Password</literal> column of the appropriate - <literal>user</literal> table records. The procedure is the same - for Windows and Unix. The following <literal>UPDATE</literal> - statement assigns a password to both anonymous accounts at once: - </para> - -<programlisting> -shell> <userinput>mysql -u root</userinput> -mysql> <userinput>UPDATE mysql.user SET Password = PASSWORD('<replaceable>newpwd</replaceable>')</userinput> - -> <userinput>WHERE User = '';</userinput> -mysql> <userinput>FLUSH PRIVILEGES;</userinput> -</programlisting> - - <para> - After you update the passwords in the <literal>user</literal> - table directly using <literal>UPDATE</literal>, you must tell - the server to re-read the grant tables with <literal>FLUSH - PRIVILEGES</literal>. Otherwise, the change goes unnoticed until - you restart the server. - </para> - - <para> <emphasis role="bold">Anonymous Account Removal</emphasis> </para> @@ -11839,12 +11812,11 @@ <programlisting> shell> <userinput>mysql -u root</userinput> -mysql> <userinput>DELETE FROM mysql.user WHERE User = '';</userinput> -mysql> <userinput>FLUSH PRIVILEGES;</userinput> +mysql> <userinput>DROP USER '';</userinput> </programlisting> <para> - The <literal>DELETE</literal> statement applies both to Windows + The <literal>DROP</literal> statement applies both to Windows and to Unix. On Windows, if you want to remove only the anonymous account that has the same privileges as <literal>root</literal>, do this instead: @@ -11852,8 +11824,7 @@ <programlisting> shell> <userinput>mysql -u root</userinput> -mysql> <userinput>DELETE FROM mysql.user WHERE Host='localhost' AND User='';</userinput> -mysql> <userinput>FLUSH PRIVILEGES;</userinput> +mysql> <userinput>DROP USER ''@'localhost';</userinput> </programlisting> <para>
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r7606 - in trunk: refman-5.0 refman-5.1 refman-5.2 | mcbrown | 30 Aug |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.453 sec. using MySQL 5.1.14-beta-log