Add support for renaming users on MySQL versions less than 5.0.2 by directly updating the mysql.user table. Fixes issue #1285.

1 files changed, 5 insertions, 0 deletions

diff --git a/Source/SPServerSupport.m b/Source/SPServerSupport.m
index 3d38ff79..5ddfbaf6 100644
--- a/Source/SPServerSupport.m
+++ b/Source/SPServerSupport.m
@@ -50,6 +50,7 @@
 @synthesize supportsCharacterSetDatabaseVar;
 @synthesize supportsPost41CharacterSetHandling;
 @synthesize supportsCreateUser;
+@synthesize supportsRenameUser;
 @synthesize supportsDropUser;
 @synthesize supportsFullDropUser;
 @synthesize supportsUserMaxVars;
@@ -141,6 +142,9 @@
 	// The CREATE USER statement wasn't added until MySQL 5.0.2
 	supportsCreateUser = [self isEqualToOrGreaterThanMajorVersion:5 minor:0 release:2];
 	
+	// The RENAME USER statement wasn't added until MySQL 5.0.2
+	supportsRenameUser = [self isEqualToOrGreaterThanMajorVersion:5 minor:0 release:2];
+	
 	// The DROP USER statement wasn't added until MySQL 4.1.1
 	supportsDropUser = [self isEqualToOrGreaterThanMajorVersion:4 minor:1 release:1];
 	
@@ -249,6 +253,7 @@
 	supportsCharacterSetDatabaseVar         = NO;
 	supportsPost41CharacterSetHandling      = NO;
 	supportsCreateUser                      = NO;
+	supportsRenameUser                      = NO;
 	supportsDropUser                        = NO;
 	supportsFullDropUser                    = NO;
 	supportsUserMaxVars                     = NO;