MySQL port and remote connection

[kamino]

Hello,

Does DA support different MySQL port than 3306 while using remote MySQL databases ?

Indeed users are not able to connect MySQL from DA to manage their users or create databases since I change the port.

See error below:

Error connecting to MySQL: Can't connect to MySQL server on 'mysql.kamino.fr' (110)

DA version: 1.24.2

But mysql.conf is correctly set (with host option) and changing to host=mysql.intra.net:6000 doesn't solve anything.

On the other hand I can remotly access MySQL with Da user from the command line...
I assume that DA does not use the /etc/my.cnf.


Any idea ? Except to revert back to port 3306 ?

Regards,

 

[kamino]

Found the solution !

I had to modify the /etc/service and replaced the port 3306 to the port I wanted:

mysql 6000/tcp # MySQL
mysql 6000/udp # MySQL


Conclusion:

If you want remote MySQL with a custom port , modifying the /etc/my.cnf and the /usr/local/directadmin/conf/mysql.conf files is not enough.
You have to modify the the /etc/service as well since directadmin doesn't seem to read the /etc/my.cnf at connection time.

Best Regards,

 

[jmstacey]

Edit: Nevermind