summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPreston Cody <codeman@gentoo.org>2007-12-31 22:16:59 +0000
committerPreston Cody <codeman@gentoo.org>2007-12-31 22:16:59 +0000
commit9d25fa916b3ad3f931aa49b8e9ab82ed127c7528 (patch)
tree60023bff5eef7aa8d392d5f471b998d55feacfab
parentchange default username/password to something more...sane (diff)
downloadscire-9d25fa916b3ad3f931aa49b8e9ab82ed127c7528.tar.gz
scire-9d25fa916b3ad3f931aa49b8e9ab82ed127c7528.tar.bz2
scire-9d25fa916b3ad3f931aa49b8e9ab82ed127c7528.zip
add LOCK TABLES to grant lines.
svn path=/trunk/; revision=297
-rw-r--r--docs/scire.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/docs/scire.sql b/docs/scire.sql
index b9e2280..b3c7a7d 100644
--- a/docs/scire.sql
+++ b/docs/scire.sql
@@ -1,6 +1,6 @@
CREATE DATABASE IF NOT EXISTS scire;
-GRANT SELECT, INSERT, UPDATE, DELETE ON scire.* TO 'scire' IDENTIFIED BY 'scire';
-GRANT SELECT, INSERT, UPDATE, DELETE ON scire.* TO 'scire'@'localhost' IDENTIFIED BY 'scire';
+GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON scire.* TO 'scire' IDENTIFIED BY 'scire';
+GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON scire.* TO 'scire'@'localhost' IDENTIFIED BY 'scire';
ALTER DATABASE scire DEFAULT CHARACTER SET latin1;
USE scire;