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