question

TheHero avatar image
0 Likes"
TheHero asked Borja Lorenzo commented

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

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

FlexSim 22.0.2
database connector
flexsim-connector-view.png (23.0 KiB)
mysql-db-view.png (245.3 KiB)
mysql-server-details.png (103.5 KiB)
· 7
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Ben Wilson avatar image Ben Wilson ♦♦ commented ·
Have you tried removing the ",3306" from the database address, so that the only text is localhost?
0 Likes 0 ·
TheHero avatar image TheHero Ben Wilson ♦♦ commented ·
Yes i have tried putting only localhost, but still it does not work
0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦♦ TheHero commented ·
Can you connect with another application like Excel or MSAccess to import data? Is there a confluct on port 3306?
1 Like 1 ·
Show more comments
Kavika F avatar image Kavika F ♦ commented ·

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.

0 Likes 0 ·

2 Answers

Sebastián Cañas avatar image
2 Likes"
Sebastián Cañas answered TheHero commented

@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

· 3
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

TheHero avatar image TheHero commented ·
i am using workbench 8.0.28
0 Likes 0 ·
Sebastián Cañas avatar image Sebastián Cañas TheHero commented ·
I also had problems with that version. Try using an older one!
0 Likes 0 ·
TheHero avatar image TheHero Sebastián Cañas commented ·
thanks, let me try with 8.0.1 version


0 Likes 0 ·
shanice.c avatar image
0 Likes"
shanice.c answered Borja Lorenzo commented

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

· 3
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

TheHero avatar image TheHero commented ·
i tried it out but having same error
0 Likes 0 ·
shanice.c avatar image shanice.c TheHero commented ·

Would you try not type port number 3306?

This is my connection.

1651733812188.png

0 Likes 0 ·
1651733812188.png (20.9 KiB)
Borja Lorenzo avatar image Borja Lorenzo TheHero commented ·

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?

0 Likes 0 ·