Connecting to another machine with myCC
Folks, I have a question about myCC. I can't connect to a local linux machine (ip 192.168.0.232) for the life of me from my win2k box (ip 192.168.0.232) using myCC. I've done the following: GRANT ALL ON test.* TO 'fred'@'192.168.0.230'; FLUSH PRIVILEGES; but, in my mysql.log I still get: 020816 14:11:18 6 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) My user table looks like: mysql select user,host from user; ++---+ | user | host | ++---+ | root | 192.168.0.230 | | fred | 192.168.0.230 | || lancelot | | root | lancelot | || localhost | | fred | localhost | | root | localhost | ++---+ What have I done wrong? I know that mysql is up and running and listening to port 3306. If anyone has an idea, please let me know. Cheers, Fred - 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
Re: Connecting to another machine with myCC
Hi, Try another tool named My Database Manager. You can download the site br.geocities.com/burbello. Greedings Alexander - Original Message - From: Fred Tsang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 7:38 AM Subject: Connecting to another machine with myCC Folks, I have a question about myCC. I can't connect to a local linux machine (ip 192.168.0.232) for the life of me from my win2k box (ip 192.168.0.232) using myCC. I've done the following: GRANT ALL ON test.* TO 'fred'@'192.168.0.230'; FLUSH PRIVILEGES; but, in my mysql.log I still get: 020816 14:11:18 6 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) My user table looks like: mysql select user,host from user; ++---+ | user | host | ++---+ | root | 192.168.0.230 | | fred | 192.168.0.230 | || lancelot | | root | lancelot | || localhost | | fred | localhost | | root | localhost | ++---+ What have I done wrong? I know that mysql is up and running and listening to port 3306. If anyone has an idea, please let me know. Cheers, Fred - 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 ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gĂȘmea. http://br.encontros.yahoo.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
RE: Connecting to another machine with myCC
Sorry everyone, I must've forgotten to set the password with an 'identified by' clause, or I needed to grant to *.*: grant all on *.* to fred@192.168.0.230 identified by 'fred'; it works now. thanks! Fred -Original Message- From: Alexander Burbello [mailto:[EMAIL PROTECTED]] Sent: 29 August 2002 13:17 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Connecting to another machine with myCC Hi, Try another tool named My Database Manager. You can download the site br.geocities.com/burbello. Greedings Alexander - 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