Changeset 4665

Timestamp:

Jul 28, 2005, 6:02:01 PM (21 years ago)

Author:

jhoblitt

Message:

change to mysql 'grant' syntax

Location:

trunk

Files:

• Nebulous-Server/docs/database_setup.txt (modified) (2 diffs)
• Nebulous/docs/database_setup.txt (modified) (2 diffs)

trunk/Nebulous-Server/docs/database_setup.txt

@@ -1 +1 @@
 # Copyright (C) 2004  Joshua Hoblitt
 #
-# $Id: database_setup.txt,v 1.3 2005-01-15 04:02:12 jhoblitt Exp $
+# $Id: database_setup.txt,v 1.4 2005-07-29 04:02:01 jhoblitt Exp $
 
 ### Database Setup
 
-DROP DATABASE IF EXISTS pixel;
-CREATE DATABASE pixel;
-INSERT INTO db VALUES ('%','pixel','pixel','y','y','y','y','y','y','y','y','y','y','y','y');
-INSERT INTO user
-(Host,User,Password,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv,Alter_priv,Show_db_priv)
-VALUES ('%','pixel',password('pixel'),'y','y','y','y','y','y','y','y','y');
-INSERT INTO user
-(Host,User,Password,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv,Alter_priv,Show_db_priv)
-VALUES ('localhost','pixel',password('pixel'),'y','y','y','y','y','y','y','y','y');
+### MySQL 4.1
+
+DROP DATABASE IF EXISTS nebulous;
+CREATE DATABASE nebulous;
+GRANT ALL PRIVILEGES ON *.* TO 'nebulous'@'localhost'
+    IDENTIFIED BY 'pixel' WITH GRANT OPTION;
 FLUSH PRIVILEGES;
-
-USE pixel;
-
-### MySQL 4.1
+USE nebulous;
 
 DROP TABLE IF EXISTS storage_object;
@@ -78 +72 @@
 # NFS
 
-INSERT INTO volume VALUES (1,'po01','file:/tmp/po01');
-INSERT INTO volume VALUES (2,'po02','file:/tmp/po02');
-INSERT INTO volume VALUES (3,'po03','file:/tmp/po03');
-INSERT INTO volume VALUES (4,'po04','file:/tmp/po04');
-INSERT INTO volume VALUES (5,'po05','file:/tmp/po05');
-INSERT INTO volume VALUES (6,'po06','file:/tmp/po06');
-INSERT INTO volume VALUES (7,'po07','file:/tmp/po07');
-INSERT INTO volume VALUES (8,'po08','file:/tmp/po08');
+INSERT INTO volume VALUES (1,'po01','file:/netdisks/po01');
+INSERT INTO volume VALUES (2,'po02','file:/netdisks/po02');
+INSERT INTO volume VALUES (3,'po03','file:/netdisks/po03');
+INSERT INTO volume VALUES (4,'po04','file:/netdisks/po04');
+INSERT INTO volume VALUES (5,'po05','file:/netdisks/po05');
+INSERT INTO volume VALUES (6,'po06','file:/netdisks/po06');
+INSERT INTO volume VALUES (7,'po07','file:/netdisks/po07');
+INSERT INTO volume VALUES (8,'po08','file:/netdisks/po08');
 
 INSERT INTO class VALUES (1,3,0,'raw image data');

trunk/Nebulous/docs/database_setup.txt

@@ -1 +1 @@
 # Copyright (C) 2004  Joshua Hoblitt
 #
-# $Id: database_setup.txt,v 1.3 2005-01-15 04:02:12 jhoblitt Exp $
+# $Id: database_setup.txt,v 1.4 2005-07-29 04:02:01 jhoblitt Exp $
 
 ### Database Setup
 
-DROP DATABASE IF EXISTS pixel;
-CREATE DATABASE pixel;
-INSERT INTO db VALUES ('%','pixel','pixel','y','y','y','y','y','y','y','y','y','y','y','y');
-INSERT INTO user
-(Host,User,Password,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv,Alter_priv,Show_db_priv)
-VALUES ('%','pixel',password('pixel'),'y','y','y','y','y','y','y','y','y');
-INSERT INTO user
-(Host,User,Password,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv,Alter_priv,Show_db_priv)
-VALUES ('localhost','pixel',password('pixel'),'y','y','y','y','y','y','y','y','y');
+### MySQL 4.1
+
+DROP DATABASE IF EXISTS nebulous;
+CREATE DATABASE nebulous;
+GRANT ALL PRIVILEGES ON *.* TO 'nebulous'@'localhost'
+    IDENTIFIED BY 'pixel' WITH GRANT OPTION;
 FLUSH PRIVILEGES;
-
-USE pixel;
-
-### MySQL 4.1
+USE nebulous;
 
 DROP TABLE IF EXISTS storage_object;
@@ -78 +72 @@
 # NFS
 
-INSERT INTO volume VALUES (1,'po01','file:/tmp/po01');
-INSERT INTO volume VALUES (2,'po02','file:/tmp/po02');
-INSERT INTO volume VALUES (3,'po03','file:/tmp/po03');
-INSERT INTO volume VALUES (4,'po04','file:/tmp/po04');
-INSERT INTO volume VALUES (5,'po05','file:/tmp/po05');
-INSERT INTO volume VALUES (6,'po06','file:/tmp/po06');
-INSERT INTO volume VALUES (7,'po07','file:/tmp/po07');
-INSERT INTO volume VALUES (8,'po08','file:/tmp/po08');
+INSERT INTO volume VALUES (1,'po01','file:/netdisks/po01');
+INSERT INTO volume VALUES (2,'po02','file:/netdisks/po02');
+INSERT INTO volume VALUES (3,'po03','file:/netdisks/po03');
+INSERT INTO volume VALUES (4,'po04','file:/netdisks/po04');
+INSERT INTO volume VALUES (5,'po05','file:/netdisks/po05');
+INSERT INTO volume VALUES (6,'po06','file:/netdisks/po06');
+INSERT INTO volume VALUES (7,'po07','file:/netdisks/po07');
+INSERT INTO volume VALUES (8,'po08','file:/netdisks/po08');
 
 INSERT INTO class VALUES (1,3,0,'raw image data');