# Issues with Dynamo-MySQL connection **URL:** \ **Category:** Developers\ **Created:** [December 2, 2019, 7:46am UTC](https://forum.dynamobim.com/t/issues-with-dynamo-mysql-connection/43876 "2019-12-02T07:46:17Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![rossella.marmo](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/rossella.marmo/32/85676_2.png) [@rossella.marmo](https://forum.dynamobim.com/u/rossella.marmo)\ **Post date:** [December 2, 2019, 7:46am UTC](https://forum.dynamobim.com/t/issues-with-dynamo-mysql-connection/43876/1 "2019-12-02T07:46:17Z")
Hello! I am trying to connect Dynamo to my database on MySQL Workbench, but I failed. I read a lot of previuos posts on this forum, but I still do not understand where I am wrong. Can you suggest me what to do to ensure that the connecton node works? I tryied the 127.0.0.1 server and localhost too. I tryied different connectionTimeout. The same query works on Workbech. ![mysql](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/0/d0416af72b4836a8caa7c23f09f775f5176ba3b4.png) ![query1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/1/8141fac833e4b637583b9fcb7f01c902cfdc7c85.png) ---
**Author:** ![Andrew\_Hannell](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/andrew_hannell/32/103315_2.png) [@Andrew\_Hannell](https://forum.dynamobim.com/u/Andrew_Hannell)\ **Post date:** [December 4, 2019, 11:09am UTC](https://forum.dynamobim.com/t/issues-with-dynamo-mysql-connection/43876/2 "2019-12-04T11:09:37Z")
there is nothing obviously wrong with your Dynamo graph- it should work (assuming you are running Dynamo on the same machine as mysql workbench and the server) Also assuming that this query works in workbench i.e is not permissions related The issue is probably with the server configuration, probably with security or connection settings. Try this: - the the actual IP address instead of localhost or 127.0.0.1 - check the connection settings in workbench to see if anything like SSL or keys/certificates is being used mysql does tend to be complicated- depending what you are doing I’d recommend SQLite, PostgresSQL or MSSQL (the free one) Refer some of my other posts on this forum ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/e/3e07ee99b7290863dfd706eeedb0dec0ed036df5.png) ---
**Author:** ![rossella.marmo](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/rossella.marmo/32/85676_2.png) [@rossella.marmo](https://forum.dynamobim.com/u/rossella.marmo)\ **Post date:** [December 4, 2019, 12:58pm UTC](https://forum.dynamobim.com/t/issues-with-dynamo-mysql-connection/43876/3 "2019-12-04T12:58:18Z")
Thank you for your reply. I have Dynamo and Workbench on the same machine. I was actually using PostgreeSQL, but as that database is not on my machine I switched on Workbench. The query works on Workbench and I checked the privileges, for the user ‘opim’ they are all activated, both administartive and schema privileges (is it good?). The SSL is not used. I tried the actual IP address, it is not working. I also tried another connections after having configurated the driver MySql ODBC 8.0 Unicode. I then tried to use Dynamo sandbox, that reports a more detailed error on the query node:‘Object reference not set to an instance of an object’. Do you know how to interpret it? Thank you for your time and patience. ![test1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/a/aae3d850f23d19a2391852d7230e6ea581c1ca29.png) ![test2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/7/a7c4c18f17f0d29a70057f5407bc651c9e2fd9f5.png) ---
**Author:** ![Andrew\_Hannell](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/andrew_hannell/32/103315_2.png) [@Andrew\_Hannell](https://forum.dynamobim.com/u/Andrew_Hannell)\ **Post date:** [December 5, 2019, 10:05am UTC](https://forum.dynamobim.com/t/issues-with-dynamo-mysql-connection/43876/4 "2019-12-05T10:05:08Z")
I don’t know- it is very difficult to diagnose remotely. Can you create a ODBC connection, and import the data say in Excel ? Unless there is a very compelling reason to use mysql- I’d seriously look at the other options I suggested SQLite is the simplest- just a single file- not ports, SSL, named pipes, schemas etc to worry about ---
**Author:** ![rossella.marmo](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/rossella.marmo/32/85676_2.png) [@rossella.marmo](https://forum.dynamobim.com/u/rossella.marmo)\ **Post date:** [December 5, 2019, 2:31pm UTC](https://forum.dynamobim.com/t/issues-with-dynamo-mysql-connection/43876/5 "2019-12-05T14:31:20Z")
Hello, at the end I tried SQLite and it works! Unfortunately I have to manage to fill this new database, but at least the connection works. BTW the database on Workbench was connected to Excel. Thank you for your support ![sqlite test](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/b/db9f0087ad26eeaee6b6bac298e72c03ea546b7e.png) ---
**Author:** ![Andrew\_Hannell](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/andrew_hannell/32/103315_2.png) [@Andrew\_Hannell](https://forum.dynamobim.com/u/Andrew_Hannell)\ **Post date:** [December 6, 2019, 4:32am UTC](https://forum.dynamobim.com/t/issues-with-dynamo-mysql-connection/43876/6 "2019-12-06T04:32:17Z")
I believe there is a Workbench plug-in (Python?) which will export from MySQL—\> SQLite Otherwise, there are other methods ---
**Author:** ![ahmed.emad](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/ahmed.emad/32/108517_2.png) [@ahmed.emad](https://forum.dynamobim.com/u/ahmed.emad)\ **Post date:** [March 11, 2021, 3:34pm UTC](https://forum.dynamobim.com/t/issues-with-dynamo-mysql-connection/43876/7 "2021-03-11T15:34:50Z")
Hi Rossella, I just started using SQLite and tried this command “SELECT … FROM …” that was very helpful. How do I get to know more commands like reading and updating the database? I googled that, but didn’t get anywhere! Thank you in advance ---
**Author:** ![rossella.marmo](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/rossella.marmo/32/85676_2.png) [@rossella.marmo](https://forum.dynamobim.com/u/rossella.marmo)\ **Post date:** [March 11, 2021, 4:22pm UTC](https://forum.dynamobim.com/t/issues-with-dynamo-mysql-connection/43876/8 "2021-03-11T16:22:50Z")
Hello! You need to look for the Data Manipulation Language (DML) and the Data Definition Language (DDL) of SQL. Have you googled ‘sql syntax’? there are plenty of websites on this topic.