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

Question

question

TheHero asked Apr 25 2022 at 12:32 PM Borja Lorenzo commented Oct 01 2024 at 11:58 AM

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

Software Version:

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

Ben Wilson ♦♦ commented · Apr 25 2022 at 2:38 PM

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

0 ·

TheHero Ben Wilson ♦♦ commented · Apr 25 2022 at 3:40 PM

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

0 ·

Jason Lightfoot ♦♦ TheHero commented · Apr 28 2022 at 2:40 PM

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

1 ·

Show more comments

Kavika F ♦ commented · May 04 2022 at 5:15 PM

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 ·

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2022-04-29T12:53:30Z

Sebastián Cañas answered Apr 29 2022 at 12:53 PM TheHero commented May 12 2022 at 11:38 AM

@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

Answer 2 · 2022-04-28T14:48:05Z

shanice.c answered Apr 28 2022 at 2:48 PM Borja Lorenzo commented Oct 01 2024 at 11:58 AM

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

· 3

TheHero commented · May 05 2022 at 6:32 AM

i tried it out but having same error

0 ·

shanice.c TheHero commented · May 05 2022 at 6:57 AM

Would you try not type port number 3306?

This is my connection.

0 ·

1651733812188.png (20.9 KiB)

Borja Lorenzo TheHero commented · Oct 01 2024 at 11:58 AM

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 ·

question