Check the docs on GRANT. Sounds like you have an incorrect host. Either set the host to % on your current record (manually and then FLUSH PRIVILEGES) or figure out the hostname from the machine you are trying to connect from and grant yourname@hostname the necessary privileges.
=C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -----Original Message----- From: Lee Connell [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 13, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: remote connection/users I am new with mysql. I have the latest version installed on a win2k = machine. I am trying to access mysql DB from another machine. It = returns invalid username/password, but if i connect locally with the = same login info it connects fine. What do i have to do to allow any = remote host to connect on a specific user account? _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.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 --------------------------------------------------------------------- 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