- tested permissions

Changed files:
    php-pecl-session_mysql.sql -> 1.3

diff --git a/php-pecl-session_mysql.sql b/php-pecl-session_mysql.sql
index b81b9596a84629815423dce0c27657e0f134f1a2..58a2098895deae6d38e092307b7c922ceb2adc68 100644 (file)
--- a/php-pecl-session_mysql.sql
+++ b/php-pecl-session_mysql.sql
@@ -1,12 +1,14 @@
 /*
 
-create database phpsession;
--- note it probably needs less privileges:
-grant all privileges on phpsession.* to phpsession identified by "phpsession";
-use phpsession;
+CREATE DATABASE phpsession;
+
+GRANT SELECT,UPDATE,INSERT,DELETE
+    ON phpsession.* TO 'phpsession'@'localhost' IDENTIFIED BY 'phpsession';
+
+USE PHPSESSION;
 */
 
-create table phpsession (
+CREATE TABLE phpsession (
        sess_key char(64) not null,
        sess_mtime int(10) unsigned not null,
        sess_host char(64) not null,