- hrm... forgot to update local copy before I can commit. Silly me.

[infobot.git] / INSTALL.mysql

diff --git a/INSTALL.mysql b/INSTALL.mysql
index 2c0f5845b9909510393b5f14c5bd4dea295dac2c..9e816db446e23054ea3b3fd58beceac6e09a2fb4 100644 (file)
--- a/INSTALL.mysql
+++ b/INSTALL.mysql
@@ -5,14 +5,23 @@ INSTALL.mysql
 - Debian: (apt-get install libdbd-mysql-perl)
 
 - run 'mysqladmin -u root -p create <DB NAME>'
-- run 'scripts/setup_users.pl'
+- run 'setup/setup.pl'
 = Possible problems
        - if connection to localhost is (short) refused, run
                '/etc/init.d/mysql stop'.
                '/etc/init.d/mysql start'.
        - if connection for user is refused, reload grant tables with
                'mysqladmin -u root -p reload'
-- run 'scripts/setup_tables.pl'
 * [OPTIONAL]
        - run 'scripts/dbm2mysql.pl old-db' to convert dbm database file
          to mysql.
+
+ADDITIONAL NOTES:
+ HOW TO ADD NEW USER MANUALLY
+    CREATE DATABASE @DBNAME@
+    INSERT INTO user VALUES ('localhost','@USER@',password('@PASS@'),
+       'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N');
+    INSERT INTO db VALUES ('localhost','@DBNAME@','@USER@',
+       'Y','Y','Y','Y','Y','N','N','N','N','N');
+    GRANT SELECT,INSERT,UPDATE,DELETE ON @DBNAME@ TO @USER@
+    FLUSH PRIVILEGES