search

ChuckBell / MySQL_Connector_Arduino

Database connector library for using MySQL with your Arduino projects.
332 stars 133 forks source link

Hello, may I ask how to use esp8266 to read the data in mysql #202

Open Mr-Cheung094 opened 1 year ago

Mr-Cheung094 commented 1 year ago

Hello, may I ask how to use esp8266 to read the data in mysql I hope you can help me @ChuckBell

ChuckBell commented 1 year ago

Hello,

First, be sure to check the troubleshooting tips on the wiki. You will need to verify you can connect to your server from the same network as your ESP8266 device.

As for that device, be sure you are using the correct library as the newest for ESP won’t work with the connector.

Most of these issues are a result of network access or user account issues.

Lastly, make sure your MySQL server is running Oracle’s MySQL (not others) and that you have the MySQL Native plugin turned on and assigned to the user account you are using.

Dr. Bell

On Feb 11, 2023, at 7:27 AM, Mr. Cheung @.***> wrote:

Hello, may I ask how to use esp8266 to read the data in mysql I hope you can help me

— Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/202, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYGDGQZOXVT7QFQVYRDWW6AUNANCNFSM6AAAAAAUYVRACE. You are receiving this because you are subscribed to this thread.

Mr-Cheung094 commented 1 year ago

When I use the insert routine, I can connect and insert normally, but I want to query the data inside, to achieve the function of the account password verification

获取Outlook for Androidhttps://aka.ms/AAb9ysg

From: Dr. Charles Bell @.> Sent: Sunday, February 12, 2023 4:25:38 AM To: ChuckBell/MySQL_Connector_Arduino @.> Cc: Mr. Cheung @.>; Author @.> Subject: Re: [ChuckBell/MySQL_Connector_Arduino] Hello, may I ask how to use esp8266 to read the data in mysql (Issue #202)

Hello,

First, be sure to check the troubleshooting tips on the wiki. You will need to verify you can connect to your server from the same network as your ESP8266 device.

As for that device, be sure you are using the correct library as the newest for ESP won’t work with the connector.

Most of these issues are a result of network access or user account issues.

Lastly, make sure your MySQL server is running Oracle’s MySQL (not others) and that you have the MySQL Native plugin turned on and assigned to the user account you are using.

Dr. Bell

On Feb 11, 2023, at 7:27 AM, Mr. Cheung @.***> wrote:

Hello, may I ask how to use esp8266 to read the data in mysql I hope you can help me

― Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/202, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYGDGQZOXVT7QFQVYRDWW6AUNANCNFSM6AAAAAAUYVRACE. You are receiving this because you are subscribed to this thread.

― Reply to this email directly, view it on GitHubhttps://github.com/ChuckBell/MySQL_Connector_Arduino/issues/202#issuecomment-1426869903, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ASK6PBQ3CO3ESQWO26TNOTLWW7YUFANCNFSM6AAAAAAUYVRACE. You are receiving this because you authored the thread.Message ID: @.***>