Author: jstephens
Date: 2008-03-17 19:32:05 +0100 (Mon, 17 Mar 2008)
New Revision: 10278
Log:
windows-post-installation:
Explained some rasons why sample output might differ from shown
Fixed sample output to align with server versions
(Stefan/user comments)
Modified:
trunk/refman-4.1/installing.xml
trunk/refman-5.0/installing-cs-core.xml
trunk/refman-5.1/installing-core.xml
trunk/refman-6.0/installing-core.xml
Modified: trunk/refman-4.1/installing.xml
===================================================================
--- trunk/refman-4.1/installing.xml 2008-03-17 16:59:52 UTC (rev 10277)
+++ trunk/refman-4.1/installing.xml 2008-03-17 18:32:05 UTC (rev 10278)
Changed blocks: 2, Lines Added: 66, Lines Deleted: 2; 3190 bytes
@@ -10247,8 +10247,6 @@
| help_relation |
| help_topic |
| host |
-| proc |
-| procs_priv |
| tables_priv |
| time_zone |
| time_zone_leap_second |
@@ -10267,6 +10265,72 @@
</programlisting>
<para>
+ You may need to specify a different directory from the one
+ shown; if you used the Windows Installation Wizard, then the
+ default directory is <filename>C:\Program Files\MySQL\MySQL
+ Server ¤t-series;</filename>, and the
+ <command>mysql</command> and <command>mysqlshow</command> client
+ programs are in <filename>C:\Program Files\MySQL\MySQL Server
+ ¤t-series;\bin</filename>. See
+ <xref linkend="windows-install-wizard"/>, for more information.
+ </para>
+
+ <para>
+ If you have already secured the initial MySQL accounts, you may
+ need to use the <option>-u</option> and <option>-p</option>
+ options to supply a username and password to the
+ <command>mysqlshow</command> and <command>mysql</command> client
+ programs; otherwise the programs may fail with an error, or you
+ may not be able to view all databases. For example, if you have
+ assigned the password <quote>secretpass</quote> to the MySQL
+ <literal>root</literal> account, then you can invoke
+ <command>mysqlshow</command>and <command>mysql</command> as
+ shown here:
+
+<programlisting>
+C:\> <userinput>C:\mysql\bin\mysqlshow -uroot -psecretpass</userinput>
++-----------+
+| Databases |
++-----------+
+| mysql |
+| test |
++-----------+
+
+C:\> <userinput>C:\mysql\bin\mysqlshow -uroot -psecretpass mysql</userinput>
+Database: mysql
++---------------------------+
+| Tables |
++---------------------------+
+| columns_priv |
+| db |
+| func |
+| help_category |
+| help_keyword |
+| help_relation |
+| help_topic |
+| host |
+| tables_priv |
+| time_zone |
+| time_zone_leap_second |
+| time_zone_name |
+| time_zone_transition |
+| time_zone_transition_type |
+| user |
++---------------------------+
+
+C:\> <userinput>C:\mysql\bin\mysql -uroot -psecretpass -e "SELECT Host,Db,User FROM db" mysql</userinput>
++------+-------+------+
+| host | db | user |
++------+-------+------+
+| % | test% | |
++------+-------+------+
+</programlisting>
+
+ For more information about these programs, see
+ <xref linkend="mysqlshow"/>, and <xref linkend="mysql"/>.
+ </para>
+
+ <para>
If you are running a version of Windows that supports services
and you want the MySQL server to run automatically when Windows
starts, see <xref linkend="windows-start-service"/>.
Modified: trunk/refman-5.0/installing-cs-core.xml
===================================================================
--- trunk/refman-5.0/installing-cs-core.xml 2008-03-17 16:59:52 UTC (rev 10277)
+++ trunk/refman-5.0/installing-cs-core.xml 2008-03-17 18:32:05 UTC (rev 10278)
Changed blocks: 2, Lines Added: 76, Lines Deleted: 6; 3507 bytes
@@ -10800,12 +10800,13 @@
<programlisting>
C:\> <userinput>C:\mysql\bin\mysqlshow</userinput>
-+-----------+
-| Databases |
-+-----------+
-| mysql |
-| test |
-+-----------+
++--------------------+
+| Databases |
++--------------------+
+| information_schema |
+| mysql |
+| test |
++--------------------+
C:\> <userinput>C:\mysql\bin\mysqlshow mysql</userinput>
Database: mysql
@@ -10840,6 +10841,75 @@
</programlisting>
<para>
+ You may need to specify a different directory from the one
+ shown; if you used the Windows Installation Wizard, then the
+ default directory is <filename>C:\Program Files\MySQL\MySQL
+ Server ¤t-series;</filename>, and the
+ <command>mysql</command> and <command>mysqlshow</command> client
+ programs are in <filename>C:\Program Files\MySQL\MySQL Server
+ ¤t-series;\bin</filename>. See
+ <xref linkend="windows-install-wizard"/>, for more information.
+ </para>
+
+ <para>
+ If you have already secured the initial MySQL accounts, you may
+ need to use the <option>-u</option> and <option>-p</option>
+ options to supply a username and password to the
+ <command>mysqlshow</command> and <command>mysql</command> client
+ programs; otherwise the programs may fail with an error, or you
+ may not be able to view all databases. For example, if you have
+ assigned the password <quote>secretpass</quote> to the MySQL
+ <literal>root</literal> account, then you can invoke
+ <command>mysqlshow</command>and <command>mysql</command> as
+ shown here:
+
+<programlisting>
+C:\> <userinput>C:\mysql\bin\mysqlshow -uroot -psecretpass</userinput>
++--------------------+
+| Databases |
++--------------------+
+| information_schema |
+| mysql |
+| test |
++--------------------+
+
+C:\> <userinput>C:\mysql\bin\mysqlshow -uroot -psecretpass mysql</userinput>
+Database: mysql
++---------------------------+
+| Tables |
++---------------------------+
+| columns_priv |
+| db |
+| func |
+| help_category |
+| help_keyword |
+| help_relation |
+| help_topic |
+| host |
+| proc |
+| procs_priv |
+| tables_priv |
+| time_zone |
+| time_zone_leap_second |
+| time_zone_name |
+| time_zone_transition |
+| time_zone_transition_type |
+| user |
++---------------------------+
+
+C:\> <userinput>C:\mysql\bin\mysql -uroot -psecretpass -e "SELECT Host,Db,User FROM db" mysql</userinput>
++------+-------+------+
+| host | db | user |
++------+-------+------+
+| % | test% | |
++------+-------+------+
+</programlisting>
+
+ For more information about these programs, see
+ <xref linkend="mysqlshow"/>, and <xref linkend="mysql"/>.
+ </para>
+
+ <para>
If you are running a version of Windows that supports services
and you want the MySQL server to run automatically when Windows
starts, see <xref linkend="windows-start-service"/>.
Modified: trunk/refman-5.1/installing-core.xml
===================================================================
--- trunk/refman-5.1/installing-core.xml 2008-03-17 16:59:52 UTC (rev 10277)
+++ trunk/refman-5.1/installing-core.xml 2008-03-17 18:32:05 UTC (rev 10278)
Changed blocks: 4, Lines Added: 88, Lines Deleted: 6; 4466 bytes
@@ -10130,12 +10130,13 @@
<programlisting>
C:\> <userinput>C:\mysql\bin\mysqlshow</userinput>
-+-----------+
-| Databases |
-+-----------+
-| mysql |
-| test |
-+-----------+
++--------------------+
+| Databases |
++--------------------+
+| information_schema |
+| mysql |
+| test |
++--------------------+
C:\> <userinput>C:\mysql\bin\mysqlshow mysql</userinput>
Database: mysql
@@ -10144,14 +10145,19 @@
+---------------------------+
| columns_priv |
| db |
+| event |
| func |
+| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
+| plugin |
| proc |
| procs_priv |
+| servers |
+| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
@@ -10161,6 +10167,7 @@
| user |
+---------------------------+
+
C:\> <userinput>C:\mysql\bin\mysql -e "SELECT Host,Db,User FROM db" mysql</userinput>
+------+-------+------+
| host | db | user |
@@ -10170,6 +10177,81 @@
</programlisting>
<para>
+ You may need to specify a different directory from the one
+ shown; if you used the Windows Installation Wizard, then the
+ default directory is <filename>C:\Program Files\MySQL\MySQL
+ Server ¤t-series;</filename>, and the
+ <command>mysql</command> and <command>mysqlshow</command> client
+ programs are in <filename>C:\Program Files\MySQL\MySQL Server
+ ¤t-series;\bin</filename>. See
+ <xref linkend="windows-install-wizard"/>, for more information.
+ </para>
+
+ <para>
+ If you have already secured the initial MySQL accounts, you may
+ need to use the <option>-u</option> and <option>-p</option>
+ options to supply a username and password to the
+ <command>mysqlshow</command> and <command>mysql</command> client
+ programs; otherwise the programs may fail with an error, or you
+ may not be able to view all databases. For example, if you have
+ assigned the password <quote>secretpass</quote> to the MySQL
+ <literal>root</literal> account, then you can invoke
+ <command>mysqlshow</command>and <command>mysql</command> as
+ shown here:
+
+<programlisting>
+C:\> <userinput>C:\mysql\bin\mysqlshow -uroot -psecretpass</userinput>
++--------------------+
+| Databases |
++--------------------+
+| information_schema |
+| mysql |
+| test |
++--------------------+
+
+C:\> <userinput>C:\mysql\bin\mysqlshow -uroot -psecretpass mysql</userinput>
+Database: mysql
++---------------------------+
+| Tables |
++---------------------------+
+| columns_priv |
+| db |
+| event |
+| func |
+| general_log |
+| help_category |
+| help_keyword |
+| help_relation |
+| help_topic |
+| host |
+| plugin |
+| proc |
+| procs_priv |
+| servers |
+| slow_log |
+| tables_priv |
+| time_zone |
+| time_zone_leap_second |
+| time_zone_name |
+| time_zone_transition |
+| time_zone_transition_type |
+| user |
++---------------------------+
+
+
+C:\> <userinput>C:\mysql\bin\mysql -uroot -psecretpass -e "SELECT Host,Db,User FROM db" mysql</userinput>
++------+-------+------+
+| host | db | user |
++------+-------+------+
+| % | test% | |
++------+-------+------+
+</programlisting>
+
+ For more information about these programs, see
+ <xref linkend="mysqlshow"/>, and <xref linkend="mysql"/>.
+ </para>
+
+ <para>
If you are running a version of Windows that supports services
and you want the MySQL server to run automatically when Windows
starts, see <xref linkend="windows-start-service"/>.
Modified: trunk/refman-6.0/installing-core.xml
===================================================================
--- trunk/refman-6.0/installing-core.xml 2008-03-17 16:59:52 UTC (rev 10277)
+++ trunk/refman-6.0/installing-core.xml 2008-03-17 18:32:05 UTC (rev 10278)
Changed blocks: 3, Lines Added: 86, Lines Deleted: 6; 4243 bytes
@@ -10164,12 +10164,13 @@
<programlisting>
C:\> <userinput>C:\mysql\bin\mysqlshow</userinput>
-+-----------+
-| Databases |
-+-----------+
-| mysql |
-| test |
-+-----------+
++--------------------+
+| Databases |
++--------------------+
+| information_schema |
+| mysql |
+| test |
++--------------------+
C:\> <userinput>C:\mysql\bin\mysqlshow mysql</userinput>
Database: mysql
@@ -10178,14 +10179,19 @@
+---------------------------+
| columns_priv |
| db |
+| event |
| func |
+| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
+| plugin |
| proc |
| procs_priv |
+| servers |
+| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
@@ -10204,6 +10210,80 @@
</programlisting>
<para>
+ You may need to specify a different directory from the one
+ shown; if you used the Windows Installation Wizard, then the
+ default directory is <filename>C:\Program Files\MySQL\MySQL
+ Server ¤t-series;</filename>, and the
+ <command>mysql</command> and <command>mysqlshow</command> client
+ programs are in <filename>C:\Program Files\MySQL\MySQL Server
+ ¤t-series;\bin</filename>. See
+ <xref linkend="windows-install-wizard"/>, for more information.
+ </para>
+
+ <para>
+ If you have already secured the initial MySQL accounts, you may
+ need to use the <option>-u</option> and <option>-p</option>
+ options to supply a username and password to the
+ <command>mysqlshow</command> and <command>mysql</command> client
+ programs; otherwise the programs may fail with an error, or you
+ may not be able to view all databases. For example, if you have
+ assigned the password <quote>secretpass</quote> to the MySQL
+ <literal>root</literal> account, then you can invoke
+ <command>mysqlshow</command>and <command>mysql</command> as
+ shown here:
+
+<programlisting>
+C:\> <userinput>C:\mysql\bin\mysqlshow -uroot -psecretpass</userinput>
++--------------------+
+| Databases |
++--------------------+
+| information_schema |
+| mysql |
+| test |
++--------------------+
+
+C:\> <userinput>C:\mysql\bin\mysqlshow -uroot -psecretpass mysql</userinput>
+Database: mysql
++---------------------------+
+| Tables |
++---------------------------+
+| columns_priv |
+| db |
+| event |
+| func |
+| general_log |
+| help_category |
+| help_keyword |
+| help_relation |
+| help_topic |
+| host |
+| plugin |
+| proc |
+| procs_priv |
+| servers |
+| slow_log |
+| tables_priv |
+| time_zone |
+| time_zone_leap_second |
+| time_zone_name |
+| time_zone_transition |
+| time_zone_transition_type |
+| user |
++---------------------------+
+
+C:\> <userinput>C:\mysql\bin\mysql -uroot -psecretpass -e "SELECT Host,Db,User FROM db" mysql</userinput>
++------+-------+------+
+| host | db | user |
++------+-------+------+
+| % | test% | |
++------+-------+------+
+</programlisting>
+
+ For more information about these programs, see
+ <xref linkend="mysqlshow"/>, and <xref linkend="mysql"/>.
+ </para>
+
+ <para>
If you are running a version of Windows that supports services
and you want the MySQL server to run automatically when Windows
starts, see <xref linkend="windows-start-service"/>.
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10278 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-6.0 | jon | 17 Mar |
