> Hi ppl, > > When I set database and user host to "%" I can't connect to > database when using localhost - authorization fails. > When I connect using domain name, every things works fine. > > Q1: What is the problem using localhost?
No problem - just a different type of connection. When you specify "localhost", you're also saying "accept connections through a socket". When you say "%" or some derivation thereof, you're telling the server to accept connections through TCP/IP. > Q2: How can I set default localhost to domain name? I don't believe you can - not for the server, at any rate. For the client, you can twiddle values in my.cnf to suit your needs. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- 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