Changeset 9dcba70 for content/databases


Ignore:
Timestamp:
09/07/2003 02:14:01 PM (21 years ago)
Author:
Larry Lawrence <larry@…>
Branches:
10.0, 10.1, 11.0, 11.1, 11.2, 11.3, 12.0, 12.1, 6.0, 6.1, 6.2, 6.2.0, 6.2.0-rc1, 6.2.0-rc2, 6.3, 6.3-rc1, 6.3-rc2, 6.3-rc3, 7.10, 7.4, 7.5, 7.6, 7.6-blfs, 7.6-systemd, 7.7, 7.8, 7.9, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, basic, bdubbs/svn, elogind, gnome, kde5-13430, kde5-14269, kde5-14686, kea, ken/TL2024, ken/inkscape-core-mods, ken/tuningfonts, krejzi/svn, lazarus, lxqt, nosym, perl-modules, plabs/newcss, plabs/python-mods, python3.11, qt5new, rahul/power-profiles-daemon, renodr/vulkan-addition, systemd-11177, systemd-13485, trunk, upgradedb, v5_0, v5_0-pre1, v5_1, v5_1-pre1, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal
Children:
03973ca6
Parents:
ef0e45e4
Message:

Igor's patches for nano, pciutils, GTK2 and MySQL

git-svn-id: svn://svn.linuxfromscratch.org/BLFS/trunk/BOOK@1039 af4574ff-66df-0310-9fd7-8a98e5e911e0

File:
1 edited

Legend:

Unmodified
Added
Removed

  • content/databases/mysql/mysql-config.xml

    ref0e45e4 r9dcba70  
    11<sect2>
    2 <title>Configuring mysql</title>
     2<title>Configuring MySQL</title>
    33
    44<sect3>
    … …  
    1313
    1414<para>There are several default configurations file available in
    15 <filename>/usr/share/mysql</filename> which you can use.</para>
     15<filename class="directory">/usr/share/mysql</filename> which you can use.</para>
    1616
    17 <screen><userinput>cp /usr/share/mysql/my-medium.cnf /etc/my.cnf</userinput></screen>
     17<screen><userinput><command>cp /usr/share/mysql/my-medium.cnf /etc/my.cnf</command>
     18</userinput></screen>
    1819
    1920<para>We can now install a database and change the ownership to the
    2021unpriviledged user and group.</para>
    2122
    22 <screen><userinput>mysql_install_db
    23 chown -R mysql:mysql /var/lib/mysql</userinput></screen>
     23<screen><userinput><command>mysql_install_db
     24chown -R mysql:mysql /var/lib/mysql</command></userinput></screen>
    2425
    2526<para>Further configuration requires that the mysql server be running:</para>
    2627
    27 <screen><userinput>safe_mysqld 2&gt;&amp;1 &gt;/dev/null &amp;</userinput></screen>
     28<screen><userinput><command>mysqld_safe --user=mysql 2&gt;&amp;1 &gt;/dev/null &amp;</command>
     29</userinput></screen>
    2830
    2931<para>A default installation, does not setup a password for the administrator.
    30 So here we will login and set one.  We strongly suggest changing
     32So here we will login and set one. We strongly suggest changing
    3133'new-password' to your own.</para>
    3234
    33 <screen><userinput>mysql -uroot mysql</userinput>
     35<screen><userinput><command>mysql -uroot mysql
    3436Welcome to the MySQL monitor.  Commands end with ; or \g.
    3537Your MySQL connection id is 2 to server version: 3.23.51-log
    … …  
    3739Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    3840
    39 mysql&gt; <userinput>UPDATE user SET password=password('new-password') WHERE user='root';</userinput>
     41mysql&gt; UPDATE user SET password=password('new-password') WHERE user='root';
    4042Query OK, 2 rows affected (0.00 sec)
    4143Rows matched: 2  Changed: 2  Warnings: 0
    4244
    43 mysql&gt; <userinput>FLUSH PRIVILEGES;</userinput>
     45mysql&gt; FLUSH PRIVILEGES;
    4446Query OK, 0 rows affected (0.00 sec)
    4547
    46 mysql&gt; <userinput>EXIT;</userinput>
     48mysql&gt; EXIT;
    4749bye
    48 </screen>
     50</command></userinput></screen>
    4951
    5052<para>Now that we are done with the configuration of the server, we can
    5153shut it down.</para>
    5254
    53 <screen><userinput>kill `pidof -x safe_mysqld mysqld`</userinput></screen>
     55<screen><userinput><command>kill `pidof -x mysqld_safe mysqld`</command></userinput></screen>
    5456
    5557
    5658<sect4>
    57 <title>mysql init.d script</title>
     59<title>MySQL init.d script</title>
    5860
    59 <para>To automate the running of mysql, use the following command to create
     61<para>To automate the running of MySQL, use the following command to create
    6062the init.d script:</para>
    6163
    62 <screen><userinput>cat &gt; /etc/rc.d/init.d/mysql &lt;&lt; "EOF"</userinput>
     64<screen><userinput><command>cat &gt; /etc/rc.d/init.d/mysql &lt;&lt; "EOF"
    6365#!/bin/bash
    6466# Begin $rc_base/init.d/
    … …  
    7375        start)
    7476                echo "Starting MySQL daemon..."
    75                 /usr/bin/safe_mysqld 2&gt;&amp;1 &gt;/dev/null &amp;
     77                /usr/bin/mysqld_safe --user=mysql 2&gt;&amp;1 &gt;/dev/null &amp;
    7678                evaluate_retval
    7779                ;;
    … …  
    99101
    100102# End $rc_base/init.d/
    101 <userinput>EOF
    102 chmod 755 /etc/rc.d/init.d/mysql</userinput></screen>
     103EOF
     104chmod 755 /etc/rc.d/init.d/mysql</command></userinput></screen>
    103105
    104106<para>Create the symbolic links to this file in the relevant
    105 <filename>rc.d</filename> directory
     107<filename class="directory">rc.d</filename> directory
    106108with the following commands:</para>
    107109
    108 <screen><userinput>cd /etc/rc.d/init.d &amp;&amp;
     110<screen><userinput><command>cd /etc/rc.d/init.d &amp;&amp;
    109111ln -sf ../init.d/mysql ../rc0.d/K26mysql &amp;&amp;
    110112ln -sf ../init.d/mysql ../rc1.d/K26mysql &amp;&amp;
    … …  
    113115ln -sf ../init.d/mysql ../rc4.d/S34mysql &amp;&amp;
    114116ln -sf ../init.d/mysql ../rc5.d/S34mysql &amp;&amp;
    115 ln -sf ../init.d/mysql ../rc6.d/K26mysql</userinput></screen>
     117ln -sf ../init.d/mysql ../rc6.d/K26mysql</command></userinput></screen>
    116118
    117119</sect4>
    … …  
    120122
    121123</sect2>
    122 
Note: See TracChangeset for help on using the changeset viewer.