RE: Lock Tables Privileges

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'd say you are not connecting to the db at all...is that the case?

Bastien


From: Justin Turner <trnr@xxxxxxxxxxxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject:  Lock Tables Privileges
Date: Mon, 15 Aug 2005 09:09:04 -0400

I have tried several times to create a user that has the ability to lock and unlock tables, but to no avail. Am I missing something? I tried creating a user with all privileges to a database and still the user does not have the ability to lock/unlock tables within that database.

GRANT ALL PRIVILEGES ON mydb.* TO 'thisUser'@'localhost' IDENTIFIED BY 'myPassword';

When I log in as "thisUser" and execute LOCK TABLE myTable WRITE (or READ) I get the following error:

Note: Assume myTable is a table that exists in the mydb database.

ERROR 1044 (42000): Access denied for user 'thisUser'@'localhost' to database 'registration'

What am I doing wrong?

Justin

Version: MySQL 4.1 (rpm)


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux