> Indeed, when I used 'Ken'@'localhost', the subsequent connection
> worked. When the "@" part is omitted, the [Host] defaults to "%", but
> this does not work. Nor does it work when the only entry is for [Host]
> = '%', even though the documentation implies that this should work.
> Indeed the documentation indicates that <Ken> and <'Ken'> are short
> forms for <'Ken'@'%'>, but there is no mention of the fact that a user
> cannot log in if this is the only form in the [user] table!
Were you expecting to be able to log on from the localhost by using '%'?
In MySQL, '%' and localhost are two separate sets of addresses. Localhost
is the localhost and '%' is everything else with no overlap. This might
be what was causing the confusion.
Just a guess and just my $.01.
But hey! It's working!
Mark
- - -
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|