Return to howtoaddusertolonsql CVS log

Up to [LON-CAPA] / doc

Annotation of doc/howtoaddusertolonsql, revision 1.2

1.1       harris41    1: start the mysql daemon as /usr/local/bin/safe_mysqld &
1.2     ! albertel    2: Login as root: mysql -u root -p mysql
1.1       harris41    3: enter the password as newmysql
                      4: add the user www: grant all priveleges on *.* to www@localhost identified by 'newmysql' with grant option;
1.2     ! albertel    5: 
        !             6: INSERT INTO user (Host, User, Password)
        !             7: VALUES ('localhost','www',password('newmysql'));
        !             8: 
        !             9: GRANT ALL PRIVILEGES ON *.* TO www@localhost;
        !            10: 
        !            11: FLUSH PRIVILEGES;
        !            12: 
1.1       harris41   13: Here the user www has the right to grant privileges to other users.
                     14: This can be changed if required with a simple update command on the grant tables
                     15: 
                     16: 
                     17: /home/httpd/perl/perlsql/lonsql
                     18: /usr/local/mysql/fakeclient
                     19: 
                     20: