I've got a user, joe, who has all privileges on database 'joe' except GRANT. I gave permissions to joe using this command: GRANT ALL ON joe TO [EMAIL PROTECTED]
But if I'm logged in as joe to the joe db and try to create a table, I get the error: ERROR 1142: create command denied to user: '[EMAIL PROTECTED]' for table 'test' What could be wrong here? -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales http://www.systame.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]