Although I never used this command before,based on the error message "Access denied for
user 'root'@'10.10.50.42' (using password: YES)". I think the problem is that "root" user
is not allowed to connect remotely.
U can check mysql.user table, to very whether
Host: %User: root
or (the remote connection IP in your case)
Host: 10.10.50.42 User: root
exist or not.
If both two users are not there. You've to grant remote connection privilege to "root"
user.
Best regards,
Qiusheng
Email: meiqiusheng11@stripped
> Date: Thu, 17 Apr 2008 16:24:00 +0530> From: kaushalshriyan@stripped> To:
> replication@stripped> Subject: mk-table-checksum> > Hi> > when i run
> mk-table-checksum h=10.1.0.41,u=root,p=test h=localhost> --databases=ABCWEB {where
> h=10.1.0.41 is master server}> > I get> > DBI
> connect(';host=10.1.0.41;mysql_read_default_group=mysql','root',...)> failed: Access
> denied for user 'root'@'10.10.50.42' (using password: YES) at>
> /usr/bin/mk-table-checksum line 1139> > Am i missing something> > Thanks and
> Regards> > Kaushal
_________________________________________________________________
MSN 中文网，最新时尚生活资讯，白领聚集门户。
http://cn.msn.com
