From c2a4bfad223903931171c473c42646e93dd0e728 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Wed, 9 Jan 2019 19:17:06 +0100 Subject: MDEV-18119 upgrading from 10.3 to 10.4 can result in the password for a user to be wiped out 10.1 part: SHOW CREATE USER didn't show the password, if plugin was set, but authentication_string was not --- mysql-test/t/connect.test | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'mysql-test/t/connect.test') diff --git a/mysql-test/t/connect.test b/mysql-test/t/connect.test index 3a38ad88462..560f29e840d 100644 --- a/mysql-test/t/connect.test +++ b/mysql-test/t/connect.test @@ -66,8 +66,13 @@ connect (fail_con,localhost,test,zorro,test2); connect (fail_con,localhost,test,zorro,); # check if old password version also works +select user,host,password,plugin,authentication_string from mysql.user where user='test'; update mysql.user set password=old_password("gambling2") where user=_binary"test"; flush privileges; +show grants for test@localhost; +update mysql.user set plugin='mysql_old_password' where user='test'; +flush privileges; +show grants for test@localhost; connect (con10,localhost,test,gambling2,); connect (con5,localhost,test,gambling2,mysql); -- cgit v1.2.1