Industrial Data Bridge and MySQL

I select MySQL. In server i set the ip and the port. They separate with ; because the IDB help explains:

If you use TCP/IP (standard) as a network library, a port number to the SQL server is also accepted in this position, separated by a comma

In user name i write root and set black password.

When i try to select de Database i dont found anything and if i press Test Button it shows a pop-up that said Connection Refused.

I read in the IDB help:

Note

MySQL - Stored Procedure

For inserting unicode data in MySQL stored procedure for IndustrialDataBridge, you have to create stored procedure in MySQL as specified below:

CREATE DEFINER = 'root'@'localhost' PROCEDURE 'IDBStoredProc_MySQL1'(IN p1 smallint(6), IN p2 smallint(11), IN p3 float, IN p4 varchar(45) charset utf8, IN p6 datetime);

I try to create this definer in my MySQL console but it fails. I dont know how to do to it works.

Any help?

Best, Fran.

Hello,

it's not exactly what you're looking for, but do you know this FAQ:
https://support.industry.siemens.com/cs/ww/en/view/109476988
"How do I transfer data from WinCC Runtime Professional with the help of IndustrialDataBridge?" ?

Maybe it can help you.

Thaks for you help.

I read this pdf before. This is about how to generate the xml from your Wincc Professional.

This is very helpful and necessary if you dont use TIA in English.

But my ask is about: ¿what i have to do to connect IDB with MySQL?.

Thanks again, best.