[TriLUG] MySQL Replication

Ken MacKenzie ken at mack-z.com
Thu Jan 29 16:23:01 EST 2015


Yeah 'user'@'remoteip' is probably better than @'%' in this case.

Ken

On Thu, Jan 29, 2015 at 4:10 PM, <matt at noway2.thruhere.net> wrote:

> Interesting.
>
> It looks like that is turned off by default in the my.cnf file
> (/etc/mysql).
>
> Not sure if it would provide the error information though.
>
> I think the previous suggestion of adding a user 'user'@'ip address' or
> 'user'@'%' is the way to go around this problem.
>
> From the fact that you can login with this user at localhost, I am all but
> positive this is your issue.
>
> > On Thu, Jan 29, 2015 at 03:37:44PM -0500, matt at noway2.thruhere.net
> wrote:
> >> In the logs, how does the successful user access differ from the
> >> unsuccessful?
> >
> > Hmmm.  I don't find any logging, at the moment.
> >
> > The only log that I am finding, anyway, is error.log, but it doesn't
> > have any records for the past hour or more.
> >
> >
> >
> > Brian
> >
>
>


More information about the TriLUG mailing list