From 8c163286a98bfdc883220500a02e06a9f4ba633f Mon Sep 17 00:00:00 2001 From: dms Date: Sat, 2 Feb 2002 09:30:05 +0000 Subject: [PATCH] - hrm... forgot to update local copy before I can commit. Silly me. Thanks to Joey Smith for notifying me. git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk@547 c11ca15a-4712-0410-83d8-924469b57eb5 --- blootbot/INSTALL.mysql | 13 +++++++++++-- 1 file changed, 11 insertions(+), 2 deletions(-) diff --git a/blootbot/INSTALL.mysql b/blootbot/INSTALL.mysql index 2c0f584..9e816db 100644 --- a/blootbot/INSTALL.mysql +++ b/blootbot/INSTALL.mysql @@ -5,14 +5,23 @@ INSTALL.mysql - Debian: (apt-get install libdbd-mysql-perl) - run 'mysqladmin -u root -p create ' -- 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 -- 2.39.5