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
