You should add a user who allow to connect from 192.168.0.2 before you can connect to MySQL remotely.
Further more, make sure that your host can reverse lookup 192.168.0.2. This can be done by add an entry in the /etc/hosts or create a DNS entry. Regards, > Just installed mysql nice one i though > > set it all up read the nessasary docs nice one i thought > > tried to connect remotly > > [root@tasha root]# mysqladmin -h 192.168.0.2 version -uroot - > ppassword mysqladmin: connect to server at '192.168.0.2' failed > error: 'Lost connection to MySQL server during query' > > oh bugger > > played around with the configs for a few hours > > tried everything i could think of > > read some more docs > > tried everything i could think of again > > still the same > > any ideas? > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe- [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com --------------------------------------------------------------------- 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
