diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2019-01-09 19:17:06 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2019-01-23 17:34:22 +0100 |
| commit | c2a4bfad223903931171c473c42646e93dd0e728 (patch) | |
| tree | 9e46bbc8a2e437452be522a304e225b330dd863d /mysql-test/t/connect.test | |
| parent | d24060b1796bac5b11aee49f1c157dfc2c8200c1 (diff) | |
| download | mariadb-git-c2a4bfad223903931171c473c42646e93dd0e728.tar.gz | |
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
Diffstat (limited to 'mysql-test/t/connect.test')
| -rw-r--r-- | mysql-test/t/connect.test | 5 |
1 files changed, 5 insertions, 0 deletions
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); |