advertisement

Article:
  Installing a Wiki on Your iBook
Subject:   grant lock?
Date:   2003-06-07 14:15:54
From:   anonymous2
This line...
> grant select, insert, update, delete, lock tables on wiki.* to wiki@localhost identified by 'password';


results in an error:


You have an error in your SQL syntax near 'lock tables on wiki.* to wiki@localhost identified by 'password'' at line 1


I already had MySQL installed from a long time back, and I checked the manual, there is no LOCK priv_type. I left out that part of the line and everyting else seemed to go fine.
I don't know if it's connected but I cannot edit any pages. Whenever I click on an edit link I get an error on my browser saying the document contained no data or it just hangs with no results at all.
I should also mention I'm not using the Apple installed version of PHP but the package from Entropy.ch. Are any of these things affecting my wiki installation?
Main Topics Oldest First

Showing messages 1 through 1 of 1.

  • grant lock?
    2003-06-08 12:36:26  matt_hunt [Reply | View]

    We used MySQL 4 for the article but it looks like you're probably using MySQL 3. If you leave out the "lock tables" part of the grant line everything should be just fine.

    Greater locking control is one of the improvements (depending on how you look at it) of the latest MySQL version. In general it is a great improvement but it can cause problems when you move from one version to the other without reading the upgrade documents (that was my experience, at least).

    Matt.