Return to howtoaddusertolonsql CVS log

Up to [LON-CAPA] / doc

- figured out the exact text to add a user to mysql

start the mysql daemon as /usr/local/bin/safe_mysqld &
Login as root: mysql -u root -p mysql
enter the password as newmysql
add the user www: grant all priveleges on *.* to www@localhost identified by 'newmysql' with grant option;

INSERT INTO user (Host, User, Password)
VALUES ('localhost','www',password('newmysql'));

GRANT ALL PRIVILEGES ON *.* TO www@localhost;

FLUSH PRIVILEGES;

Here the user www has the right to grant privileges to other users.
This can be changed if required with a simple update command on the grant tables


/home/httpd/perl/perlsql/lonsql
/usr/local/mysql/fakeclient