How close is this going to be?
I want two users, udm and udm_ro. udm_ro is going to be the searching one,
and udm is going to be the spidering one.
Sorry, I've had to hide all the non-mnogo things in this, and all the
passwords, but hope it's enough.
Has anyone else tried anything like this?
Gary (-;
<<sql.txt>>
# MySQL dump 8.12
#
# Host: localhost Database: mysql
#--------------------------------------------------------
# Server version 3.23.33
#
# Table structure for table 'columns_priv'
#
CREATE TABLE columns_priv (
Host char(60) NOT NULL default '',
Db char(60) NOT NULL default '',
User char(16) NOT NULL default '',
Table_name char(60) NOT NULL default '',
Column_name char(60) NOT NULL default '',
Timestamp timestamp(14) NOT NULL,
Column_priv set('Select','Insert','Update','References') NOT NULL default '',
PRIMARY KEY (Host,Db,User,Table_name,Column_name)
) TYPE=ISAM PACK_KEYS=1;
#
# Dumping data for table 'columns_priv'
#
#
# Table structure for table 'db'
#
CREATE TABLE db (
Host char(60) NOT NULL default '',
Db char(32) NOT NULL default '',
User char(16) NOT NULL default '',
Select_priv enum('N','Y') NOT NULL default 'N',
Insert_priv enum('N','Y') NOT NULL default 'N',
Update_priv enum('N','Y') NOT NULL default 'N',
Delete_priv enum('N','Y') NOT NULL default 'N',
Create_priv enum('N','Y') NOT NULL default 'N',
Drop_priv enum('N','Y') NOT NULL default 'N',
Grant_priv enum('N','Y') NOT NULL default 'N',
References_priv enum('N','Y') NOT NULL default 'N',
Index_priv enum('N','Y') NOT NULL default 'N',
Alter_priv enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (Host,Db,User),
KEY User(User)
) TYPE=ISAM PACK_KEYS=1;
#
# Dumping data for table 'db'
#
INSERT INTO db VALUES
('localhost','udmsearch','udm_ro','Y','Y','N','Y','Y','Y','N','N','N','N');
INSERT INTO db VALUES
('localhost','udmsearchtest','udm_ro','Y','Y','N','Y','Y','Y','N','N','N','N');
INSERT INTO db VALUES ('%','udmsearch','udm','Y','Y','Y','Y','Y','Y','N','N','N','N');
INSERT INTO db VALUES
('localhost','udmsearchtest','udm','Y','Y','Y','Y','Y','Y','N','N','N','N');
#
# Table structure for table 'func'
#
CREATE TABLE func (
name char(64) NOT NULL default '',
ret tinyint(1) NOT NULL default '0',
dl char(128) NOT NULL default '',
type enum('function','aggregate') NOT NULL default 'function',
PRIMARY KEY (name)
) TYPE=ISAM PACK_KEYS=1;
#
# Dumping data for table 'func'
#
#
# Table structure for table 'host'
#
CREATE TABLE host (
Host char(60) NOT NULL default '',
Db char(32) NOT NULL default '',
Select_priv enum('N','Y') NOT NULL default 'N',
Insert_priv enum('N','Y') NOT NULL default 'N',
Update_priv enum('N','Y') NOT NULL default 'N',
Delete_priv enum('N','Y') NOT NULL default 'N',
Create_priv enum('N','Y') NOT NULL default 'N',
Drop_priv enum('N','Y') NOT NULL default 'N',
Grant_priv enum('N','Y') NOT NULL default 'N',
References_priv enum('N','Y') NOT NULL default 'N',
Index_priv enum('N','Y') NOT NULL default 'N',
Alter_priv enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (Host,Db)
) TYPE=ISAM PACK_KEYS=1;
#
# Dumping data for table 'host'
#
#
# Table structure for table 'tables_priv'
#
CREATE TABLE tables_priv (
Host char(60) NOT NULL default '',
Db char(60) NOT NULL default '',
User char(16) NOT NULL default '',
Table_name char(60) NOT NULL default '',
Grantor char(77) NOT NULL default '',
Timestamp timestamp(14) NOT NULL,
Table_priv
set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter')
NOT NULL default '',
Column_priv set('Select','Insert','Update','References') NOT NULL default '',
PRIMARY KEY (Host,Db,User,Table_name),
KEY Grantor(Grantor)
) TYPE=ISAM PACK_KEYS=1;
#
# Dumping data for table 'tables_priv'
#
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','server','root@localhost',20010305102406,'Select,Insert,Update','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','server','root@localhost',20010305111403,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict3','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','affix','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict4','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict5','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict6','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict7','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict8','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict9','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict10','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict12','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict11','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict16','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ndict32','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','ncrossdict','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','crossdict','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','robots','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','qtrack','root@localhost',20010315154406,'Select,Insert,Update','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','spell','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','stopword','root@localhost',20010315154334,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm','url','root@localhost',20010315154335,'Select,Insert,Update,Delete','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict3','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','affix','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict4','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict5','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict6','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict7','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict8','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict9','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict10','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict12','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict11','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict16','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ndict32','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','ncrossdict','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','crossdict','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','robots','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','qtrack','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','spell','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','stopword','root@localhost',20010315155414,'Select','');
INSERT INTO tables_priv VALUES
('%','udmsearch','udm_ro','url','root@localhost',20010315155415,'Select','');
#
# Table structure for table 'user'
#
CREATE TABLE user (
Host char(60) NOT NULL default '',
User char(16) NOT NULL default '',
Password char(16) NOT NULL default '',
Select_priv enum('N','Y') NOT NULL default 'N',
Insert_priv enum('N','Y') NOT NULL default 'N',
Update_priv enum('N','Y') NOT NULL default 'N',
Delete_priv enum('N','Y') NOT NULL default 'N',
Create_priv enum('N','Y') NOT NULL default 'N',
Drop_priv enum('N','Y') NOT NULL default 'N',
Reload_priv enum('N','Y') NOT NULL default 'N',
Shutdown_priv enum('N','Y') NOT NULL default 'N',
Process_priv enum('N','Y') NOT NULL default 'N',
File_priv enum('N','Y') NOT NULL default 'N',
Grant_priv enum('N','Y') NOT NULL default 'N',
References_priv enum('N','Y') NOT NULL default 'N',
Index_priv enum('N','Y') NOT NULL default 'N',
Alter_priv enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (Host,User)
) TYPE=ISAM PACK_KEYS=1;
#
# Dumping data for table 'user'
#
INSERT INTO user VALUES
('localhost','root','ksjgklashdglkjsahg','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES
('%','udm_ro','dflhdsklghkljshdglkj','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO user VALUES
('%','udm','kljhewrlkjhasdfh','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
