Re: error 2002 (connection attempt failed)
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
Subject
Written By
Posted
September 11, 2014 06:17PM
Re: error 2002 (connection attempt failed)
September 12, 2014 01:43AM
September 12, 2014 05:56PM
September 12, 2014 07:18PM
September 13, 2014 06:22AM
September 13, 2014 09:15AM
September 13, 2014 10:00AM
September 13, 2014 01:10PM
September 13, 2014 02:11PM
September 13, 2014 04:32PM
September 13, 2014 04:33PM
September 13, 2014 07:10PM
September 13, 2014 08:06PM
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.