drop table if exists t1,t2; show tables; Tables_in_mysql columns_priv db event func general_log help_category help_keyword help_relation help_topic host ndb_binlog_index plugin proc procs_priv proxies_priv servers slow_log tables_priv time_zone time_zone_leap_second time_zone_name time_zone_transition time_zone_transition_type user show tables; Tables_in_test connect(localhost,root,z,test2,MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'root'@'localhost' (using password: YES) connect(localhost,root,z,test,MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'root'@'localhost' (using password: YES) 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 event func general_log help_category help_keyword help_relation help_topic host ndb_binlog_index plugin proc procs_priv proxies_priv servers slow_log tables_priv time_zone time_zone_leap_second time_zone_name time_zone_transition time_zone_transition_type user show tables; Tables_in_test connect(localhost,test,,test2,MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) connect(localhost,test,,"",MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) connect(localhost,test,zorro,test2,MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES) connect(localhost,test,zorro,test,MASTER_PORT,MASTER_SOCKET); 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; set password=""; set password='gambling3'; ERROR HY000: Password hash should be a 41-digit hexadecimal number set password=old_password('gambling3'); show tables; Tables_in_mysql columns_priv db event func general_log help_category help_keyword help_relation help_topic host ndb_binlog_index plugin proc procs_priv proxies_priv servers slow_log tables_priv time_zone time_zone_leap_second time_zone_name time_zone_transition time_zone_transition_type user show tables; Tables_in_test connect(localhost,test,,test2,MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) connect(localhost,test,,test,MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) connect(localhost,test,zorro,test2,MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES) connect(localhost,test,zorro,test,MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES) delete from mysql.user where user=_binary"test"; flush privileges; 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; drop table t1; # ------------------------------------------------------------------ # -- End of 4.1 tests # ------------------------------------------------------------------ # -- Bug#33507: Event scheduler creates more threads than max_connections # -- which results in user lockout. GRANT USAGE ON *.* TO mysqltest_u1@localhost; SET GLOBAL max_connections = 3; SET GLOBAL event_scheduler = ON; # -- Waiting for Event Scheduler to start... # -- Disconnecting default connection... # -- Check that we allow exactly three user connections, no matter how # -- many threads are running. # -- Connecting (1)... # -- Establishing connection 'con_1' (user: mysqltest_u1)... # -- Connection 'con_1' has been established. # -- Connecting (2)... # -- Establishing connection 'con_2' (user: mysqltest_u1)... # -- Connection 'con_2' has been established. # -- Connecting (3)... # -- Establishing connection 'con_3' (user: mysqltest_u1)... # -- Connection 'con_3' has been established. # -- Connecting (4) [should fail]... # -- Establishing connection 'con_4' (user: mysqltest_u1)... # -- Error: can not establish connection 'con_4'. # -- Check that we allow one extra SUPER-user connection. # -- Connecting super (1)... # -- Establishing connection 'con_super_1' (user: root)... # -- Connection 'con_super_1' has been established. # -- Connecting super (2) [should fail]... # -- Establishing connection 'con_super_2' (user: root)... # -- Error: can not establish connection 'con_super_2'. # -- Ensure that we have Event Scheduler thread, 3 ordinary user # -- connections and one extra super-user connection. SELECT user FROM information_schema.processlist ORDER BY id; user event_scheduler mysqltest_u1 mysqltest_u1 mysqltest_u1 root # -- Resetting variables... SET GLOBAL max_connections = 151; # -- Stopping Event Scheduler... SET GLOBAL event_scheduler = OFF; # -- Waiting for Event Scheduler to stop... # -- That's it. Closing connections... # -- Restoring default connection... # -- Waiting for connections to close... DROP USER mysqltest_u1@localhost; # -- End of Bug#33507. # -- Bug#35074: max_used_connections is not correct. FLUSH STATUS; SHOW STATUS LIKE 'max_used_connections'; Variable_name Value Max_used_connections 1 # -- Starting Event Scheduler... SET GLOBAL event_scheduler = ON; # -- Waiting for Event Scheduler to start... # -- Opening a new connection to check max_used_connections... # -- Check that max_used_connections hasn't changed. SHOW STATUS LIKE 'max_used_connections'; Variable_name Value Max_used_connections 2 # -- Closing new connection... # -- Stopping Event Scheduler... SET GLOBAL event_scheduler = OFF; # -- Waiting for Event Scheduler to stop... # -- End of Bug#35074. SELECT 'Connection on extra port ok'; Connection on extra port ok Connection on extra port ok SELECT 'Connection on extra port 2 ok'; Connection on extra port 2 ok Connection on extra port 2 ok # -- Success: more than --extra-max-connections + 1 normal connections not possible # # -- Bug#49752: 2469.126.2 unintentionally breaks authentication # against MySQL 5.1 server # GRANT ALL ON test.* TO 'Azundris12345678'@'localhost' IDENTIFIED BY 'test123'; FLUSH PRIVILEGES; DROP USER 'Azundris12345678'@'localhost'; FLUSH PRIVILEGES; # # -- End of Bug#49752 # # ------------------------------------------------------------------ # -- End of 5.1 tests # ------------------------------------------------------------------ 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); ERROR 28000: Access denied for user 'mysqltest_up1'@'localhost' (using password: YES) select user(), current_user(); user() current_user() mysqltest_up1@localhost mysqltest_up1@% connect(localhost,mysqltest_up2,newpw,test,MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'mysqltest_up2'@'localhost' (using password: YES) select user(), current_user(); user() current_user() mysqltest_up2@localhost mysqltest_up2@% connect(localhost,mysqltest_nouser,newpw,test,MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'mysqltest_nouser'@'localhost' (using password: YES) connect(localhost,mysqltest_nouser,,test,MASTER_PORT,MASTER_SOCKET); ERROR 28000: Access denied for user 'mysqltest_nouser'@'localhost' (using password: NO) DROP USER mysqltest_up1@'%'; DROP USER mysqltest_up2@'%';