From dcde1be17d1467c582d75d13968e0b8ab4f44611 Mon Sep 17 00:00:00 2001
From: "bar@mysql.com/bar.intranet.mysql.r18.ru" <>
Date: Thu, 30 Nov 2006 11:08:23 +0400
Subject: Bug#24158 SET PASSWORD in binary log fails under ANSI_QUOTES Problem:
 ``SET PASSWORD FOR foo@localhost'' was written into binary log using double
 quites: ``SET PASSWORD FOR "foo"@"localhost"...''. If sql_mode was set to
 ANSI_QUOTES, parser on slave considered "foo" and "localhost" as identifiers
 instead of strigns constants, so it failed to parse, generated syntax error
 and slave then stopped. Fix: changing binary log entries to use single
 quotes: ``SET PASSWORD FOR 'foo'@'localhost'...'' not to depend on
 ANSI_QUOTES.

---
 sql/sql_acl.cc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql')

diff --git a/sql/sql_acl.cc b/sql/sql_acl.cc
index 724cf88d373..be5591ce3d7 100644
--- a/sql/sql_acl.cc
+++ b/sql/sql_acl.cc
@@ -1498,7 +1498,7 @@ bool change_password(THD *thd, const char *host, const char *user,
   {
     query_length=
       my_sprintf(buff,
-                 (buff,"SET PASSWORD FOR \"%-.120s\"@\"%-.120s\"=\"%-.120s\"",
+                 (buff,"SET PASSWORD FOR '%-.120s'@'%-.120s'='%-.120s'",
                   acl_user->user ? acl_user->user : "",
                   acl_user->host.hostname ? acl_user->host.hostname : "",
                   new_password));
-- 
cgit v1.2.1