re: MySQL4 user table not showing GRANT privileges correctly

2002-12-14 Thread Victoria Reznichenko
On Saturday 14 December 2002 02:49, John Dell wrote: > 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 g

MySQL4 user table not showing GRANT privileges correctly

2002-12-14 Thread John Dell
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