Nevermind, I had a lingering entry in the db table. Once I deleted that it worked as expected.
Denise Lopez UCLA Center for Digital Humanities Network Services Systems Engineer 337 Charles E. Young Drive East PPB 1020 Los Angeles, CA 90095 310/206-8216 -----Original Message----- From: Lopez, Denise [mailto:[EMAIL PROTECTED] Sent: Thursday, April 05, 2007 4:08 PM To: mysql@lists.mysql.com Subject: Privileges question. Hi all, I am trying to create a user with only SELECT,INSERT,UPDATE,DELETE privileges on a database. My question is when I type show grants for the user I create, it says the user has full privileges over the database and I only want them to have the ones listed above. mysql > grant SELECT,INSERT,UPDATE,DELETE on database.* to [EMAIL PROTECTED] identified by 'password'; mysql > flush privileges; mysql > show grants for [EMAIL PROTECTED]; GRANT USAGE ON *.* TO 'user'@'localhost' IDENTIFIED BY PASSWORD 'encrypted' GRANT ALL PRIVILEGES ON `database`.* TO 'user'@'localhost' These are the same privileges if I were to grant all privileges for a user. Any help would be appreciated. Denise Lopez UCLA Center for Digital Humanities Network Services Systems Engineer 337 Charles E. Young Drive East PPB 1020 Los Angeles, CA 90095 310/206-8216 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]