Unable to connect to the mysql localhost server using flexsim connector.

[ajay13101997]

[ FlexSim 22.0.2 ]

please find the flexsim snap, mysql server details snap, mysql db snap.
I am not able to connect to mysql db from flexsim, i am running mysql application and flexsim application on same system.

need support to create connection between mysql db and flexsim.
Thanks in advance.

Flexsim connector view.png

MYSQL DB VIEW.png

MYSQL server details.png

[Ben_WilsonADSK]

Have you tried removing the ",3306" from the database address, so that the only text is localhost?

[ajay13101997]

Yes i have tried putting only localhost, but still it does not work

[jason_lightfootVL7B4]

Can you connect with another application like Excel or MSAccess to import data? Is there a confluct on port 3306?

[shanice_c]

Have you tried type sakila.db in databasename field? I made this mistake a few days ago.

[ajay13101997]

Hi,

I have tried connecting via MS SQL it has connected successfully, but with mysql it is not working

[jason_lightfootVL7B4]

So you can't connect excel or MSAccess to mysql either - that suggests it's a MySQL/machine configuration problem. In testing a similar install to yours with the same port numbers FlexSim connects fine just using "localhost". Have you checked the credentials? You could also try shanice.c's suggestion.

[ajay13101997]

Ok sure jason i will try your and shanice suggestions

[sebastian_canas9DYX7 · Accepted solution]

@TheHero

I also had this issue while trying to connect to MySQL. I am not totally sure why this happens but I fixed it removing the lastest version I installed of MySQL Server (8.0.29) and then installing an older version (in my case I installed 8.0.1)

After that I could connect to the database succesfully

[kavika_faleumu]

Hi @TheHero, was one of Sebastián Cañas's or shanice.c's answers helpful? If so, please click the "Accept" button at the bottom of the one that best answers your question. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

[ajay13101997]

i tried it out but having same error

[ajay13101997]

i am using workbench 8.0.28

[shanice_c]

Would you try not type port number 3306?

This is my connection.

[sebastian_canas9DYX7]

I also had problems with that version. Try using an older one!

[ajay13101997]

thanks, let me try with 8.0.1 version

[borja_lorenzo4278]

Hello @TheHero ,
I have experienced the same error with version 22 of FlexSim. I was able to solve it with version 24.1.1 of FlexSim and version 8.0.26 of MySQL.

Have you been able to solve it?

Which version of FlexSim is giving you this problem?