I have a question about MySQL acces:

In order to give access to any user on my server I have to give them 
"localhost', 'myserverName' and 'MyUserIP' entry in both user and db table, 
I thought I only had to set '%' in the user.Host columns and db.host = 
'192.168.111.%' to give access to my user for any computer on my network. 
If I do so, I have an error Access denied for user: 'le2k@'myserverName' 
(Using password: YES) then, I had a row with the same right except host 
that is 'myserverName' and then I have the same access denied exception 
with 'localhot' (Access denied for user: 'le2k@'localhost' (Using password: 
YES)) and if I had a row with 'localhost' then it work.

This means that I have to add 3 row for one user where I though I could 
only set the IP branch. Could any one explain me, if I have to set 3 times 
the same right, is it a bug or do I mistake myself.


My version is 3.22.32 Linux Red Hat 6.2 PII 400 256Mo Ram and 9 Go of Hard 
Drive.


---------------------------------------------------------------------
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

Reply via email to