If you're GRANTing privileges to mydb.* why is the error message reporting that you are not allowed access to the database 'registration'? >GRANT ALL PRIVILEGES ON mydb.* TO 'thisUser'@'localhost' IDENTIFIED BY >'myPassword'; >ERROR 1044 (42000): Access denied for user 'thisUser'@'localhost' to >database 'registration' -----Original Message----- From: Bastien Koert [mailto:bastien_k@xxxxxxxxxxx] Sent: Monday, August 15, 2005 9:56 AM To: trnr@xxxxxxxxxxxxxxxxxxxxx; php-db@xxxxxxxxxxxxx Subject: RE: Lock Tables Privileges 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
