Hello @ShaktiSingh-MSFT
I've success to DMS of MySQL from one tenant to other.
On project, you should choose MySQL and Azure Databse for MySQL as a target and you can write source fqdn if DMS can connect.
This is point where I have follow-up question.
How can I connect to source MySQL from different tenant if that database is deny public access and connect only with private endpoint?
I've verified that DMS can't connect to source if it denies public access.
I've also checked that just vnet peering between the tenant is not enough.
DMS couldn't resolve source database with public FQDN nor privatelink.