[LON-CAPA-cvs] cvs: doc /build install.html

Fri, 10 May 2002 16:17:45 -0000

harris41		Fri May 10 12:17:45 2002 EDT

  Modified files:              
    /doc/build	install.html 
  Log:
  expanding and refining MySQL instructions
  
  
Index: doc/build/install.html
diff -u doc/build/install.html:1.18 doc/build/install.html:1.19

--- doc/build/install.html:1.18	Wed May  1 21:30:15 2002
+++ doc/build/install.html	Fri May 10 12:17:45 2002
@@ -1,7 +1,7 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <!-- The LearningOnline Network with CAPA -->
-<!-- $Id: install.html,v 1.18 2002/05/02 01:30:15 harris41 Exp $ -->
+<!-- $Id: install.html,v 1.19 2002/05/10 16:17:45 harris41 Exp $ -->
 <html>
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta>
@@ -168,24 +168,56 @@
 <p>
 The following commands describe how to configure the MySQL database
 on your LON-CAPA server.
+<br />Note:
 </p>
+<ul>
+<li>you should substitute 'WWWPASSWORD' with the value for 'lonSqlAccess'
+present inside <tt>/etc/httpd/conf/loncapa.conf</tt> <i>or in access.conf</i>
+</li>
+<li>you should substitute 'ROOTPASSWORD' with something very hard to guess
+(it does not have to be the Linux OS root password)
+</li>
+</ul>
 <table bgcolor="#aaaaaa" border="1"><tr><td>
+<caption>Entering the mysql shell</caption>
 <pre>
-Enter the mysql shell---
 mysql -u root -p mysql
+OR
+mysql -u root      (depending on whether you have set a root password)
+</pre>
+</td></tr></table>
+<table bgcolor="#aaaaaa" border="1"><tr><td>
+<caption>Creating the mysql 'www' user (after entering mysql shell)</caption>
+<pre>
+mysql> CREATE DATABASE loncapa;
 
-Run these commands---
-CREATE DATABASE loncapa;
-
-INSERT INTO user (Host, User, Password)
-VALUES ('localhost','www',password('SOMEPASSWORD'));
-
-GRANT ALL PRIVILEGES ON *.* TO www@localhost;
+mysql> INSERT INTO user (Host, User, Password)
+mysql> VALUES ('localhost','www',password('WWWPASSWORD'));
 
-FLUSH PRIVILEGES;
+mysql> GRANT ALL PRIVILEGES ON *.* TO www@localhost;
 
+mysql> FLUSH PRIVILEGES;
+</pre>
+</td></tr></table>
+<table bgcolor="#aaaaaa" border="1"><tr><td>
+<caption>SECURITY: set a password for the mysql 'root' user</caption>
+<pre>
+shell> mysql -u root mysql
+mysql> SET PASSWORD FOR root@localhost=PASSWORD('ROOTPASSWORD');
+</pre>
+</td></tr></table>
+<table bgcolor="#aaaaaa" border="1"><tr><td>
+<caption>SECURITY: set a password for the mysql 'root' user</caption>
+<pre>
 shell> mysql -u root mysql
-mysql> SET PASSWORD FOR root@localhost=PASSWORD('new_password');
+mysql> SET PASSWORD FOR root@localhost=PASSWORD('ROOTPASSWORD');
+</pre>
+</td></tr></table>
+<table bgcolor="#aaaaaa" border="1"><tr><td>
+<caption>SECURITY: only allow access from localhost</caption>
+<pre>
+shell> mysql -u root -p mysql
+mysql> DELETE * FROM user WHERE host<>'localhost';
 </pre>
 </td></tr></table>
 <a name="testing" />



