Migration to ASOV2 and issue with user managed identity client id vs service principal. #5151
Description
- We have a flexible server with mysql 5.7 with db users tied to user managed identity are in the format of 'AADApp:<client_id>:upn: name' inside the database.
- After the flexible server is mysql 8, db users tied to user managed identity are retained in the format of 'AADApp:<client_id>:upn: name' inside the database.
- But when we use ASOV2 to adopt the flexible server after mysql 8. db users tied to user managed identity allowed only in this format - 'AADSP:<client_id>:upn: name ' inside the database.
- is this by design..? do we need to use service principal going forward and change the application code to use service principle ..? instead of client id.? can you suggest a example code..?
- Can we still retain the old format..? if we use ASOV1 ...checking as it is deprecated.
apologies for any misunderstanding...!!