On Tue, Jul 02, 2002 at 05:56:37PM +0100, Simon Windsor wrote: > Hi > > We have just moved out test server from RedHat to Debian. > > We have used the backup tapes to recover the data, and all went well to until > we tried to connect via a host name. > > For example > > mysql test -utest_user -ptest_passwd > > works fine, but > > mysql -hserver -utest_user -ptest_passwd > > reports the error > > ERROR 2003: Can't connect to MySQL server on 'server' (111) > > The grants in the user/db tables are all ok, and worked on the RedHat box > (3.23-49). > > Any ideas what is happening with Debian version, also (3.23-49)
Remove the skip-networking option from the my.cnf file on your server. It's documented in the Debian MySQL docs. :-) Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 33 days, processed 740,610,078 queries (254/sec. avg) --------------------------------------------------------------------- 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