1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
INSTALL.mysql
----------------
- 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 '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'
* [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
|
