Thank you for your help.
I searched the installation directory for the master.info file (running
MySQL v5.5, on a Windows Server) and couldn't find it anywhere, even
though I setup the slave using the appropriate additions to the my.cnf
file and running the CHANGE MASTER TO statement.
Do you know where the master.info file should be on a Windows Server.
On 09/01/2011 01:56, Truls Bergskaug wrote:
> On 08/30/2011 10:08 AM, Robert Miesen wrote:
>> I've done so and have confirmed that I can login and have the GRANTS
>> I expect to have.
>>>> Every time I try and start the replication process on the slave
>>>> side of things, I get the following error message:
>>>> Slave I/O: error connecting to master
>>>> 'repl@*ip_address_redacted*:3306' - retry-time: 60 retries: 86400,
>>>> Error_code: 1045
> Error: |1045| SQLSTATE: |28000| (|ER_ACCESS_DENIED_ERROR|
> Message: Access denied for user '%s'@'%s' (using password: %s)
> The only privilege the replication user need is "REPLICATION SLAVE".
> In the file "master.info" in your data directory on the slave;
> servername, username, password and port is stored. Please verify that
> these values are what you can use to connect to the master.
>>>> I've verified that I can login using the repl account from the
>>>> machine in question, so I know that the repl account can login from
>>>> the Windows Server machine to the Master MySQL server. My question
>>>> is, what could be causing this sort of error if it's not a
>>>> credentials issue?
>>>> Thanks in advance for your help!
*Email:* robert.miesen@stripped <mailto:robert.miesen@stripped>
See who we know in common <http://www.linkedin.com/e/wwk/42004246/>
Want a signature like this? <http://www.linkedin.com/e/sig/42004246/>