Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to connect to MySQL Server from AnyLogic?

April 26, 2017anylogic Connect MySQL server

0

0 Posted

How to connect to MySQL Server from AnyLogic?

1 Answer

0

0 Posted

At first, please add Database component to your model and then follow the instructions below to connect AnyLogic model to the MySQL database: • Download the required driver (zip archive) from: http://dev.mysql.com/downloads/connector/j/5.1.html • Copy all driver files to the model’s folder. • Open the model in AnyLogic, select it in the Projects view and import driver JAR file on Dependencies tab. • Go to the advanced properties of Main and type the following line in Import section: import com.mysql.jdbc.Driver; • Select database and type com.mysql.jdbc.Driver in JDBC driver property. • Connection URL should look like the following: jdbc:mysql://host:port host – is the ip address of the database, e.g. 18.40.10.8 port – the default value is 3306 • Specify login and password for the database.