How to perform a lock under mysql??

[leonardo]

Hello,

I'am using some php-code to lock a mysql table but the user I created under directadmin doesn't have te rights to perform a lock.

Is there a place where I can change this?? I'm reseller on a server.

I Have found all the option for a mysql user but locking a table is not mentioned there.

Thanks, Leon

 

[DirectAdmin Support]

Hello,

For backwards compatibility with mysql 3, we can't enable privileges that don't exist in the user table. That' why it's not there.

John

 

[leonardo]

I find a bit strange why you are blocking a new feature in mysql to stay compatible whit a old version.
But i think you have a good reason for it.

Do you maybe have a solution so i can use the lock function or is that not possible?

 

[ProWebUK]

if you just need extra privileges for a DB or user, log into phpmyadmin as root (i think the username is admin for DA) and edit the privileges...

Chris