mysql port closed

[koby]

Hi I want to make a mysqldump in differente host for a zimbra backup, but the port is closed for external connections:

 /opt/zimbra/mysql/bin/mysqldump -h 192.168.0.34 -u zimbra --all-databases --socket=/opt/zimbra/db/mysql.sock --password=asfasdfasdfasdf > zimbra.sql

nmap 192.168.0.34 -p 7306

PORT     STATE  SERVICE
7306/tcp closed unknown

I looked for config files like my.conf, but nothing talks about external hosts (like pg_hba.conf of a postgres)

Any ideas? thanks

[brian]

mysqld is bound to localhost by default see /opt/zimbra/my.cnf

Once you change it to bind to an ip address you needed to update the privilege tables. Here's a reference to the MySQL GRANT command.
http://dev.mysql.com/doc/refman/4.1/en/grant.html

[dijichi2]

might be easier and more secure to do the dump through ssh?