on my old server, when I wanted to access mysql of certain account/domain, i accessed mysql.domain.com with the port of 3306 and worked perfectly. please, how do I do this settings with the ispconfig?
If you want to access the mysql database n the same server, then you use "localhost" as server name for the mysql database. If you want to access a mysql server from an different server, then you use the hostname of that server or any other domain that points in dns to the server where the mysql database is located.
did not work ... in "DNS Zone"> Records, I added a record A, with hostname 'mysql' and pointed to the server ip. in Sites > Database > I checked "Remote Access" and added my ip in "Remote Access IPs". but still does not connect ...
1) Did you enable mysql to listen on all interfaces in /etc/my.cnf ? The bind_address line has to be commented out. 2) Did you open the mysql port in your firewall (in case that you use one)? 3) DNS records can take up to 24 hours to propagate, did you wait 1 day?
thank you! 3) the dns already propagated correctly. 2) port 3306 opened in System > Firewall 1) i did that and now... works!!!! till, very thank you
