How To Point Mysql To Another Port Then 3306

Hello everybody,

today I want to describe how to point to non standard port in My SQL for Acumatica.

Below goes fragment from my Web.config

    <remove name="ProjectX" />
    <add name="ProjectX" providerName="System.Data.SqlClient" connectionString="Server=localhost;Port=4040;Database=PXProjectionMySql2;Uid

you can use this knowledge for having multiple MySQL instances on the same machine and for catching generated SQL queries.

Ready to take your Acumatica development to the next level? Whether you need to configure non-standard ports for MySQL, optimize database connections, or implement custom solutions tailored to your business needs, our team is here to help. If this article sparked ideas for your next project or if you have a specific customization request, don’t hesitate to reach out! Leave us a request today, and let’s build something extraordinary together. Your Acumatica journey starts here—let’s make it seamless and powerful.