Riaan Oberholzer <[EMAIL PROTECTED]> wrote:
> This follows on a previous mail from me:
>
> When using
> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
> ?password?
>
> I could not get the password authentication to kick
> in. Only supplying no password (empty string)
> succeeded. Even after doing ?SET PASSWORD?? and ?FLUSH
> PRIVILEGES?.
>
> Then I tried
> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
> ?password?
>
> And now it works ? the new password must be supplied
> for the user to logon.
> Does the ?%? domain not include the localhost domain?
Include, '%' means any host. But when MySQL reads privilege table, it find first match
entry. So if you have ''@'localhost', it will be taken. You can read more about
connection verification at:
http://www.mysql.com/doc/en/Connection_access.html
> If not, what is the use of the ?%? domain? When should
> I use ?%? and when ?localhost? ?
Remove from table 'user' entry ''@'localhost'.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]