I’m installing a new MySQL database, but want to access the database remotely. I have properly set up MySQL (4.1.11), Apache2 (2.0.54), PHP (5.04) and PHPMyAdmin (2.6.2) on Windows 2003. All works fine from this one server!
However, when I rerun MySQL Server Instance Config Wizard, and modify the security settings to “enable root access from remote machines”, I get a 1045 error when I click on “execute” at the end of the wizard…
The security settings could not be applied to the database because the connection has failed with the following error:
Error Nr. 1045
Access denied for user ‘root’@’localhost’ (using password: YES)
If a personal firewall…….. etc, etc.
I’m not running any domains or domain controlers, just single machines. I’m trying to allow my home computer 220.127.116.11 to access the database which is on an IP of 18.104.22.168.
I found this thread saying this is a known bug…
But can’t find any solutions to my problem. Any help appreciated on this! I’ve used MySQL a limited number of times before, but am not an expert with it by any means. So it could be user error, it might be a bug.?.?