RE: [Phpwiki-talk] MySQL error on upgrade

[Frank S. <fra...@rn...>]

Hi James,

> I've been using PHPWiki for a while now and finding it very useful. I
> just upgraded from a previous 1.3.x to 1.3.4, by copying files across
> and then editing index.php to put my mysql  details back in. My mysql
> details are correct but when I load  the page I get the error:
>
> lib/WikiDB/backend/PearDB.php:680: 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=Access
>   denied for user: 'anthropi_wiki@192.168.1.%' to database
>   'anthropi_wiki'])

Are you sure your permissions are correct? It looks just like
'anthropi_wiki@192.168.1.%' doesn't have the necessary permissions on
anthropi_wiki.*.

I use "grant select, update, delete, insert, lock tables on wikidb.* to
user@host;"

frank