I have just written this blog for resolution of this issue, do check this out
https://cloudcomputingbyumesh.blogspot.com/2022/06/data-import-using-powershell-into-mysql.html