Hi!
>>>>> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> 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.
Sinisa> Hi!
Sinisa> Try first granting USAGE on *.* to both users with 'identified by ...'
Sinisa> and then try granting database rights.
grant all on mtdb.* to user2@"%" identified by "bozo2";
Should be enough to give the user full access to the mtdb database, if
there is no user2 entry that is more specific for the user/host
combination.
Roger, what error do you get when you try to connect as user2 ?
The error message itself should tell us exactly what is wrong.
(This is documented in the 'Access denied' section of the MySQL manual)
Regards,
Monty
---------------------------------------------------------------------
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
