diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/connect.result | 34 | ||||
| -rw-r--r-- | mysql-test/t/connect.test | 67 |
2 files changed, 101 insertions, 0 deletions
diff --git a/mysql-test/r/connect.result b/mysql-test/r/connect.result new file mode 100644 index 00000000000..3e9091462d8 --- /dev/null +++ b/mysql-test/r/connect.result @@ -0,0 +1,34 @@ +show tables; +Tables_in_mysql +columns_priv +db +func +host +tables_priv +user +show tables; +Tables_in_test +grant ALL on *.* to test@localhost identified by "gambling"; +grant ALL on *.* to test@127.0.0.1 identified by "gambling"; +show tables; +Tables_in_mysql +columns_priv +db +func +host +tables_priv +user +show tables; +Tables_in_test +update mysql.user set password=old_password("gambling2") where user="test"; +flush privileges; +show tables; +Tables_in_mysql +columns_priv +db +func +host +tables_priv +user +show tables; +Tables_in_test diff --git a/mysql-test/t/connect.test b/mysql-test/t/connect.test new file mode 100644 index 00000000000..0bc5ca3914f --- /dev/null +++ b/mysql-test/t/connect.test @@ -0,0 +1,67 @@ +# 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 handle errors on connect +# Also we can't connect without database + +#connect (con1,localhost,root,,""); +#show tables; +connect (con1,localhost,root,,mysql); +show tables; +connect (con1,localhost,root,,test); +show tables; + +# Re enable this one day if error handling on connect will take place + +#connect (con1,localhost,root,z,test2); +#--error 1045 +#connect (con1,localhost,root,z,); +#--error 1045 + +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 (con1,localhost,test,gambling,mysql); +show tables; +connect (con1,localhost,test,gambling,test); +show tables; + +# Re enable this one day if error handling on connect will take place + +#connect (con1,localhost,test,,test2); +#--error 1045 +#connect (con1,localhost,test,,""); +#--error 1045 +#connect (con1,localhost,test,zorro,test2); +#--error 1045 +#connect (con1,localhost,test,zorro,); +#--error 1045 + + + +# check if old password version also works +update mysql.user set password=old_password("gambling2") where user="test"; +flush privileges; + +#connect (con1,localhost,test,gambling2,""); +#show tables; +connect (con1,localhost,test,gambling2,mysql); +show tables; +connect (con1,localhost,test,gambling2,test); +show tables; + +# Re enable this one day if error handling on connect will take place + +#connect (con1,localhost,test,,test2); +#--error 1045 +#connect (con1,localhost,test,,); +#--error 1045 +#connect (con1,localhost,test,zorro,test2); +#--error 1045 +#connect (con1,localhost,test,zorro,); +#--error 1045 + + |