Robert Cross writes:
>
> I've got a wierd problem with 3.23.38, built from source, running on RedHat
> v6.2 (Intel). Put simply the wildcard character for user access doesn't
> work. From my reading of the docs any of the following:
>
> grant all on mtdb.* to user1 identified by "bozo1";
> grant all on mtdb.* to user2@"%" identified by "bozo2";
>
> should allow the specified users access to the mtdb database from any host
> (assuming that they can input the password correctly!).
>
> Well - it doesn't work. Unless I GRANT for each user on each system that
> they are likely to use they can't get in and get error 1045 - access
> denied.
>
> Am I doing something terminally stupid, is there something wrong with my
> build, or is it a bug?
>
> Ta
>
> Bob Cross.
Hi!
Try first granting USAGE on *.* to both users with 'identified by ...'
and then try granting database rights.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ 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
