On Thursday, 28. February 2002 12:02, you wrote: Hello Victoria Reznichenko,
thanks for your answer, but i think this is not absolutly true > JH> As i read the manual i think the %-wildcard includes localhost . > JH> But i can not get it to work that way :( > JH> My users have to have access from localhost and remote hosts to > JH> this DB. > > '%' means that you can connect via TCP/IP; > 'localhost' means connection via Unix socket. As of http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Adding_users "A Host value of '%' matches any hostname. " This should include the host "localhost". After some RTFM again i found in the same manual: +-----------+----------+- | Host | User | ... +-----------+----------+- | localhost | root | ... | localhost | | ... | % | jeffrey | ... | % | root | ... +-----------+----------+- "When a connection is attempted, the server looks through the sorted entries and uses the first match found. For a connection from localhost by jeffrey, the entries with 'localhost' in the Host column match first. Of those, the entry with the blank user name matches both the connecting hostname and user name. (The '%'/'jeffrey' entry would have matched, too, but it is not the first match in the table.) " The Host="localhost" User="" entry was the problem ! I deleted it - and all worked like i expected :-) But now there is the next question : This entry ""@localhost was made my mysql_install_db . Do i need it ? What was ist good for ? Will i have problems without it ? regards Jörg -- Joerg Hartmann mediadesign akademie Phone: +49 340 253 20 23 [EMAIL PROTECTED] Fax: +49 340 253 20 10 --------------------------------------------------------------------- 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
