summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorVladislav Vaintroub <wlad@mariadb.com>2020-03-25 18:16:36 +0100
committerVladislav Vaintroub <wlad@mariadb.com>2020-03-25 18:18:08 +0100
commit3a1075b93ed75c47e3c1e6819a406fcf355bb6fa (patch)
tree2164c8a3a170f91a7e2596fdff3cccb19545faeb
parent497a4169df5cd9837efd7a32b16426c92e3da882 (diff)
downloadmariadb-git-3a1075b93ed75c47e3c1e6819a406fcf355bb6fa.tar.gz
MDEV-19519 mysql_install_db.exe doesn't set password_last_changed for newly created password
-rw-r--r--sql/mysql_install_db.cc3
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/mysql_install_db.cc b/sql/mysql_install_db.cc
index 54bd46240bc..b841c64c331 100644
--- a/sql/mysql_install_db.cc
+++ b/sql/mysql_install_db.cc
@@ -364,11 +364,12 @@ static int create_myini()
static const char update_root_passwd_part1[]=
"UPDATE mysql.global_priv SET priv=json_set(priv,"
+ "'$.password_last_changed', UNIX_TIMESTAMP(),"
"'$.plugin','mysql_native_password',"
"'$.authentication_string',PASSWORD(";
static const char update_root_passwd_part2[]=
")) where User='root';\n";
-static const char remove_default_user_cmd[]=
+static const char remove_default_user_cmd[]=
"DELETE FROM mysql.user where User='';\n";
static const char allow_remote_root_access_cmd[]=
"CREATE TEMPORARY TABLE tmp_user LIKE global_priv;\n"