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:[EMAIL PROTECTED] Sent: Monday, August 15, 2005 9:56 AM To: [EMAIL PROTECTED]; php-db@lists.php.net Subject: 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 <[EMAIL PROTECTED]> >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 -- 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
