Author: paul
Date: 2008-05-19 21:11:01 +0200 (Mon, 19 May 2008)
New Revision: 10772
Log:
r31505@frost: paul | 2008-05-19 13:33:44 -0500
Update Windows instructions for resetting root password (Bug#36476)
Modified:
trunk/refman-4.1/errors-problems.xml
trunk/refman-5.0/errors-problems.xml
trunk/refman-5.1/errors-problems-core.xml
trunk/refman-6.0/errors-problems.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31491
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31325
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31505
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31325
Modified: trunk/refman-4.1/errors-problems.xml
===================================================================
--- trunk/refman-4.1/errors-problems.xml 2008-05-19 15:56:53 UTC (rev 10771)
+++ trunk/refman-4.1/errors-problems.xml 2008-05-19 19:11:01 UTC (rev 10772)
Changed blocks: 6, Lines Added: 40, Lines Deleted: 24; 4866 bytes
@@ -2717,15 +2717,27 @@
<listitem>
<para>
- Create a text file and place the following command
- within it on a single line:
+ Create a text file and place the following statements in
+ it. Replace the password with the password that you want
+ to use.
</para>
<programlisting>
-SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
+UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
+FLUSH PRIVILEGES;
</programlisting>
<para>
+ The <literal>UPDATE</literal> and
+ <literal>FLUSH</literal> statements each must be written
+ on a single line. The <literal>UPDATE</literal>
+ statement resets the password for all existing
+ <literal>root</literal> accounts, and the
+ <literal>FLUSH</literal> statement tells the server to
+ reload the grant tables into memory.
+ </para>
+
+ <para>
Save the file with any name. For this example, the file
will be <filename>C:\mysql-init.txt</filename>.
</para>
@@ -2733,7 +2745,7 @@
<listitem>
<para>
- Open a console window to get to the DOS command prompt:
+ Open a console window to get to the command prompt:
</para>
<programlisting>
@@ -2743,14 +2755,14 @@
<listitem>
<para>
- We are assuming that you installed MySQL to
+ We assume that you installed MySQL to
<filename>C:\mysql</filename>. If you installed MySQL to
another location, adjust the following commands
accordingly.
</para>
<para>
- At the DOS command prompt, execute this command:
+ At the command prompt, execute this command:
</para>
<programlisting>
@@ -2758,17 +2770,16 @@
</programlisting>
<para>
- The contents of the file named by the
- <option>--init-file</option> option are executed at
- server startup, changing the <literal>root</literal>
+ The server executes the contents of the file named by
+ the <option>--init-file</option> option at server
+ startup, changing each <literal>root</literal> account
password.
</para>
- </listitem>
- <listitem>
<para>
- After the server has started successfully, delete
- <filename>C:\mysql-init.txt</filename>.
+ You can also add the <option>--console</option> option
+ to the command if you want server output to appear in
+ the console window rather than in a log file.
</para>
<para>
@@ -2802,21 +2813,27 @@
<listitem>
<para>
- Stop the MySQL server, then restart it in normal mode
- again. If you run the server as a service, start it from
- the Windows Services window. If you start the server
- manually, use whatever command you normally use.
+ After the server has started successfully, delete
+ <filename>C:\mysql-init.txt</filename>.
</para>
</listitem>
<listitem>
<para>
- You should be able to connect using the new password.
+ Stop the MySQL server, then restart it in normal mode
+ again. If you run the server as a service, start it from
+ the Windows Services window. If you start the server
+ manually, use whatever command you normally use.
</para>
</listitem>
</orderedlist>
+ <para>
+ You should now be able to connect as <literal>root</literal>
+ using the new password.
+ </para>
+
</section>
<section id="resetting-permissions-unix">
@@ -2980,14 +2997,13 @@
</para>
</listitem>
- <listitem>
- <para>
- You should be able to connect using the new password.
- </para>
- </listitem>
-
</orderedlist>
+ <para>
+ You should now be able to connect as <literal>root</literal>
+ using the new password.
+ </para>
+
</section>
</section>
Modified: trunk/refman-5.0/errors-problems.xml
===================================================================
--- trunk/refman-5.0/errors-problems.xml 2008-05-19 15:56:53 UTC (rev 10771)
+++ trunk/refman-5.0/errors-problems.xml 2008-05-19 19:11:01 UTC (rev 10772)
Changed blocks: 6, Lines Added: 40, Lines Deleted: 24; 4866 bytes
@@ -2634,15 +2634,27 @@
<listitem>
<para>
- Create a text file and place the following command
- within it on a single line:
+ Create a text file and place the following statements in
+ it. Replace the password with the password that you want
+ to use.
</para>
<programlisting>
-SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
+UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
+FLUSH PRIVILEGES;
</programlisting>
<para>
+ The <literal>UPDATE</literal> and
+ <literal>FLUSH</literal> statements each must be written
+ on a single line. The <literal>UPDATE</literal>
+ statement resets the password for all existing
+ <literal>root</literal> accounts, and the
+ <literal>FLUSH</literal> statement tells the server to
+ reload the grant tables into memory.
+ </para>
+
+ <para>
Save the file with any name. For this example, the file
will be <filename>C:\mysql-init.txt</filename>.
</para>
@@ -2650,7 +2662,7 @@
<listitem>
<para>
- Open a console window to get to the DOS command prompt:
+ Open a console window to get to the command prompt:
</para>
<programlisting>
@@ -2660,14 +2672,14 @@
<listitem>
<para>
- We are assuming that you installed MySQL to
+ We assume that you installed MySQL to
<filename>C:\mysql</filename>. If you installed MySQL to
another location, adjust the following commands
accordingly.
</para>
<para>
- At the DOS command prompt, execute this command:
+ At the command prompt, execute this command:
</para>
<programlisting>
@@ -2675,17 +2687,16 @@
</programlisting>
<para>
- The contents of the file named by the
- <option>--init-file</option> option are executed at
- server startup, changing the <literal>root</literal>
+ The server executes the contents of the file named by
+ the <option>--init-file</option> option at server
+ startup, changing each <literal>root</literal> account
password.
</para>
- </listitem>
- <listitem>
<para>
- After the server has started successfully, delete
- <filename>C:\mysql-init.txt</filename>.
+ You can also add the <option>--console</option> option
+ to the command if you want server output to appear in
+ the console window rather than in a log file.
</para>
<para>
@@ -2719,21 +2730,27 @@
<listitem>
<para>
- Stop the MySQL server, then restart it in normal mode
- again. If you run the server as a service, start it from
- the Windows Services window. If you start the server
- manually, use whatever command you normally use.
+ After the server has started successfully, delete
+ <filename>C:\mysql-init.txt</filename>.
</para>
</listitem>
<listitem>
<para>
- You should be able to connect using the new password.
+ Stop the MySQL server, then restart it in normal mode
+ again. If you run the server as a service, start it from
+ the Windows Services window. If you start the server
+ manually, use whatever command you normally use.
</para>
</listitem>
</orderedlist>
+ <para>
+ You should now be able to connect as <literal>root</literal>
+ using the new password.
+ </para>
+
</section>
<section id="resetting-permissions-unix">
@@ -2897,14 +2914,13 @@
</para>
</listitem>
- <listitem>
- <para>
- You should be able to connect using the new password.
- </para>
- </listitem>
-
</orderedlist>
+ <para>
+ You should now be able to connect as <literal>root</literal>
+ using the new password.
+ </para>
+
</section>
</section>
Modified: trunk/refman-5.1/errors-problems-core.xml
===================================================================
--- trunk/refman-5.1/errors-problems-core.xml 2008-05-19 15:56:53 UTC (rev 10771)
+++ trunk/refman-5.1/errors-problems-core.xml 2008-05-19 19:11:01 UTC (rev 10772)
Changed blocks: 6, Lines Added: 40, Lines Deleted: 24; 4881 bytes
@@ -2637,15 +2637,27 @@
<listitem>
<para>
- Create a text file and place the following command
- within it on a single line:
+ Create a text file and place the following statements in
+ it. Replace the password with the password that you want
+ to use.
</para>
<programlisting>
-SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
+UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
+FLUSH PRIVILEGES;
</programlisting>
<para>
+ The <literal>UPDATE</literal> and
+ <literal>FLUSH</literal> statements each must be written
+ on a single line. The <literal>UPDATE</literal>
+ statement resets the password for all existing
+ <literal>root</literal> accounts, and the
+ <literal>FLUSH</literal> statement tells the server to
+ reload the grant tables into memory.
+ </para>
+
+ <para>
Save the file with any name. For this example, the file
will be <filename>C:\mysql-init.txt</filename>.
</para>
@@ -2653,7 +2665,7 @@
<listitem>
<para>
- Open a console window to get to the DOS command prompt:
+ Open a console window to get to the command prompt:
</para>
<programlisting>
@@ -2663,14 +2675,14 @@
<listitem>
<para>
- We are assuming that you installed MySQL to
+ We assume that you installed MySQL to
<filename>C:\mysql</filename>. If you installed MySQL to
another location, adjust the following commands
accordingly.
</para>
<para>
- At the DOS command prompt, execute this command:
+ At the command prompt, execute this command:
</para>
<programlisting>
@@ -2678,17 +2690,16 @@
</programlisting>
<para>
- The contents of the file named by the
- <option>--init-file</option> option are executed at
- server startup, changing the <literal>root</literal>
+ The server executes the contents of the file named by
+ the <option>--init-file</option> option at server
+ startup, changing each <literal>root</literal> account
password.
</para>
- </listitem>
- <listitem>
<para>
- After the server has started successfully, delete
- <filename>C:\mysql-init.txt</filename>.
+ You can also add the <option>--console</option> option
+ to the command if you want server output to appear in
+ the console window rather than in a log file.
</para>
<para>
@@ -2722,21 +2733,27 @@
<listitem>
<para>
- Stop the MySQL server, then restart it in normal mode
- again. If you run the server as a service, start it from
- the Windows Services window. If you start the server
- manually, use whatever command you normally use.
+ After the server has started successfully, delete
+ <filename>C:\mysql-init.txt</filename>.
</para>
</listitem>
<listitem>
<para>
- You should be able to connect using the new password.
+ Stop the MySQL server, then restart it in normal mode
+ again. If you run the server as a service, start it from
+ the Windows Services window. If you start the server
+ manually, use whatever command you normally use.
</para>
</listitem>
</orderedlist>
+ <para>
+ You should now be able to connect as <literal>root</literal>
+ using the new password.
+ </para>
+
</section>
<section id="resetting-permissions-unix">
@@ -2900,14 +2917,13 @@
</para>
</listitem>
- <listitem>
- <para>
- You should be able to connect using the new password.
- </para>
- </listitem>
-
</orderedlist>
+ <para>
+ You should now be able to connect as <literal>root</literal>
+ using the new password.
+ </para>
+
</section>
</section>
Modified: trunk/refman-6.0/errors-problems.xml
===================================================================
--- trunk/refman-6.0/errors-problems.xml 2008-05-19 15:56:53 UTC (rev 10771)
+++ trunk/refman-6.0/errors-problems.xml 2008-05-19 19:11:01 UTC (rev 10772)
Changed blocks: 6, Lines Added: 40, Lines Deleted: 24; 4866 bytes
@@ -2636,15 +2636,27 @@
<listitem>
<para>
- Create a text file and place the following command
- within it on a single line:
+ Create a text file and place the following statements in
+ it. Replace the password with the password that you want
+ to use.
</para>
<programlisting>
-SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
+UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
+FLUSH PRIVILEGES;
</programlisting>
<para>
+ The <literal>UPDATE</literal> and
+ <literal>FLUSH</literal> statements each must be written
+ on a single line. The <literal>UPDATE</literal>
+ statement resets the password for all existing
+ <literal>root</literal> accounts, and the
+ <literal>FLUSH</literal> statement tells the server to
+ reload the grant tables into memory.
+ </para>
+
+ <para>
Save the file with any name. For this example, the file
will be <filename>C:\mysql-init.txt</filename>.
</para>
@@ -2652,7 +2664,7 @@
<listitem>
<para>
- Open a console window to get to the DOS command prompt:
+ Open a console window to get to the command prompt:
</para>
<programlisting>
@@ -2662,14 +2674,14 @@
<listitem>
<para>
- We are assuming that you installed MySQL to
+ We assume that you installed MySQL to
<filename>C:\mysql</filename>. If you installed MySQL to
another location, adjust the following commands
accordingly.
</para>
<para>
- At the DOS command prompt, execute this command:
+ At the command prompt, execute this command:
</para>
<programlisting>
@@ -2677,17 +2689,16 @@
</programlisting>
<para>
- The contents of the file named by the
- <option>--init-file</option> option are executed at
- server startup, changing the <literal>root</literal>
+ The server executes the contents of the file named by
+ the <option>--init-file</option> option at server
+ startup, changing each <literal>root</literal> account
password.
</para>
- </listitem>
- <listitem>
<para>
- After the server has started successfully, delete
- <filename>C:\mysql-init.txt</filename>.
+ You can also add the <option>--console</option> option
+ to the command if you want server output to appear in
+ the console window rather than in a log file.
</para>
<para>
@@ -2721,21 +2732,27 @@
<listitem>
<para>
- Stop the MySQL server, then restart it in normal mode
- again. If you run the server as a service, start it from
- the Windows Services window. If you start the server
- manually, use whatever command you normally use.
+ After the server has started successfully, delete
+ <filename>C:\mysql-init.txt</filename>.
</para>
</listitem>
<listitem>
<para>
- You should be able to connect using the new password.
+ Stop the MySQL server, then restart it in normal mode
+ again. If you run the server as a service, start it from
+ the Windows Services window. If you start the server
+ manually, use whatever command you normally use.
</para>
</listitem>
</orderedlist>
+ <para>
+ You should now be able to connect as <literal>root</literal>
+ using the new password.
+ </para>
+
</section>
<section id="resetting-permissions-unix">
@@ -2899,14 +2916,13 @@
</para>
</listitem>
- <listitem>
- <para>
- You should be able to connect using the new password.
- </para>
- </listitem>
-
</orderedlist>
+ <para>
+ You should now be able to connect as <literal>root</literal>
+ using the new password.
+ </para>
+
</section>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10772 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul | 19 May |
