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'); |