I am trying to connect to a remote legacy MySql Database that resides on a Windows 7 32Bit machine.
Legacy system is 10+ year old.
Have no idea how the database was setup but have been able to connect locally using
mysql -h 192.168.x.x -P 3306 -u root -p
Have run the following commands
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
Then restarted MySql
Have shut off the Firewall
When I try to connect using MySql Workbench I get a
Failed to Connect to MySql at 192.168.x.x:3306 with user root
Access denied for user firstname.lastname@example.org (using password:YES)
Let me know if you have any thoughts on how to connect