diff options
author | Jonas Smedegaard <dr@jones.dk> | 2003-05-19 23:45:56 +0000 |
---|---|---|
committer | Jonas Smedegaard <dr@jones.dk> | 2003-05-19 23:45:56 +0000 |
commit | d1a2833a2bf5e8d1c07cd102cc43b5c5e8b5fee4 (patch) | |
tree | aefda0636ac275f45fe630091918c9df5adb4f7d /localaddmysqldb | |
parent | 9c97f049d90b07b9afddea2bd00150ba2ebd96bd (diff) |
Allow DELETE for ordinary MySQL accounts.
Diffstat (limited to 'localaddmysqldb')
-rwxr-xr-x | localaddmysqldb | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/localaddmysqldb b/localaddmysqldb index 71a566c..8385e8c 100755 --- a/localaddmysqldb +++ b/localaddmysqldb @@ -3,7 +3,7 @@ # /usr/local/sbin/localaddmysqldb # Copyright 2001-2002 Jonas Smedegaard <dr@jones.dk> # -# $Id: localaddmysqldb,v 1.2 2003-05-12 03:40:20 jonas Exp $ +# $Id: localaddmysqldb,v 1.3 2003-05-19 23:45:56 jonas Exp $ # # Add/update MySQL database # @@ -262,12 +262,12 @@ if [ -e /usr/share/wwwconfig-common/mysql-createuser.sh ] ; then fi for h in `echo "localhost $dballow" | sort -u`; do # mysql -u$dbadmin -p$dbadmpass $optdbserver mysql -e "GRANT INDEX ON $dbname.* TO '$dbuser'@'$h';" - mysql -u$dbadmin -p$dbadmpass $optdbserver mysql -e "REVOKE DELETE,CREATE,DROP ON $dbname.* FROM '$dbuser'@'$h';" + mysql -u$dbadmin -p$dbadmpass $optdbserver mysql -e "REVOKE CREATE,DROP ON $dbname.* FROM '$dbuser'@'$h';" done else for h in `echo "localhost $dballow" | sort -u`; do # mysql -u$dbadmin -p$dbadmpass $optdbserver mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX ON $dbname.* TO '$dbuser'@'$h' IDENTIFIED BY '$dbpass';" - mysql -u$dbadmin -p$dbadmpass $optdbserver mysql -e "GRANT SELECT,INSERT,UPDATE ON $dbname.* TO '$dbuser'@'$h' IDENTIFIED BY '$dbpass';" + mysql -u$dbadmin -p$dbadmpass $optdbserver mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE ON $dbname.* TO '$dbuser'@'$h' IDENTIFIED BY '$dbpass';" done fi |