1
# suite/funcs_1/datadict/tables1.inc
3
# Auxiliary script to be sourced by
5
# is_tables_mysql_embedded.test
9
# 2008-01-23 mleich WL#4203 Reorganize and fix the data dictionary tests of
11
# Create this script based on older scripts and new code.
15
DROP DATABASE IF EXISTS test1;
17
CREATE DATABASE test1;
19
--source suite/funcs_1/datadict/tables2.inc
21
# Create a low privileged user.
22
# Note: The database test1 is just a "home" for the low privileged user
23
# and not in the focus of testing.
24
--error 0,ER_CANNOT_USER
25
DROP USER testuser1@localhost;
26
CREATE USER testuser1@localhost;
27
GRANT SELECT ON test1.* TO testuser1@localhost;
29
--echo # Establish connection testuser1 (user=testuser1)
30
--replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK
31
connect (testuser1,localhost,testuser1,,test1);
32
--source suite/funcs_1/datadict/tables2.inc
34
--echo # Switch to connection default and close connection testuser1
37
DROP USER testuser1@localhost;