1
DROP DATABASE IF EXISTS db_datadict;
2
CREATE DATABASE db_datadict;
3
DROP USER testuser1@localhost;
4
CREATE USER testuser1@localhost;
5
GRANT SELECT ON db_datadict.* TO testuser1@localhost;
6
SELECT * FROM information_schema.table_constraints
7
WHERE table_schema = 'mysql'
8
ORDER BY table_schema,table_name,constraint_name;
9
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE
10
NULL mysql PRIMARY mysql columns_priv PRIMARY KEY
11
NULL mysql PRIMARY mysql db PRIMARY KEY
12
NULL mysql PRIMARY mysql event PRIMARY KEY
13
NULL mysql PRIMARY mysql func PRIMARY KEY
14
NULL mysql name mysql help_category UNIQUE
15
NULL mysql PRIMARY mysql help_category PRIMARY KEY
16
NULL mysql name mysql help_keyword UNIQUE
17
NULL mysql PRIMARY mysql help_keyword PRIMARY KEY
18
NULL mysql PRIMARY mysql help_relation PRIMARY KEY
19
NULL mysql name mysql help_topic UNIQUE
20
NULL mysql PRIMARY mysql help_topic PRIMARY KEY
21
NULL mysql PRIMARY mysql host PRIMARY KEY
22
NULL mysql PRIMARY mysql ndb_binlog_index PRIMARY KEY
23
NULL mysql PRIMARY mysql plugin PRIMARY KEY
24
NULL mysql PRIMARY mysql proc PRIMARY KEY
25
NULL mysql PRIMARY mysql procs_priv PRIMARY KEY
26
NULL mysql PRIMARY mysql servers PRIMARY KEY
27
NULL mysql PRIMARY mysql tables_priv PRIMARY KEY
28
NULL mysql PRIMARY mysql time_zone PRIMARY KEY
29
NULL mysql PRIMARY mysql time_zone_leap_second PRIMARY KEY
30
NULL mysql PRIMARY mysql time_zone_name PRIMARY KEY
31
NULL mysql PRIMARY mysql time_zone_transition PRIMARY KEY
32
NULL mysql PRIMARY mysql time_zone_transition_type PRIMARY KEY
33
NULL mysql PRIMARY mysql user PRIMARY KEY
34
# Establish connection testuser1 (user=testuser1)
35
SELECT * FROM information_schema.table_constraints
36
WHERE table_schema = 'mysql'
37
ORDER BY table_schema,table_name,constraint_name;
38
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE
39
# Switch to connection default and close connection testuser1
40
DROP USER testuser1@localhost;
41
DROP DATABASE db_datadict;