DROP USER mysqltest@localhost;
CREATE USER mysqltest@localhost identified by 'PWD';
DROP TABLE IF EXISTS test.t2;
DROP SCHEMA IF EXISTS mysqltest;
CREATE SCHEMA mysqltest ;
grant ALL ON mysqltest.* to mysqltest@localhost;
grant ALL ON test.* to mysqltest@localhost;
# Establish connection mysqltest (user = mysqltest)
USE mysqltest;
CREATE TABLE t1
(f1   CHAR(3) NOT NULL,
UNIQUE  (f1)) ENGINE = InnoDB;
CREATE TABLE test.t2
(f1   CHAR(3),
f2     CHAR(3),
FOREIGN KEY (f1) REFERENCES mysqltest.t1(f1)) ENGINE = InnoDB;
# Switch to connection default (user = root)
REVOKE ALL PRIVILEGES, GRANT OPTION FROM mysqltest@localhost;
DROP USER mysqltest@localhost;
DROP SCHEMA mysqltest;
DROP TABLE test.t2;