(Answer) (Category) LON-CAPA User Help : (Category) Server System Administration :
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');
[Append to This Answer]
Previous: (Answer) RedHat 7.2 install is missing files lib_perl.so, libncurses.so, etc.
Next: (Answer) When I restart the web server, there are errors about missing perl files? What can be done?
This document is: http://help.loncapa.org/cgi-bin/fom?file=154
[Search] [Appearance] [Show This Answer As Text]
This is a Faq-O-Matic 2.719.
This FAQ administered by the LON-CAPA team at MSU. Submit a help request ticket to contact us.