1

Topic: Remote access to mysql

==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
======== Required information ====
- iRedMail version:  9.0
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Linux/BSD distribution name and version: ubuntu 14 TLS
- Related log if you're reporting an issue:
====

I am not able to connect to database remotely.  I have commented the line bind-address in my.cnf and restarted the mysql server. I have also created a user that has granted all privileges to all databases.  Yet, the remote connection does not work.   I built iredmail from a "fresh" server.  Do I need to use iptables?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Remote access to mysql

You need to open a hole in your firewall
Edit /etc/default/iptables
uncomment the line regarding 3306
Then run
Service iptables restart

3

Re: Remote access to mysql

That worked!  You are the best, Zhang!

Thanks.

7t3chguy wrote:

You need to open a hole in your firewall
Edit /etc/default/iptables
uncomment the line regarding 3306
Then run
Service iptables restart

4

Re: Remote access to mysql

lamine wrote:

That worked!  You are the best, Zhang!

7t3chguy answered your question, not me. smile
Thanks 7t3chguy.