How to fix ERROR 1045 (28000): Access denied for user 'ecommerceapp@mydbserver1'@'myip' (using password: YES)

Question

Hello,

I am using Windows 10. I have an Azure Database for MySQL flexible server that I can successfully connect to using my local MySQL workbench. However, when I use mysql -h

Answer 1

Hi Wenbo Peng •,

Welcome to Microsoft Q&A forum.

As I understand, you have an Azure Database for MySQL Flexible Server which you can connect via MySQL workbench but not via PowerShell.

Could you please let us know if you are using Azure Cloud Shell for this?

If your Azure Database for MySQL - Flexible Server has to connect with private access connectivity method, follow https://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-create-connect-server-vnet

Refer to this blogpost MySQL Flexible Server PowerShell Module:

https://techcommunity.microsoft.com/t5/azure-database-for-mysql-blog/introducing-the-mysql-flexible-server-powershell-module/ba-p/2203383

Hope this helps. Let us know if your ask is different.

Thanks