diff options
Diffstat (limited to 'mysql-test/r/connect.result')
| -rw-r--r-- | mysql-test/r/connect.result | 84 |
1 files changed, 84 insertions, 0 deletions
diff --git a/mysql-test/r/connect.result b/mysql-test/r/connect.result index cb66ff483e1..20a01c6f78e 100644 --- a/mysql-test/r/connect.result +++ b/mysql-test/r/connect.result @@ -1,5 +1,6 @@ SET global secure_auth=0; drop table if exists t1,t2; +connect con1,localhost,root,,mysql; show tables; Tables_in_mysql column_stats @@ -32,14 +33,21 @@ time_zone_name time_zone_transition time_zone_transition_type user +connect con2,localhost,root,,test; show tables; Tables_in_test connect(localhost,root,z,test2,MASTER_PORT,MASTER_SOCKET); +connect fail_con,localhost,root,z,test2; ERROR 28000: Access denied for user 'root'@'localhost' (using password: YES) connect(localhost,root,z,test,MASTER_PORT,MASTER_SOCKET); +connect fail_con,localhost,root,z,; ERROR 28000: Access denied for user 'root'@'localhost' (using password: YES) +connection default; +disconnect con1; +disconnect con2; grant ALL on *.* to test@localhost identified by "gambling"; grant ALL on *.* to test@127.0.0.1 identified by "gambling"; +connect con3,localhost,test,gambling,mysql; show tables; Tables_in_mysql column_stats @@ -72,18 +80,29 @@ time_zone_name time_zone_transition time_zone_transition_type user +connect con4,localhost,test,gambling,test; show tables; Tables_in_test +connection default; +disconnect con3; +disconnect con4; connect(localhost,test,,test2,MASTER_PORT,MASTER_SOCKET); +connect fail_con,localhost,test,,test2; ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) connect(localhost,test,,"",MASTER_PORT,MASTER_SOCKET); +connect fail_con,localhost,test,,'""'; ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) connect(localhost,test,zorro,test2,MASTER_PORT,MASTER_SOCKET); +connect fail_con,localhost,test,zorro,test2; ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES) connect(localhost,test,zorro,test,MASTER_PORT,MASTER_SOCKET); +connect fail_con,localhost,test,zorro,; ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES) 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=""; set password='gambling3'; ERROR HY000: Password hash should be a 41-digit hexadecimal number @@ -120,22 +139,35 @@ time_zone_name time_zone_transition time_zone_transition_type user +connect con6,localhost,test,gambling3,test; show tables; Tables_in_test +connection default; +disconnect con10; +disconnect con5; +disconnect con6; connect(localhost,test,,test2,MASTER_PORT,MASTER_SOCKET); +connect fail_con,localhost,test,,test2; ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) connect(localhost,test,,test,MASTER_PORT,MASTER_SOCKET); +connect fail_con,localhost,test,,; ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) connect(localhost,test,zorro,test2,MASTER_PORT,MASTER_SOCKET); +connect fail_con,localhost,test,zorro,test2; ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES) connect(localhost,test,zorro,test,MASTER_PORT,MASTER_SOCKET); +connect fail_con,localhost,test,zorro,; ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES) delete from mysql.user where user=_binary"test"; flush privileges; +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; +connection default; +disconnect con7; drop table t1; # ------------------------------------------------------------------ # -- End of 4.1 tests @@ -149,10 +181,19 @@ GRANT USAGE ON *.* TO mysqltest_u1@localhost; SET GLOBAL max_connections = 10; SET GLOBAL event_scheduler = ON; +connect tmp_con1,localhost,mysqltest_u1,,; +connect tmp_con2,localhost,mysqltest_u1,,; +connect tmp_con3,localhost,mysqltest_u1,,; +connect tmp_con4,localhost,mysqltest_u1,,; +connect tmp_con5,localhost,mysqltest_u1,,; +connect tmp_con6,localhost,mysqltest_u1,,; +connect tmp_con7,localhost,mysqltest_u1,,; +connection default; # -- Waiting for Event Scheduler to start... # -- Disconnecting default connection... +disconnect default; # -- Check that we allow exactly three user connections, no matter how # -- many threads are running. @@ -209,8 +250,20 @@ SET GLOBAL event_scheduler = OFF; # -- Waiting for Event Scheduler to stop... # -- That's it. Closing connections... +disconnect con_1; +disconnect con_2; +disconnect con_3; +disconnect con_super_1; +disconnect tmp_con1; +disconnect tmp_con2; +disconnect tmp_con3; +disconnect tmp_con4; +disconnect tmp_con5; +disconnect tmp_con6; +disconnect tmp_con7; # -- Restoring default connection... +connect default,localhost,root,,test; # -- Waiting for connections to close... @@ -231,6 +284,7 @@ SET GLOBAL event_scheduler = ON; # -- Waiting for Event Scheduler to start... # -- Opening a new connection to check max_used_connections... +connect con_1,localhost,root; # -- Check that max_used_connections hasn't changed. SHOW STATUS LIKE 'max_used_connections'; @@ -238,6 +292,8 @@ Variable_name Value Max_used_connections 2 # -- Closing new connection... +disconnect con_1; +connection default; # -- Stopping Event Scheduler... SET GLOBAL event_scheduler = OFF; @@ -245,9 +301,13 @@ SET GLOBAL event_scheduler = OFF; # -- End of Bug#35074. +connect extracon,127.0.0.1,root,,test,$MASTER_EXTRA_PORT,; +connection extracon; SELECT 'Connection on extra port ok'; Connection on extra port ok Connection on extra port ok +connect extracon2,127.0.0.1,root,,test,$MASTER_EXTRA_PORT,; +connection extracon2; SELECT 'Connection on extra port 2 ok'; Connection on extra port 2 ok Connection on extra port 2 ok @@ -258,6 +318,9 @@ Connection on extra port 2 ok # GRANT ALL ON test.* TO 'O1234567890123456789012345678901234567890123456789012345678901234567890123456789'@'localhost' IDENTIFIED BY 'test123'; FLUSH PRIVILEGES; +connect con1,localhost,O1234567890123456789012345678901234567890123456789012345678901234567890123456789x,test123,test; +disconnect con1; +connection default; DROP USER 'O1234567890123456789012345678901234567890123456789012345678901234567890123456789'@'localhost'; FLUSH PRIVILEGES; # @@ -266,22 +329,36 @@ FLUSH PRIVILEGES; # ------------------------------------------------------------------ # -- End of 5.1 tests # ------------------------------------------------------------------ +disconnect extracon; +disconnect extracon2; +connection default; CREATE USER mysqltest_up1 IDENTIFIED VIA mysql_native_password using '*E8D46CE25265E545D225A8A6F1BAF642FEBEE5CB'; CREATE USER mysqltest_up2 IDENTIFIED VIA mysql_old_password using '09301740536db389'; connect(localhost,mysqltest_up1,foo,test,MASTER_PORT,MASTER_SOCKET); +connect pcon1,localhost,mysqltest_up1,foo,,$MASTER_MYPORT,; ERROR 28000: Access denied for user 'mysqltest_up1'@'localhost' (using password: YES) +connect pcon2,localhost,mysqltest_up1,bar,,$MASTER_MYPORT,; +connection pcon2; select user(), current_user(); user() current_user() mysqltest_up1@localhost mysqltest_up1@% +disconnect pcon2; connect(localhost,mysqltest_up2,newpw,test,MASTER_PORT,MASTER_SOCKET); +connect pcon3,localhost,mysqltest_up2,newpw,,$MASTER_MYPORT,; ERROR 28000: Access denied for user 'mysqltest_up2'@'localhost' (using password: YES) +connect pcon4,localhost,mysqltest_up2,oldpw,,$MASTER_MYPORT,; +connection pcon4; select user(), current_user(); user() current_user() mysqltest_up2@localhost mysqltest_up2@% +disconnect pcon4; connect(localhost,mysqltest_nouser,newpw,test,MASTER_PORT,MASTER_SOCKET); +connect pcon5,localhost,mysqltest_nouser,newpw,,$MASTER_MYPORT,; ERROR 28000: Access denied for user 'mysqltest_nouser'@'localhost' (using password: YES) connect(localhost,mysqltest_nouser,,test,MASTER_PORT,MASTER_SOCKET); +connect pcon5,localhost,mysqltest_nouser,,,$MASTER_MYPORT,; ERROR 28000: Access denied for user 'mysqltest_nouser'@'localhost' (using password: NO) +connection default; update mysql.user set plugin='mysql_native_password' where user = 'mysqltest_up1'; update mysql.user set plugin='mysql_old_password' where user = 'mysqltest_up2'; select user, password, plugin, authentication_string from mysql.user @@ -290,12 +367,19 @@ user password plugin authentication_string mysqltest_up1 *E8D46CE25265E545D225A8A6F1BAF642FEBEE5CB mysql_native_password mysqltest_up2 09301740536db389 mysql_old_password flush privileges; +connect pcon6,localhost,mysqltest_up1,bar,,$MASTER_MYPORT,; +connection pcon6; select user(), current_user(); user() current_user() mysqltest_up1@localhost mysqltest_up1@% +disconnect pcon6; +connect pcon7,localhost,mysqltest_up2,oldpw,,$MASTER_MYPORT,; +connection pcon7; select user(), current_user(); user() current_user() mysqltest_up2@localhost mysqltest_up2@% +disconnect pcon7; +connection default; DROP USER mysqltest_up1@'%'; DROP USER mysqltest_up2@'%'; # |