RE: [PHP-DB] Lock Tables Privileges

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

From: Justin Turner <trnr@reslife.rochester.edu> To: php-db@lists.php.net Subject: [PHP-DB] 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