diff options
Diffstat (limited to 'mysql-test/suite/pbxt/t/connect.test')
-rw-r--r-- | mysql-test/suite/pbxt/t/connect.test | 108 |
1 files changed, 108 insertions, 0 deletions
diff --git a/mysql-test/suite/pbxt/t/connect.test b/mysql-test/suite/pbxt/t/connect.test new file mode 100644 index 00000000000..0f1107d9556 --- /dev/null +++ b/mysql-test/suite/pbxt/t/connect.test @@ -0,0 +1,108 @@ +# This test is to check various cases of connections +# with right and wrong password, with and without database +# Unfortunately the check is incomplete as we can't connect without database + +# This test makes no sense with the embedded server +--source include/not_embedded.inc + +# check that CSV engine was compiled in, as the test relies on the presence +# of the log tables (which are CSV-based). By connect mysql; show tables; +--source include/have_csv.inc + +--disable_warnings +drop table if exists t1,t2; +--enable_warnings + + +#connect (con1,localhost,root,,""); +#show tables; +connect (con1,localhost,root,,mysql); +show tables; +connect (con2,localhost,root,,test); +show tables; + +--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT +--error 1045 +connect (fail_con,localhost,root,z,test2); +--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT +--error 1045 +connect (fail_con,localhost,root,z,); + +grant ALL on *.* to test@localhost identified by "gambling"; +grant ALL on *.* to test@127.0.0.1 identified by "gambling"; + +# Now check this user with different databases +#connect (con1,localhost,test,gambling,""); +#show tables; +connect (con3,localhost,test,gambling,mysql); +show tables; +connect (con4,localhost,test,gambling,test); +show tables; + +--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT +--error 1045 +connect (fail_con,localhost,test,,test2); +--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT test "" +--error 1045 +connect (fail_con,localhost,test,,""); +--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT +--error 1045 +connect (fail_con,localhost,test,zorro,test2); +--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT +--error 1045 +connect (fail_con,localhost,test,zorro,); + + +# check if old password version also works +update mysql.user set password=old_password("gambling2") where user=_binary"test"; +flush privileges; + +connect (con10,localhost,test,gambling2,); +connect (con5,localhost,test,gambling2,mysql); +connection con5; +set password=""; +--error 1372 +set password='gambling3'; +set password=old_password('gambling3'); +show tables; +connect (con6,localhost,test,gambling3,test); +show tables; + +--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT +--error 1045 +connect (fail_con,localhost,test,,test2); +--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT +--error 1045 +connect (fail_con,localhost,test,,); +--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT +--error 1045 +connect (fail_con,localhost,test,zorro,test2); +--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT +--error 1045 +connect (fail_con,localhost,test,zorro,); + + +# remove user 'test' so that other tests which may use 'test' +# do not depend on this test. + +delete from mysql.user where user=_binary"test"; +flush privileges; + +# +# Bug#12517: Clear user variables and replication events before +# closing temp tables in thread cleanup. +connect (con7,localhost,root,,test); +connection con7; +create table t1 (id integer not null auto_increment primary key); +create temporary table t2(id integer not null auto_increment primary key); +set @id := 1; +delete from t1 where id like @id; +disconnect con7; +--sleep 5 +connection default; +drop table t1; + +--disable_query_log +drop database pbxt; +--enable_query_log +# End of 4.1 tests |