philipp,
Wednesday, September 11, 2002, 8:10:04 PM, you wrote:
pr> i am running OS X 10.2 and
pr> this version of mysql:
pr> mysql> status
pr> --------------
pr> ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc)
pr> my problem is the following:
pr> let's say i want to add the following user (just as a test):
pr> mysql> grant all
pr> -> on *
pr> -> to test
pr> -> with grant option;
pr> i do that and then i do a
pr> mysql> use mysql;
pr> mysql> SELECT * FROM user;
pr> the thing is, that all the permissions are still set to 'N'!! it won't
pr> accept the grant arguments.
pr> i also have phpMyAdmin 2.3.0 installed and if i change the user's
pr> permissions in there it accepts them. also the terminal will list them
pr> properly.
pr> why is this happening?
Because you have current database. In this case if you specified ON *
it will affect only database privileges, not global:
http://www.mysql.com/doc/en/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
