- patch from Morten Brix Pedersen <morten@wtf.dk>. Thanks!

[infobot.git] / INSTALL.mysql

diff --git a/INSTALL.mysql b/INSTALL.mysql
index 78f2747bcfc7a2c18d438b2093215d7126e14f25..a1c6ebaa21a1ea33d505d94ec35ab2386996e610 100644 (file)
--- a/INSTALL.mysql
+++ b/INSTALL.mysql
@@ -1,18 +1,31 @@
 INSTALL.mysql
 ----------------
 
-- Debian: (apt-get install mysql-server)
-- Debian: (apt-get install libdbd-mysql-perl)
+- Install a MySQL server and the DBI Perl modules.
+       - Debian: (apt-get install mysql-server libdbd-mysql-perl)
 
 - run 'mysqladmin -u root -p create <DB NAME>'
-- run 'scripts/setup_user.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:
+-----------------
+ You can add a new user manually by connecting to MySQL and performing these
+ commands:
+
+  $ mysql -u root -p
+
+  mysql> CREATE DATABASE blootbot;
+  mysql> GRANT USAGE ON *.* TO 'user'@'localhost' IDENTIFIED BY 'yourpassword';
+  mysql> GRANT ALL PRIVILEGES ON blootbot.* TO 'user'@'localhost';
+
+for the mysql that are on apt the bot (#debian@OPN), they are available 
+at http://emu.res.cmu.edu/~apt/blootbot/apt.sql.bz2