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
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>