Use of CONNECT ENGINE

JPP 1 Reputation point
2022-04-14T08:39:52.663+00:00

Hello,

I want to use the "connect engine" from an external machine to an azure database.
The problem is with the connexion URL as the Microsoft "user" to connect to the Azure PAAS already contains an "@" which is (in other worlds) the user/host separator ...
Format of standard URL : mysql://user:password@hosting /database_name/table_name
as the "user" contains already an "@" on a MariaDB PAAS the URL is stated as "Syntax error" by Mariadb on the external server ....
Is there a solution to solve that problem.

Regards

Azure Database for MariaDB
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee
    2022-04-18T21:19:46.163+00:00

    Hi @JPP Please check in escaping the special character from the username
    https://docs.microfocus.com/OMi/10.62/Content/OMi/ExtGuide/ExtApps/URL_encoding.htm
    I found something from the StackOverflow Probably this might help.

    Regards
    Geetha

    0 comments
  2. Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
    2022-04-18T21:22:32.793+00:00

    @JPP Thank you for posting your query. From my understanding you are trying to use a connect engine from an external machine to an azure database.

    The best way to resolve this would be to use a proxy layer like MaxScale or ProxySQL in the middle as Azure DB for MariaDB requires username in the form username@servername. You can also refer to this blog for more details. Please note that the blog is written for MySQL, but it applies to MariaDB as well
    Why is username@servername required to connect to Azure Database for MySQL? - Microsoft Tech Community

    Please let us know if that is helpful

    Regards,
    Oury