MySQL Forums
Forum List  »  Newbie

Re: error 2002 (connection attempt failed)
Posted by: Jonathan Stephens
Date: September 12, 2014 01:43AM

What does SHOW GRANTS show for the root account? Did you perhaps set the password for root@localhost only?

What happens if you open a command line on the other machine and try logging into MySQL remotely with
mysql -h192.168.0.10 -uroot -p
...? Can you connect, and is your password accepted? (Note: You can simply copy the mysql.exe client binary to the other machine and run it there if you don't already have MySQL installed on it.)

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.