List:Commits« Previous MessageNext Message »
From:jon Date:January 16 2006 4:00am
Subject:svn commit - mysqldoc@docsrva: r850 - in trunk: refman-4.1 refman-5.0 refman-5.1
View as plain text  
Author: jstephens
Date: 2006-01-16 05:00:25 +0100 (Mon, 16 Jan 2006)
New Revision: 850

Log:

Added some notes and links to Tutorial based on user feedback.



Modified:
   trunk/refman-4.1/tutorial.xml
   trunk/refman-5.0/tutorial.xml
   trunk/refman-5.1/tutorial.xml

Modified: trunk/refman-4.1/tutorial.xml
===================================================================
--- trunk/refman-4.1/tutorial.xml	2006-01-16 02:58:56 UTC (rev 849)
+++ trunk/refman-4.1/tutorial.xml	2006-01-16 04:00:25 UTC (rev 850)
@@ -145,6 +145,30 @@
       The <literal>mysql&gt;</literal> prompt tells you that
       <command>mysql</command> is ready for you to enter commands.
     </para>
+    
+    <para>
+      If you are logging in on the same machine that MySQL is running
+      on, you can omit the host, and simply use the following:
+    </para>
+    
+<programlisting>
+shell&lt; <userinput>mysql -u <replaceable>user</replaceable> -p</userinput>
+</programlisting>
+    
+    <para>
+      If, when you attempt to log in, you get an error message such as
+      <errortext>ERROR 2002 (HY000): Can't connect to local MySQL server
+        through socket '/tmp/mysql.sock' (2)</errortext>, it means that
+      that MySQL server daemon (Unix) or service (Windows) is not
+      running. Consult the administrator or see the section of 
+      <xref linkend="installing"/> that is appropriate to your operating
+      system.
+    </para>
+    
+    <para>
+      For help with other problems often encountered when trying to log
+      in, see <xref linkend="common-errors"/>.
+    </para>
 
     <para>
       Some MySQL installations allow users to connect as the anonymous
@@ -736,6 +760,16 @@
         recommended best practice is always to use the same lettercase
         that was used when the database was created.)
       </para>
+      
+      <para>
+        <emphasis role="bold">Note</emphasis>: If you get an error such
+        as <errortext>ERROR 1044 (42000): Access denied for user
+          'monty'@'localhost' to database 'menagerie'</errortext> when
+        attempting to create a database, this means that your user
+        account does not have the necessary privileges to do so. Discuss
+        this with the administrator or see 
+        <xref linkend="privilege-system"/>.
+      </para>
 
       <para>
         Creating a database does not select it for use; you must do that

Modified: trunk/refman-5.0/tutorial.xml
===================================================================
--- trunk/refman-5.0/tutorial.xml	2006-01-16 02:58:56 UTC (rev 849)
+++ trunk/refman-5.0/tutorial.xml	2006-01-16 04:00:25 UTC (rev 850)
@@ -145,6 +145,30 @@
       The <literal>mysql&gt;</literal> prompt tells you that
       <command>mysql</command> is ready for you to enter commands.
     </para>
+    
+    <para>
+      If you are logging in on the same machine that MySQL is running
+      on, you can omit the host, and simply use the following:
+    </para>
+    
+<programlisting>
+shell&lt; <userinput>mysql -u <replaceable>user</replaceable> -p</userinput>
+</programlisting>
+    
+    <para>
+      If, when you attempt to log in, you get an error message such as
+      <errortext>ERROR 2002 (HY000): Can't connect to local MySQL server
+        through socket '/tmp/mysql.sock' (2)</errortext>, it means that
+      that MySQL server daemon (Unix) or service (Windows) is not
+      running. Consult the administrator or see the section of 
+      <xref linkend="installing"/> that is appropriate to your operating
+      system.
+    </para>
+    
+    <para>
+      For help with other problems often encountered when trying to log
+      in, see <xref linkend="common-errors"/>.
+    </para>
 
     <para>
       Some MySQL installations allow users to connect as the anonymous
@@ -738,15 +762,25 @@
         recommended best practice is always to use the same lettercase
         that was used when the database was created.)
       </para>
-
+      
       <para>
+        <emphasis role="bold">Note</emphasis>: If you get an error such
+        as <errortext>ERROR 1044 (42000): Access denied for user
+          'monty'@'localhost' to database 'menagerie'</errortext> when
+        attempting to create a database, this means that your user
+        account does not have the necessary privileges to do so. Discuss
+        this with the administrator or see 
+        <xref linkend="privilege-system"/>.
+      </para>
+      
+      <para>
         Creating a database does not select it for use; you must do that
         explicitly. To make <literal>menagerie</literal> the current
         database, use this command:
       </para>
 
 <programlisting>
-mysql&gt; <userinput>USE menagerie</userinput>
+mysql&gt; <userinput>USE menagerie;</userinput>
 Database changed
 </programlisting>
 
@@ -771,11 +805,11 @@
         is <emphasis role="bold">not</emphasis> your password. If you
         want to supply your password on the command line after the
         <literal>-p</literal> option, you must do so with no intervening
-        space (for example, as <literal>-pmypassword</literal>, not as
-        <literal>-p mypassword</literal>). However, putting your
-        password on the command line is not recommended, because doing
-        so exposes it to snooping by other users logged in on your
-        machine.
+        space (for example, as <literal>-pmypassword</literal>,
+        <emphasis>not</emphasis> as <literal>-p mypassword</literal>).
+        However, putting your password on the command line is not
+        recommended, because doing so exposes it to snooping by other
+        users logged in on your machine.
       </para>
 
     </section>

Modified: trunk/refman-5.1/tutorial.xml
===================================================================
--- trunk/refman-5.1/tutorial.xml	2006-01-16 02:58:56 UTC (rev 849)
+++ trunk/refman-5.1/tutorial.xml	2006-01-16 04:00:25 UTC (rev 850)
@@ -145,6 +145,30 @@
       The <literal>mysql&gt;</literal> prompt tells you that
       <command>mysql</command> is ready for you to enter commands.
     </para>
+    
+    <para>
+      If you are logging in on the same machine that MySQL is running
+      on, you can omit the host, and simply use the following:
+    </para>
+    
+<programlisting>
+shell&lt; <userinput>mysql -u <replaceable>user</replaceable> -p</userinput>
+</programlisting>
+    
+    <para>
+      If, when you attempt to log in, you get an error message such as
+      <errortext>ERROR 2002 (HY000): Can't connect to local MySQL server
+        through socket '/tmp/mysql.sock' (2)</errortext>, it means that
+      that MySQL server daemon (Unix) or service (Windows) is not
+      running. Consult the administrator or see the section of 
+      <xref linkend="installing"/> that is appropriate to your operating
+      system.
+    </para>
+    
+    <para>
+      For help with other problems often encountered when trying to log
+      in, see <xref linkend="common-errors"/>.
+    </para>
 
     <para>
       Some MySQL installations allow users to connect as the anonymous
@@ -733,6 +757,16 @@
         recommended best practice is always to use the same lettercase
         that was used when the database was created.)
       </para>
+      
+      <para>
+        <emphasis role="bold">Note</emphasis>: If you get an error such
+        as <errortext>ERROR 1044 (42000): Access denied for user
+          'monty'@'localhost' to database 'menagerie'</errortext> when
+        attempting to create a database, this means that your user
+        account does not have the necessary privileges to do so. Discuss
+        this with the administrator or see 
+        <xref linkend="privilege-system"/>. 
+      </para>
 
       <para>
         Creating a database does not select it for use; you must do that

Thread
svn commit - mysqldoc@docsrva: r850 - in trunk: refman-4.1 refman-5.0 refman-5.1jon16 Jan