ChuckBell
commented
2 years ago Hi.
Yes, unfortunately the connector only supports the native authentication. You can read about it more starting here: https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html and https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication.html https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication.html.
One way to solve the problem is to create a new user specifying the mysql_native_password option per the docs.
For example…
mysql> select user, host, plugin from mysql.user; +------------------+-----------+-----------------------+ | user | host | plugin | +------------------+-----------+-----------------------+ | root | % | mysql_native_password | | mysql.infoschema | localhost | caching_sha2_password | | mysql.session | localhost | caching_sha2_password | | mysql.sys | localhost | caching_sha2_password | | root | localhost | mysql_native_password | +------------------+-----------+-----------------------+
Notice the first row. I created a special user named root with the native password authentication like this:
mysql> CREATE USER dummy@'%' IDENTIFIED WITH mysql_native_password BY 'secret'; Query OK, 0 rows affected (0.01 sec)
mysql> select user, host, plugin from mysql.user; +------------------+-----------+-----------------------+ | user | host | plugin | +------------------+-----------+-----------------------+ | dummy | % | mysql_native_password | | root | % | mysql_native_password | | mysql.infoschema | localhost | caching_sha2_password | | mysql.session | localhost | caching_sha2_password | | mysql.sys | localhost | caching_sha2_password | | root | localhost | mysql_native_password | +------------------+-----------+-----------------------+ 6 rows in set (0.00 sec)
On Oct 15, 2021, at 11:52 AM, mprof9 @.***> wrote:
Hi there, I am trying to run the example in the Arduino MySQL connector library (sketch 'connect_wifi_101') with a MKR1000 using the WiFi101 library and MySQL connector library v 1.2 trying to connect to an Azure cloud mySQL server. Everything seems to run well up until the authentication stage, where I apparently get a mysql_native_password error. This is the printout of the serial monitor from arduino:
https://user-images.githubusercontent.com/92594035/137516212-eb19cdd0-5b39-4925-8fca-e97f3e2650d7.png I have run out of ideas of how to get around this issue, especially I cannot figure out how to check if mysql_native_password is actually selected on the azure mysql portal. Any help would me really appreciated. Thank you.
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/178, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYEQABHGN4PFBIH3JO3UHBE45ANCNFSM5GCIOV6A.
mprof9
Hi there, I am trying to run the example in the Arduino MySQL connector library (sketch 'connect_wifi_101') with a MKR1000 using the WiFi101 library and MySQL connector library v 1.2 trying to connect to an Azure cloud mySQL server. Everything seems to run well up until the authentication stage, where I apparently get a mysql_native_password error. This is the printout of the serial monitor from arduino:
I have run out of ideas of how to get around this issue, especially I cannot figure out how to check if mysql_native_password is actually selected on the azure mysql portal. Any help would me really appreciated. Thank you.