Re: [Phpwiki-talk] PhpWiki + PHP + Apache + Windows

[Reini U. <ru...@x-...>]

Patrick Ouellet schrieb:
> d:\inetpub\phpwiki137\lib\WikiDB\backend\PearDB.php:698: Fatal[256]: 
> wikidb_backend_mysql: fatal database error
> 
>    * DB Error: unknown error
>    * (LOCK TABLES page WRITE,version WRITE,link WRITE,recent
>      WRITE,nonempty WRITE [nativecode=1044 ** Access denied for user:
>      'phpwiki@127.0.0.1' to database 'phpwiki'])
> 
> What I dont understand is that.. if I use the command line client for mysql
> I can connect to the database as phpwiki, and freely insert,
> delete, select and update records in all the table mentioned in the error
> message (which are all the phpwiki tables...)

You need to have the permission to LOCK the table, select is not enough.

info mysql:
   The privileges CREATE TEMPORARY TABLES, EXECUTE, LOCK TABLES, 
REPLICATION ..., SHOW DATABASES and SUPER are new for in version 4.0.2. 
To use these new privileges after upgrading to 4.0.2, you have to run 
the mysql_fix_privilege_tables script.
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/