Re: Replication problem

[Rick James]

Sounds like permission problems. I am not (yet) familiar with Windows 7, but maybe it is beginning to get a file-permission design similar to what Unix has had for nearly four decades. Let me explain how to fix it on Unix; see if you can adapt this to W7...

my.cnf (that's the Unix name for my.ini) lives in a directory (/etc) that mere mortals cannot modify things -- only 'root' can edit files there. The unix workaround involves 'sudo'; on Windows, you probably need to login as 'Administrator'.

All mysql files and directories are owned and readable and writable by the 'mysql' user. Or at least that is the way it should be. Sometimes an installation is messed up and the files/directories get owned by someone else (root or the user doing the installation). This can lead to problems executing. The solution usually involves "chown" to fix the ownership and checking that mysql can read/write its files/directories.