Hi, Using MySQL 4.0.5a, GRANT is correctly adding users (and the privileges are working), but when you view the mysql.user table, all privileges are showing up as 'N', when some of them should be 'Y'. Anybody seen this or understand what's going on?
For example: GRANT SELECT ON dbname.* TO test@localhost IDENTIFIED BY 'testpass'; flush privileges; SELECT * FROM USER WHERE User='test'; It will show 'N' in all privilege columns which is wrong. It should show a 'Y' in the select_priv column. Is this a bug/feature or what? Thanks, John Dell [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
