Skip to main content
3 of 3
added 301 characters in body
user3676417
  • 97
  • 2
  • 3
  • 10

Mysql database didn't connect through sqlyog or any other mysql software?

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
user3676417
  • 97
  • 2
  • 3
  • 10