How should I modify the existing MySQL connection?

Currently, more than 200 scenarios are connected to the MySQL module, but the IP address has changed. No matter how much I search, I can’t find a screen where I can change the host.

For MSSQL, it is possible to modify the host, but for MySQL, is it not possible?

Hi @ch.yoo and welcome to the community :waving_hand:

Thanks for sharing your issue with the community.

Could you create a ticket with our Support team, please? They have the right tools to help you resolve your issue.

Thank you!

1 Like

Welcome to the Make community!

You are correct, it is currently not possible to edit the host / ip address of an existing MySQL connection via the connections page or within the scenario.

I’m sure others will agree that this would be nice feature to have.

If this is important to you, please submit this suggestion to the Idea exchange, under App Improvement Ideas. However, do search for a similar request first (and also upvote), just in case it has already been suggested to avoid duplicates.

Hope this helps! Let me know if there are any further questions or issues.

@samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

Have you considered adding a CNAME record in your DNS like db.yourdomainname.com which points to the hostname endpoint of your MySQL server? This means you can just update the endpoint in your DNS when the MySQL endpoint changes. Likely you are using other software to query records in the database as well, and they can use the same domain specified in the CNAME record so you’ll never have to update Make or your additional tools again - the only update required for a change is to modify where the CNAME record points to.

In your case, you’re still going to need to update your existing scenarios with the new domain for all MySQL modules, whether you implement a CNAME record or just choose to update all the modules to your new endpoint. Either way, for updating connections across multiple scenarios, a new scenario can be created to identify and update these connections. See https://help.make.com/replace-connections-across-multiple-modules under the “Replace connections within multiple scenarios“ section.

1 Like