Getting SQLSTATE[28000] [1045] Access denied for user ‘user’@’IPaddress’ (using password: YES) when trying to restore mySQL dump to Azure MySQL DB PaaS

I was debugging a Magento deployment on Microsoft Azure for one of my customers as they were trying to restore MySQL dump to Azure MySQL DB PaaS and they kept on getting the following error: Getting SQLSTATE[28000] [1045] Access denied for user ‘user’@’IPaddress’ (using password: YES) I was able to restore DB dump normally from…