List:Commits« Previous MessageNext Message »
From:Georgi Kodinov Date:July 14 2010 10:53am
Subject:bzr commit into mysql-5.1-bugteam branch (Georgi.Kodinov:3479) Bug#54004
View as plain text  
#At file:///home/kgeorge/mysql/work/B54004-5.1-bugteam/ based on revid:georgi.kodinov@stripped

 3479 Georgi Kodinov	2010-07-14
      Bug #54004 : mysql_secure_installation identifies "local host" incorrectly
      
      The removal of non-local root users is overzealous in
      mysql_secure_installation. (Bug #54004)

    modified:
      scripts/mysql_secure_installation.pl.in
      scripts/mysql_secure_installation.sh
=== modified file 'scripts/mysql_secure_installation.pl.in'
--- a/scripts/mysql_secure_installation.pl.in	2009-11-03 21:34:01 +0000
+++ b/scripts/mysql_secure_installation.pl.in	2010-07-14 10:53:49 +0000
@@ -208,7 +208,7 @@ sub remove_anonymous_users {
 }
 
 sub remove_remote_root {
-  if (do_query("DELETE FROM mysql.user WHERE User='root' AND Host!='localhost';")) {
+  if (do_query("DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');")) {
     print " ... Success!\n";
   } else {
     print " ... Failed!\n";

=== modified file 'scripts/mysql_secure_installation.sh'
--- a/scripts/mysql_secure_installation.sh	2010-07-09 11:11:12 +0000
+++ b/scripts/mysql_secure_installation.sh	2010-07-14 10:53:49 +0000
@@ -164,7 +164,7 @@ remove_anonymous_users() {
 }
 
 remove_remote_root() {
-    do_query "DELETE FROM mysql.user WHERE User='root' AND Host!='localhost';"
+    do_query "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');"
     if [ $? -eq 0 ]; then
 	echo " ... Success!"
     else


Attachment: [text/bzr-bundle] bzr/georgi.kodinov@oracle.com-20100714105349-fevld24chedai0dy.bundle
Thread
bzr commit into mysql-5.1-bugteam branch (Georgi.Kodinov:3479) Bug#54004Georgi Kodinov14 Jul