hi all, i am running OS X 10.2 and this version of mysql:
mysql> status -------------- ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) Connection id: 117 Current database: mysql Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.51-entropy.ch Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 4 hours 15 min 17 sec php 4.2.1 also by entropy.ch my problem is the following: let's say i want to add the following user (just as a test): mysql> grant all -> on * -> to test -> with grant option; i do that and then i do a mysql> use mysql; mysql> SELECT * FROM user; the thing is, that all the permissions are still set to 'N'!! it won't accept the grant arguments. i also have phpMyAdmin 2.3.0 installed and if i change the user's permissions in there it accepts them. also the terminal will list them properly. why is this happening? please advise, phil --------------------------------------------------------------------- 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