diff options
| author | Nirbhay Choubey <nirbhay@mariadb.com> | 2014-12-05 12:33:02 -0500 |
|---|---|---|
| committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2014-12-05 12:33:02 -0500 |
| commit | 3bb02f3e6d70687b02c6902fd6478e8c328608f8 (patch) | |
| tree | 7962068cae78450246a484cf95cbe5cf2e37382a /mysql-test/t/mysql_upgrade-6984.test | |
| parent | a4cdd20d49a5a6ca0eb7346b7b9e898ac5e7995b (diff) | |
| parent | ffc0ef63164e9a121d8a02323afe32a82299171e (diff) | |
| download | mariadb-git-3bb02f3e6d70687b02c6902fd6478e8c328608f8.tar.gz | |
bzr merge -rtag:mariadb-10.0.15 maria/10.0
Diffstat (limited to 'mysql-test/t/mysql_upgrade-6984.test')
| -rw-r--r-- | mysql-test/t/mysql_upgrade-6984.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/mysql_upgrade-6984.test b/mysql-test/t/mysql_upgrade-6984.test new file mode 100644 index 00000000000..6f10d3f33e9 --- /dev/null +++ b/mysql-test/t/mysql_upgrade-6984.test @@ -0,0 +1,22 @@ +# +# MDEV-6984 Can't migrate from MySQL 5.6.21 to MariaDB 10 +# +--source include/not_embedded.inc + +# +# When 'root' account is password protected and MYSQL_UPGRADE doesn't +# know the password (meaning, MYSQL_UPGRADE is run automatically +# on upgrade), MYSQLD has to be started with --skip-grant-tables. +# +# In this setup MYSQL_UPGRADE cannot continue after issuing FLUSH PRIVILEGES +# + +update mysql.user set password=password("foo") where user='root'; + +--exec $MYSQL_UPGRADE + +connect(con1,localhost,root,foo,,,); + +update mysql.user set password='' where user='root'; +flush privileges; + |