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