LON-CAPA User Help: How do I configure the MySQL server?

<a href="">LON-CAPA User Help</a> : <a href="">Server System Administration</a> :
How do I configure the MySQL server?
    lonSqlAccess inside loncapa_apache.conf should always be set to 
    value 'localhostkey'
    
    This is the password for www@localhost on the MySQL database
    as described in the instructions below.
    
    RedHat 7.* requires these RPMs:
    * mysql-3.23.41-1 (or standard RedHat 7.* version)
    * mysql-server-3.23.41 (or standard RedHat 7.* version)
    
    RedHat 6.* requires the RPM:
    * LON-CAPA-mysql
    available at http://install.lon-capa.org/3.1/latestRPMS/.
    
    DUE TO COMPATIBILITY PROBLEMS, PLEASE DO NOT USE RPMs FROM
    OTHER SOURCES SUCH AS www.mysql.com.
    
    Enter the mysql shell--- (use one of the following two commands)
    bash$ mysql -u root mysql
    bash$ mysql -u root -p mysql
    
    Run these commands---
    mysql> CREATE DATABASE loncapa;
    
    mysql> INSERT INTO user (Host, User, Password)
    mysql> VALUES ('localhost','www',password('localhostkey'));
    
    mysql> GRANT ALL PRIVILEGES ON *.* TO www@localhost;
    
    mysql> FLUSH PRIVILEGES;
    
    mysql> SET PASSWORD FOR root@localhost=PASSWORD('new_password');
    
    If you need to change the www@localhost password, then
    bash$ mysql -u root -p mysql
    mysql> SET PASSWORD FOR www@localhost=PASSWORD('localhostkey');


This document is at: http://help.loncapa.org/cgi-bin/fom?file=154
Generated by FAQ-O-Matic 2.719,
available at http://faqomatic.sourceforge.net/