diff options
| author | Staale Smedseng <staale.smedseng@sun.com> | 2009-03-31 12:59:22 +0200 |
|---|---|---|
| committer | Staale Smedseng <staale.smedseng@sun.com> | 2009-03-31 12:59:22 +0200 |
| commit | ab958ee0bd28986389d5c612af5821e8088c1104 (patch) | |
| tree | 8431a8145d63bbdf35eac9ef3e396bd0de00809a /scripts/mysql_setpermission.sh | |
| parent | 497b8c2df9f58fadfc99a444e72e67af8231717a (diff) | |
| download | mariadb-git-ab958ee0bd28986389d5c612af5821e8088c1104.tar.gz | |
Bug #39852 bug in mysql_setpermission
mysql_setpermission is modified to honor the $db
variable as suggested when doing a REVOKE ALL for
menu option 7.
Diffstat (limited to 'scripts/mysql_setpermission.sh')
| -rw-r--r-- | scripts/mysql_setpermission.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/scripts/mysql_setpermission.sh b/scripts/mysql_setpermission.sh index 1f5509f9955..b1ea26a9b7d 100644 --- a/scripts/mysql_setpermission.sh +++ b/scripts/mysql_setpermission.sh @@ -257,7 +257,7 @@ sub addall { $sth = $dbh->do("GRANT ALL ON $db.* TO \'$user\'\@\'$host\' IDENTIFIED BY \'$pass\'") || die $dbh->errstr; } elsif ($todo == 7) { # all privileges set to N - $sth = $dbh->do("REVOKE ALL ON *.* FROM \'$user\'\@\'$host\'") || die $dbh->errstr; + $sth = $dbh->do("REVOKE ALL ON $db.* FROM \'$user\'\@\'$host\'") || die $dbh->errstr; } } $dbh->do("FLUSH PRIVILEGES") || print STDERR "Can't flush privileges\n"; |