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. also after a mysqladmin reload!
i also have phpMyAdmin 2.3.0 installed and if i change the user's
permissions in there, it accepts them. then 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
