I wrote:
>> 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.
Mr. Sinisa Milivojevic replied:
>Try first granting USAGE on *.* to both users with 'identified by ...'
>and then try granting database rights.
Thanks Sinisa, that works perfectly. I've now got a wonderful small and
fast database
that I can let the users into!
Bob Cross.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
This message is confidential. It may also be privileged or
protected by other legal rules. It does not constitute an
offer or acceptance of an offer, nor shall it form any part
of a legally binding contract. If you have received this
communication in error, please let us know by reply then
destroy it. You should not use, print, copy the message or
disclose its contents to anyone.
E-mail is subject to possible data corruption, is not
secure, and its content does not necessarily represent the
opinion of this Company. No representation or warranty is
made as to the accuracy or completeness of the information
and no liability can be accepted for any loss arising from
its use.
This e-mail and any attachments are not guaranteed to be
free from so-called computer viruses and it is recommended
that you check for such viruses before down-loading it to
your computer equipment. This Company has no control over
other websites to which there may be hypertext links and no
liability can be accepted in relation to those sites.
Scottish & Newcastle plc
Registered in Scotland, Registered Number 16288
Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
---------------------------------------------------------------------
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
