diff options
| author |   Preston Cody <codeman@gentoo.org> | 2007-12-31 22:16:59 +0000 |
|---|---|---|
| committer | Preston Cody <codeman@gentoo.org> | 2007-12-31 22:16:59 +0000 |
| commit | 9d25fa916b3ad3f931aa49b8e9ab82ed127c7528 (patch) | |
| tree | 60023bff5eef7aa8d392d5f471b998d55feacfab /docs | |
| parent | change default username/password to something more...sane (diff) | |
| download | scire-9d25fa916b3ad3f931aa49b8e9ab82ed127c7528.tar.gz scire-9d25fa916b3ad3f931aa49b8e9ab82ed127c7528.tar.bz2 scire-9d25fa916b3ad3f931aa49b8e9ab82ed127c7528.zip | |
add LOCK TABLES to grant lines.
svn path=/trunk/; revision=297
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/scire.sql | 4 |
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; |