I can connect to a MySQL server through a browser and also I can show all database list through PuTTY. But when I try to use
sqlyog or running the
mysqldump command through PuTTY it shows this error:
ERROR NO:2003 cannot connect to mysql server on "****"
How I give these tools permission?
I use this command
mysqldump -h "1st IP Address" -u username -ppasswprd DB Name | mysql -h "2nd IP Address" -u username -ppasswprd DB Name
I get that ERROR
mysqldump: Got error: 1130: Host '2nd IP Address' is not allowed to connect to this MySQL server when trying to connect