--disable_warnings
create database mysqltest;
--enable_warnings

create table mysqltest.t1 (a int);
create view mysqltest.v1 as select * from mysqltest.t1;

# create user with enough privileges to observe view definition
grant show view on mysqltest.* to mysqltest_1@localhost;

connect (user1,localhost,mysqltest_1,,test);
connection user1;
show tables from mysqltest;

--disable_warnings
connect (root_user,localhost,root,,test);
connection root_user;
drop database mysqltest;
--enable_warnings