search

ChuckBell / MySQL_Connector_Arduino

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

cannot connect to mysql #198

Open sgmwjivy opened 1 year ago

sgmwjivy commented 1 year ago

I use the example basic_insert_esp8266 ,but i cannot connect to mysql ,please help

the sscom print error:

[18:25:00.015]收←◆ Connecting to jivy [18:25:00.517]收←◆wait [18:25:01.017]收←◆wait [18:25:01.516]收←◆wait [18:25:02.016]收←◆wait [18:25:02.517]收←◆wait [18:25:03.744]收←◆wait [18:25:04.244]收←◆wait [18:25:04.745]收←◆wait [18:25:05.245]收←◆wait [18:25:05.744]收←◆wait [18:25:06.247]收←◆wait Connected to network My IP address is: 192.168.31.92 Connecting to SQL... ...trying...

[18:25:06.557]收←◆ --------------- CUT HERE FOR EXCEPTION DECODER ---------------

Exception (28): epc1=0x40202574 epc2=0x00000000 epc3=0x00000000 excvaddr=0x00000049 depc=0x00000000

stack>>>

ctx: cont sp: 3ffffc40 end: 3fffffc0 offset: 0190 3ffffdd0: 3ffed2a4 40220450 3ffed220 3ffef95c
3ffffde0: 3ffef95c 3ffeeb18 00000001 402025c7
3ffffdf0: 40210000 00000000 3ffe8606 402025b4
3ffffe00: 3ffef9a0 3ffeeb0c 3ffef580 4020674c
3ffffe10: fffffffc 3ffed39c 00000002 00000000
3ffffe20: 00000014 3ffef57c 000000ff 3ffee5bc
3ffffe30: 40206718 3ffe8606 3ffee624 40202f04
3ffffe40: 3ffef95c 3ffee624 00000000 40202f28
3ffffe50: 3ffef95c 3ffee624 3ffee624 40203084
3ffffe60: 3ffeeb0c 00000000 00000000 4020297b
3ffffe70: 7976696a 00000000 40100205 402151b2
3ffffe80: 00000170 00000170 3ffe8624 401006bf
3ffffe90: 00000000 4bc6a7f0 c83126e9 00000001
3ffffea0: 3ffefb64 00000020 3ffefb64 4010089e
3ffffeb0: 3ffee150 00000000 00000000 40100294
3ffffec0: 000019cf 3ffee7ec 0000012c 40215c18
3ffffed0: 0000012f 0000012f 3ffe8624 401006bf
3ffffee0: 3ffe8606 00000000 3ffef63c 3ffe8606
3ffffef0: 00000000 00000029 00000020 3ffe8606
3fffff00: 00000000 00000029 3ffee5bc 40202abe
3fffff10: 00000004 3ffef95c 3ffee5bc 40202832
3fffff20: 0000004a 00000100 0001c200 00000003
3fffff30: 00000001 3ffee6fc 3ffee5bc 40202216
3fffff40: 40206bc8 0501a8c0 3ffee6fc 40202c94
3fffff50: 3fffff90 00000cea 3ffe860b 3ffe8606
3fffff60: 00000000 40201f70 3ffee6fc 40202f28
3fffff70: 5c1fa8c0 00ffffff 011fa8c0 3ffee788
3fffff80: 3ffe85d4 3ffee5bc 3ffee6fc 40201101
3fffff90: 40206bc8 0501a8c0 feefeffe feefeffe
3fffffa0: 3fffdad0 00000000 3ffee774 40203c28
3fffffb0: feefeffe feefeffe 3ffe8620 40100c25
<<<stack<<<

--------------- CUT HERE FOR EXCEPTION DECODER ---------------

ChuckBell commented 1 year ago

Hello. I will need to see your sketch to offer any advice. Also, be sure to check the wiki for connection troubleshooting tips.

On Wed, Nov 23, 2022 at 05:44 jivy @.***> wrote:

I use the example basic_insert_esp8266 ,but i cannot connect to mysql ,please help

the sscom print error:

[18:25:00.015]收←◆ Connecting to jivy [18:25:00.517]收←◆wait [18:25:01.017]收←◆wait [18:25:01.516]收←◆wait [18:25:02.016]收←◆wait [18:25:02.517]收←◆wait [18:25:03.744]收←◆wait [18:25:04.244]收←◆wait [18:25:04.745]收←◆wait [18:25:05.245]收←◆wait [18:25:05.744]收←◆wait [18:25:06.247]收←◆wait Connected to network My IP address is: 192.168.31.92 Connecting to SQL... ...trying...

[18:25:06.557]收←◆ --------------- CUT HERE FOR EXCEPTION DECODER ---------------

Exception (28): epc1=0x40202574 epc2=0x00000000 epc3=0x00000000 excvaddr=0x00000049 depc=0x00000000

stack>>>

ctx: cont sp: 3ffffc40 end: 3fffffc0 offset: 0190 3ffffdd0: 3ffed2a4 40220450 3ffed220 3ffef95c 3ffffde0: 3ffef95c 3ffeeb18 00000001 402025c7 3ffffdf0: 40210000 00000000 3ffe8606 402025b4 3ffffe00: 3ffef9a0 3ffeeb0c 3ffef580 4020674c 3ffffe10: fffffffc 3ffed39c 00000002 00000000 3ffffe20: 00000014 3ffef57c 000000ff 3ffee5bc 3ffffe30: 40206718 3ffe8606 3ffee624 40202f04 3ffffe40: 3ffef95c 3ffee624 00000000 40202f28 3ffffe50: 3ffef95c 3ffee624 3ffee624 40203084 3ffffe60: 3ffeeb0c 00000000 00000000 4020297b 3ffffe70: 7976696a 00000000 40100205 402151b2 3ffffe80: 00000170 00000170 3ffe8624 401006bf 3ffffe90: 00000000 4bc6a7f0 c83126e9 00000001 3ffffea0: 3ffefb64 00000020 3ffefb64 4010089e 3ffffeb0: 3ffee150 00000000 00000000 40100294 3ffffec0: 000019cf 3ffee7ec 0000012c 40215c18 3ffffed0: 0000012f 0000012f 3ffe8624 401006bf 3ffffee0: 3ffe8606 00000000 3ffef63c 3ffe8606 3ffffef0: 00000000 00000029 00000020 3ffe8606 3fffff00: 00000000 00000029 3ffee5bc 40202abe 3fffff10: 00000004 3ffef95c 3ffee5bc 40202832 3fffff20: 0000004a 00000100 0001c200 00000003 3fffff30: 00000001 3ffee6fc 3ffee5bc 40202216 3fffff40: 40206bc8 0501a8c0 3ffee6fc 40202c94 3fffff50: 3fffff90 00000cea 3ffe860b 3ffe8606 3fffff60: 00000000 40201f70 3ffee6fc 40202f28 3fffff70: 5c1fa8c0 00ffffff 011fa8c0 3ffee788 3fffff80: 3ffe85d4 3ffee5bc 3ffee6fc 40201101 3fffff90: 40206bc8 0501a8c0 feefeffe feefeffe 3fffffa0: 3fffdad0 00000000 3ffee774 40203c28 3fffffb0: feefeffe feefeffe 3ffe8620 40100c25 <<<stack<<<

--------------- CUT HERE FOR EXCEPTION DECODER ---------------

— Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/198, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYHBVPW3CDWI7F2I3EDWJXYPFANCNFSM6AAAAAASIZ7VYQ . You are receiving this because you are subscribed to this thread.Message ID: @.***>

Briyanlin commented 1 year ago

I have the same problem,please help me image

ChuckBell commented 1 year ago

Please follow the troubleshooting tips on the Wiki. If that doesn’t work, please let me know which version of MySQL you are using. Keep in mind that you must turn on the mysql native authentication plugin and ensure any firewalls are open for port 3306.Sent from my iPadOn Dec 1, 2022, at 11:32, Briyanlin @.***> wrote: I have the same problem,please help me

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: @.***>

Briyanlin commented 1 year ago

MySQL version is 8.0. I have turn on the plugin .And I made the computerA connect to computerB on the same wifi. Mysql can be connected between them.

ChuckBell commented 1 year ago

Ok, does the MySQL user have permission to connect from the IP address of the Arduino? And, is the MySQL user created with the plugin specified with the IDENTIFIED WITH clause? You can check both by selecting the user, passwd from the mysql.user table. You can post an image of that if you want me to check it. Or, you can do “SHOW CREATE USER …,” which will show you the clause too.

BTW, what Arduino board are you using?

On Dec 2, 2022, at 7:53 AM, Briyanlin @.***> wrote:

MySQL version is 8.0. I have turn on the plugin .And I made the computerA connect to computerB on the same wifi. Mysql can be connected between them.

— Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/198#issuecomment-1335184941, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYBW2SP2M2LNPXMSZDLWLHWLVANCNFSM6AAAAAASIZ7VYQ. You are receiving this because you commented.