Have you done a 'mysqladmin reload' to reload the new grant tables
into the server process? Any modifications you make to the permissions
table won't take until until after a 'reload'.
Rene
philipp ringli wrote:
> 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
>
>
>
--
Rene Churchill Specializing in Internet Databases,
Vermont Web Wizard LLC Web Programming, Webmaster support,
Phone: 802-244-5151 and custom programming.
Fax: 802-244-5512
http://www.vtwebwizard.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
