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?

Showing messages 1 through 2 of 2.

• 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.
• grant lock?
  2003-06-08 15:13:07  anonymous2 [Reply | View]
  
  
  Thanks for the reassurance that what I did was okay.
  Now, about the editing issues...
  I checked over at sourceforge and it seems phpwiki DOES NOT WORK with php 4.3.0 on Mac OSX. So it's my non-apple PHP installation causing the problems (which I need for GD stuff).
  The workaround suggested is way beyond my capabilities as a moderate php programmer so I guess I'll have to wait to get my wiki up and running.