r2966 - trunk/BOOK/content/databases

igor at linuxfromscratch.org igor at linuxfromscratch.org
Thu Nov 18 21:57:17 PST 2004


Author: igor
Date: 2004-11-18 22:57:16 -0700 (Thu, 18 Nov 2004)
New Revision: 2966

Modified:
   trunk/BOOK/content/databases/mysql.xml
Log:
Few corrections to MySQL configuration.

Modified: trunk/BOOK/content/databases/mysql.xml
===================================================================
--- trunk/BOOK/content/databases/mysql.xml	2004-11-19 05:25:15 UTC (rev 2965)
+++ trunk/BOOK/content/databases/mysql.xml	2004-11-19 05:57:16 UTC (rev 2966)
@@ -71,8 +71,8 @@
     --libexecdir=/usr/sbin --localstatedir=/srv/mysql \
     --enable-thread-safe-client --enable-assembler \
     --enable-local-infile --with-named-thread-libs=-lpthread \
-    --with-unix-socket-path=/var/run/mysql --without-debug \
-    --without-bench --without-readline &&
+    --with-unix-socket-path=/var/run/mysql/mysql.sock
+    --without-debug --without-bench --without-readline &&
 make testdir=/usr/lib/mysql/mysql-test &&
 make testdir=/usr/lib/mysql/mysql-test install &&
 cd /usr/lib &&
@@ -157,37 +157,18 @@
 <para>You can now install a database and change the ownership to the
 unprivileged user and group.</para>
 
-<screen><userinput><command>mysql_install_db &&
-chown -R mysql:mysql /srv/mysql</command></userinput></screen>
+<screen><userinput><command>mysql_install_db --user=mysql</command></userinput></screen>
 
 <para>Further configuration requires that the 
 <application>My<acronym>SQL</acronym></application> server be running:</para>
 
-<screen><userinput><command>mysqld_safe --user=mysql 2>&1 >/dev/null &</command></userinput></screen>
+<screen><userinput><command>install -o mysql -d /var/run/mysql &&
+mysqld_safe --user=mysql 2>&1 >/dev/null &</command></userinput></screen>
 
 <para>A default installation does not setup a password for the administrator, 
 so use the following command to set one. Replace 
 <replaceable>[new-password]</replaceable> with your own.</para>
 
-<!--
-<screen><userinput><command>mysql -uroot mysql</command></userinput>
-Welcome to the MySQL monitor.  Commands end with ; or \g.
-Your MySQL connection id is 2 to server version: 3.23.51-log
-
-Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
-
-<prompt>mysql></prompt> <userinput><command>UPDATE user SET password=password('<replaceable>new-password</replaceable>') WHERE user='root';</command></userinput>
-Query OK, 2 rows affected (0.00 sec)
-Rows matched: 2  Changed: 2  Warnings: 0
-
-<prompt>mysql></prompt> <userinput><command>FLUSH PRIVILEGES;</command></userinput>
-Query OK, 0 rows affected (0.00 sec)
-
-<prompt>mysql></prompt> <userinput><command>EXIT;</command></userinput>
-bye
-</screen>
--->
-
 <screen><userinput><command>mysqladmin -u root password <replaceable>[new-password]</replaceable></command></userinput></screen>
 
 <para>Configuration of the server is now finished. Shut the server down




More information about the blfs-book mailing list