question

RobertVerrall-0981 avatar image
0 Votes"
RobertVerrall-0981 asked OuryBa-MSFT commented

Can't connect MySQL Workbench with my database in Azure Database for MySQL server

I created an "Azure Database for MySQL server", installed "MySQL Workbench" as per instructions on MS documentation. I keep hitting the same problem after much installing, re-installing, changing firewall settings (ie adding IP addresses ...).
When trying to add a new connection in MySQL Workbench, I get an error; "Access denied for user 'adm...@[mypublicIP]' (using password: YES).

azure-database-mysql
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@RobertVerrall-0981 We are checking this and will get back to you

0 Votes 0 ·

Hello @RobertVerrall-0981


Welcome to Microsoft Q&A and thank you for posting your question.

Please kindly provide the following information.
1. The document you followed when creating MYSQL in azure?
2. A screen shot on how you configure MYSQL and the error message you are getting when trying to login.
3. Have you created this user for group authentication , if yes How?

Please also refer to this Stack overflow link below and let us know if that answer your question.

Regards,

Oury Ba


0 Votes 0 ·

Thanks for your reply. I followed; "Quickstart: Create an Azure Database for MySQL server by using the Azure portal", then; "Quickstart: Use MySQL Workbench to connect and query data in Azure Database for MySQL".
Attached are screen shots; 1&2. Azure db & Security config 3.SQL workbench config 4. error I get 76702-clipboard01.jpg76620-clipboard02.jpg76703-clipboard03.jpg76667-clipboard04.jpgin MySQL workbench, please let me know if you need more, thanks


0 Votes 0 ·
clipboard01.jpg (185.0 KiB)
clipboard02.jpg (192.6 KiB)
clipboard03.jpg (53.4 KiB)
clipboard04.jpg (19.3 KiB)

Hi again,
I have just managed to make the connection!
First I tried using a "known wrong PW" when trying to make the connection and got the same error message.
So I changed the PW for "Azure Database for MySQL server" then tried to connect in "MySQL workbench" again using the new PW and bingo!
I spent ages trying different things, it seems there is a PW issue in Azure.
Thanks for your help anyway

0 Votes 0 ·

Hi @RobertVerrall-0981 , We are glad that you were able to resolve the issue . Please do let us know if you nee any further help.


Thanks,

Regards

Oury Ba

0 Votes 0 ·

0 Answers