summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorterry%mozilla.org <>1999-06-12 02:37:11 +0200
committerterry%mozilla.org <>1999-06-12 02:37:11 +0200
commit126b217ebfab7070a58c8a69d24a2846402d53e2 (patch)
treebeb890cbc6b97cdd5851f1275b0bc337646cdbc5
parentf3b7e842dce940c39f9fb03c949fba36c3f0378a (diff)
downloadbugzilla-126b217ebfab7070a58c8a69d24a2846402d53e2.tar.gz
bugzilla-126b217ebfab7070a58c8a69d24a2846402d53e2.tar.xz
Update some things for more modern mysql's.
-rw-r--r--README26
1 files changed, 17 insertions, 9 deletions
diff --git a/README b/README
index 1f18f1113..4d9389aae 100644
--- a/README
+++ b/README
@@ -229,20 +229,26 @@ that, too, then the magic is to do run "mysql mysql", and feed it commands like
this (replace all instances of HOSTNAME with the name of the machine mysql is
running on):
- DELETE * FROM host;
- DELETE * FROM user;
- INSERT INTO host VALUES ('localhost','%','Y','Y','Y','Y','Y','Y');
- INSERT INTO host VALUES (HOSTNAME,'%','Y','Y','Y','Y','Y','Y');
- INSERT INTO user VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
- INSERT INTO user VALUES (HOSTNAME,'','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
- INSERT INTO user VALUES (HOSTNAME,'root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
- INSERT INTO user VALUES ('localhost','','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
+ DELETE FROM host;
+ DELETE FROM user;
+ INSERT INTO host VALUES ('localhost','%','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
+ INSERT INTO host VALUES (HOSTNAME,'%','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
+ INSERT INTO user VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
+ INSERT INTO user VALUES (HOSTNAME,'','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
+ INSERT INTO user VALUES (HOSTNAME,'root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
+ INSERT INTO user VALUES ('localhost','','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
+
+The number of 'Y' entries to use varies with the version of MySQL; they keep
+adding columns. The list here should work with version 3.22.23b.
This run of "mysql mysql" may need some extra parameters to deal with whatever
database permissions were set up previously. In particular, you might have to say "mysql -uroot mysql", and give it an appropriate password.
For much more information about MySQL permissions, see the MySQL documentation.
+After you've tweaked the permissions, run "mysqladmin reload" to make sure that
+the database server knows to look at your new permission list.
+
Next we'll create the bugs database in MySQL. This is done using the
'mysql' command line client. This client allows one to funnel SQL
statements into the MySQL server directly. It's usage summary is
@@ -266,14 +272,16 @@ scripts load data into the database by piping input into the mysql
command. Order does not matter, but this one is fine:
./makeactivitytable.sh
+ ./makeattachmenttable.sh
./makebugtable.sh
./makecctable.sh
./makecomponenttable.sh
+ ./makedependenciestable.sh
+ ./makegroupstable.sh
./makelogincookiestable.sh
./makeproducttable.sh
./makeprofilestable.sh
./makeversiontable.sh
- ./makegroupstable.sh
You may want to edit the scripts; once bugs are entered it gets very hard to
make changes. Think carefully about how you want database users to describe bugs. Here's one