diff options
| author | terry%mozilla.org <> | 1999-06-12 02:37:11 +0200 |
|---|---|---|
| committer | terry%mozilla.org <> | 1999-06-12 02:37:11 +0200 |
| commit | 126b217ebfab7070a58c8a69d24a2846402d53e2 (patch) | |
| tree | beb890cbc6b97cdd5851f1275b0bc337646cdbc5 | |
| parent | f3b7e842dce940c39f9fb03c949fba36c3f0378a (diff) | |
| download | bugzilla-126b217ebfab7070a58c8a69d24a2846402d53e2.tar.gz bugzilla-126b217ebfab7070a58c8a69d24a2846402d53e2.tar.xz | |
Update some things for more modern mysql's.
| -rw-r--r-- | README | 26 |
1 files changed, 17 insertions, 9 deletions
@@ -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 |