PDA

View Full Version : mysql locking


abomb
01-08-2004, 11:07 AM
Trying to install phpWebSite and everything almost works fine. But when trying to use the Menu Manager in it, the following error occurs...

"LOCK TABLES mod_menuman_items WRITE error 1044" etc.

When I checked their site, they mentioned that it has to do with Locks needing to be granted with MySQL 4.x...

I even supplied my host with a link that explains how it's done. The global locking needed for version 4.x of MySQL requires a command to be typed in at root. So I can't do it myself.


My host PWS said they didn't think it could be done with DirectAdmin but I don't see how DA can stop it. But seeing if there is something that can be done. Or if DA is not anyway causing the problem.

Thanks. :)

DirectAdmin Support
01-09-2004, 10:51 AM
Hello,

User Panel -> Mysql -> Database -> Database User, modify privielges -> Lock Tables to "Yes" -> click "save" :)

John