SQL Server link to MySQL reports "using password: no"
I just ran into this installing a linked server to MySQL with the &quot;MySQL 8.0&quot; connector. The same error message in the OP occurred when trying the 64-bit versions of both the ANSI and the Unicode connectors on 64-bit Windows Server 2016 host/SQL Server 2019 Standard.
In my case, the issue had to do with the connection string, specifically the PWD=MyPa$$word portion. Replacing it with the equivalent password=MyPa$$word fixed the issue.
Credit to this MSSQL Tips article, which has a chart of the possible connection string parameters.