Loading...
 

Zephyr project on STM32

   Zephyr Workbench, a VSCode extension to manage Zephyr on STM32.
It enables users to easily create, develop, and debug Zephyr applications.
Main features:
  • Install host dependencies.
  • Import toolchain and SDK.
  • Create, configure, build and manage apps.
  • Debug STM32.
You can directly download it from the VSCode marketplace
For more details, visit the Zephyr Workbench

System Workbench for STM32

Forum List Topic List

[ prev topic ]  

STM32F4 MySQL connection

Posted by ucherdzhiev on 2015-10-31 12:09

Greetings,

Currently I am working on a project in which MySQL connection is requerd. I use STM32F4Discovery and some additional boards and made TCP/IP stack working with LwIP librarys, but I don’t know how to make a TCP connection directly to MySQL server. Currently I am able to connect TCP/UDP server and communicate with it, but can not connect to MySQL database. Can someone help me , give me some information about how to establish the connection. Thank you very much!

Best regards,
Ivan Ucherdzhiev

Reads: 21006
Link
Posted by grinch on 2015-10-31 16:45

Good luck!!

I think it’s more a MySQL connection protocol problem and not a STM one.
Check on Mysql website
http://dev.mysql.com/doc/internals/en/client-server-protocol.htmlQuestion

I wouldn’t implement this kind of thing.A better solution would be to have an in between Service (with PHP or Java) to deal with the database connection and tunneling the requests.. It would also have the benefit to filter what can be done with the database.

Link

Posted by ucherdzhiev on 2015-11-01 17:37

Thank you for the replay!

Yes its mysql protocol not STM one and i asking for support,C embedded library or somethink about the MySQL protocol.

Best regards.

Link
Posted by yuantuh on 2015-11-01 23:15
It is almost impossiable to put MySQL into F4, even F7. MySQL client stack is too big to fit into both F4 and f7.The solution may be: write a daemon in unix like OS and a service in Windows acting NySQL client, which communicates with MySQL server to read/write records and then forward/readback processed data to/from F4 through LWIP.
Link

Posted by ucherdzhiev on 2015-11-02 02:28
Thank you very much for you replay! I did that ,a simple UDP program on the server , to take the data from STM and upload it in the MYSQL
Link

Posted by ucherdzhiev on 2015-11-05 09:22

Hello again,

I made a MYSQL client library for STM32F4. I tested it and its working, I am able directly to connect STM32F4Discovery board to MySQL database , upload data in Tables from STM32F4Discovery, also download data from tables to the board.

Best regards!

Link
Posted by h_tanquoc on 2016-05-05 03:31

Hi,
Can I have a code for Stm32F4 connect to MySQL database, Thanks in advance

Link

Posted by AmaniBrikcha on 2016-07-22 17:35

Hi,

Currently I am working on a project in which a conection between STM32 Nucléo F303K8 and MySQL is requered.

I use mbed to generate my code.

but I think that mbed dont include “MySQL”library

how can I include this library to mbed?

What Can I do ?

Link