From fe7159bb1bce1d1bbadb3c9954431d9de2c97bdf Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 16 Mar 2004 19:30:22 +0400 Subject: fixed bug #3160 '"mysqladmin password" doesn't work if --skip-grant-tables' --- client/mysqladmin.c | 27 ++++++++++++++++++++++++--- 1 file changed, 24 insertions(+), 3 deletions(-) diff --git a/client/mysqladmin.c b/client/mysqladmin.c index f263d321a7b..7fcba3cf803 100644 --- a/client/mysqladmin.c +++ b/client/mysqladmin.c @@ -787,9 +787,30 @@ static int execute_commands(MYSQL *mysql,int argc, char **argv) } if (mysql_query(mysql,buff)) { - my_printf_error(0,"unable to change password; error: '%s'", - MYF(ME_BELL),mysql_error(mysql)); - return -1; + if (mysql_errno(mysql)!=1290) + { + my_printf_error(0,"unable to change password; error: '%s'", + MYF(ME_BELL),mysql_error(mysql)); + return -1; + } + else + { + sprintf(buff,"UPDATE mysql.user SET password='%s' WHERE user='%s' and" + " host=substring_index(user(),_utf8\"@\",-1)", + crypted_pw, user); + if (mysql_query(mysql,buff)) + { + my_printf_error(0,"unable to update user table; error: '%s'", + MYF(ME_BELL),mysql_error(mysql)); + return -1; + } + if (mysql_query(mysql,"set sql_log_off=0")) + { + my_printf_error(0, "Can't turn on logging; error: '%s'", + MYF(ME_BELL),mysql_error(mysql)); + return -1; + } + } } argc--; argv++; break; -- cgit v1.2.1