# \[APP\]\[PRO\] MySQL-Client **URL:** \ **Category:** Apps\ **Tags:** app, tools, homey-pro\ **Created:** [April 7, 2022, 7:18pm UTC](https://community.homey.app/t/app-pro-mysql-client/62459 "2022-04-07T19:18:16Z")\ **Posts on this page:** 19\ **Page:** 6
**Author:** ![RonnyW](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ronnyw/32/10879_2.png) [@RonnyW](https://community.homey.app/u/RonnyW)\ **Post date:** [July 2, 2025, 6:53pm UTC](https://community.homey.app/t/app-pro-mysql-client/62459/101 "2025-07-02T18:53:33Z")
Sure, just add a second Database device. ---
**Author:** ![Pat\_M](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/pat_m/32/56295_2.png) [@Pat\_M](https://community.homey.app/u/Pat_M)\ **Post date:** [July 2, 2025, 7:03pm UTC](https://community.homey.app/t/app-pro-mysql-client/62459/102 "2025-07-02T19:03:06Z")
Perfect - Thanks! Jjust wanted to make sure! 🙂 ---
**Author:** ![Pat\_M](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/pat_m/32/56295_2.png) [@Pat\_M](https://community.homey.app/u/Pat_M)\ **Post date:** [July 4, 2025, 7:17am UTC](https://community.homey.app/t/app-pro-mysql-client/62459/103 "2025-07-04T07:17:07Z")
Sorry, I tried reading the FAQ but I still don’t get it. How do I use the output from a flow that makes a select from a table? I created the SELECT flow, it works, but the second flow cannot get the result from the first flow? Thanks! ---
**Author:** ![RonnyW](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ronnyw/32/10879_2.png) [@RonnyW](https://community.homey.app/u/RonnyW)\ **Post date:** [July 4, 2025, 8:00am UTC](https://community.homey.app/t/app-pro-mysql-client/62459/104 "2025-07-04T08:00:41Z")
Are you using standard or advanced flow? Advanced flow is much easier because you can concatinate the cards. > [@\[APP\]\[PRO\] MySQL-Client](https://community.homey.app/t/app-pro-mysql-client/62459/42): > > With test version 0.0.11, flow tokens for Advanced Flows are added for the flow action “Execute SQL query”. Using these tokens, you can directly use the SQL result in your flow. With the new logic cards you canparse the reault JSON string and extract more than only the first field. Example: This flow is: executing the SELECT statement, reading one line from the table printing the result JSON string to the timeline extracting line1, field “gas\_meter” from the JSON printing this va… ---
**Author:** ![Pat\_M](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/pat_m/32/56295_2.png) [@Pat\_M](https://community.homey.app/u/Pat_M)\ **Post date:** [July 4, 2025, 8:27am UTC](https://community.homey.app/t/app-pro-mysql-client/62459/105 "2025-07-04T08:27:17Z")
Thanks @RonnyW - It turned out that Homey was a bit crazy when I tried this. I works great today! And thank you for this app, it wouldn’t be possible to run my home and Homey without it - supergreat work! 🙂 Thanks! ---
**Author:** ![Yustmenl](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/yustmenl/32/10659_2.png) [@Yustmenl](https://community.homey.app/u/Yustmenl)\ **Post date:** [September 11, 2025, 10:20am UTC](https://community.homey.app/t/app-pro-mysql-client/62459/106 "2025-09-11T10:20:42Z")
I have a question, i moved my mysql server to a new network, can i change the IP of the device so my flows keep working? ---
**Author:** ![RonnyW](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ronnyw/32/10879_2.png) [@RonnyW](https://community.homey.app/u/RonnyW)\ **Post date:** [September 12, 2025, 5:39am UTC](https://community.homey.app/t/app-pro-mysql-client/62459/107 "2025-09-12T05:39:55Z")
I have not checked in detail, but it seems the device currently supports a setup on pairing. I have to add a repair view to change the settings (IP, user). So if you need a direct switch to the new DB, it needs to be added as new device. If it hast some time, I can add a repair functionality. ---
**Author:** ![RonnyW](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ronnyw/32/10879_2.png) [@RonnyW](https://community.homey.app/u/RonnyW)\ **Post date:** [September 12, 2025, 2:31pm UTC](https://community.homey.app/t/app-pro-mysql-client/62459/108 "2025-09-12T14:31:13Z")
New **test version 1.1.0** : - Added **repair view** to update DB connection > **[MySQL](https://homey.app/en-us/app/de.ronnywinkler.mysql/MySQL/test/)** > > Access your MySQL database from Homey @Yustmenl FYI and test ---
**Author:** ![Yustmenl](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/yustmenl/32/10659_2.png) [@Yustmenl](https://community.homey.app/u/Yustmenl)\ **Post date:** [September 12, 2025, 5:35pm UTC](https://community.homey.app/t/app-pro-mysql-client/62459/109 "2025-09-12T17:35:41Z")
That is fast, i Will test it next week. Thanks ---
**Author:** ![Thorbjorn\_Wiik](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/thorbjorn_wiik/32/83137_2.png) [@Thorbjorn\_Wiik](https://community.homey.app/u/Thorbjorn_Wiik)\ **Post date:** [January 9, 2026, 4:20am UTC](https://community.homey.app/t/app-pro-mysql-client/62459/110 "2026-01-09T04:20:31Z")
Hi, I have ran into problems after a system restart. Can no longer connect to mysql database. ---
**Author:** ![RonnyW](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ronnyw/32/10879_2.png) [@RonnyW](https://community.homey.app/u/RonnyW)\ **Post date:** [January 9, 2026, 2:09pm UTC](https://community.homey.app/t/app-pro-mysql-client/62459/111 "2026-01-09T14:09:21Z")
Which systen was restarted? Your DB server? Has it a fixed IP or DHCP reservation? What error message is shown in your flow? Test the flow or ise the error output of the flow card to write the error message to the timeline. ---
**Author:** ![Thorbjorn\_Wiik](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/thorbjorn_wiik/32/83137_2.png) [@Thorbjorn\_Wiik](https://community.homey.app/u/Thorbjorn_Wiik)\ **Post date:** [January 9, 2026, 2:50pm UTC](https://community.homey.app/t/app-pro-mysql-client/62459/112 "2026-01-09T14:50:43Z")
Thank you for replying. Due to power fault all my systems where restarted. I’m using DHCP and have run: ipconfig /flushdns. No problem in reacing my db-server from another pc using host-name. But when I try to connect MySQL-app to the database nothing happens. No messages what so ever. PS. All was working fine until this power fault happened. Best regards Thorbjørn ---
**Author:** ![RonnyW](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ronnyw/32/10879_2.png) [@RonnyW](https://community.homey.app/u/RonnyW)\ **Post date:** [January 9, 2026, 3:39pm UTC](https://community.homey.app/t/app-pro-mysql-client/62459/113 "2026-01-09T15:39:30Z")
Did your server get a new IP? In this case, please repair yor SqlDB device. Then you can connect again - in detail you just change rhe uses IP. ---
**Author:** ![Thorbjorn\_Wiik](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/thorbjorn_wiik/32/83137_2.png) [@Thorbjorn\_Wiik](https://community.homey.app/u/Thorbjorn_Wiik)\ **Post date:** [January 9, 2026, 3:50pm UTC](https://community.homey.app/t/app-pro-mysql-client/62459/114 "2026-01-09T15:50:18Z")
Thank you again. My network uses dynamic ip-addresses. Therefor I had to flushdns. But I have also tried to connect using actual IP-address. But still no response. Connection settings: Server: , port = 3606, user=\, password=\<\\>, When I press “Test Connection”, nothing happens. No message. I really dont understand whats going on here ??? ---
**Author:** ![Thorbjorn\_Wiik](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/thorbjorn_wiik/32/83137_2.png) [@Thorbjorn\_Wiik](https://community.homey.app/u/Thorbjorn_Wiik)\ **Post date:** [January 10, 2026, 11:02am UTC](https://community.homey.app/t/app-pro-mysql-client/62459/115 "2026-01-10T11:02:27Z")
Problem solved! Had to restart Homey after command: ipconfig /flushdns. This way homey got a new updated list of IPs from my network. Thank you for your responses and have a nice day. ---
**Author:** ![Peter\_vd\_Kerkhof](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_vd_kerkhof/32/48934_2.png) [@Peter\_vd\_Kerkhof](https://community.homey.app/u/Peter_vd_Kerkhof)\ **Post date:** [July 28, 2026, 9:08am UTC](https://community.homey.app/t/app-pro-mysql-client/62459/116 "2026-07-28T09:08:41Z")
Have SHS (in Docker) running on my Synology NAS Also MariaDB as part of local webserver. I’n not abble to add mariaDB as a new device in Homey Tried localhost/IPadress & port 3306/3307 Suggestions? ---
**Author:** ![RonnyW](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ronnyw/32/10879_2.png) [@RonnyW](https://community.homey.app/u/RonnyW)\ **Post date:** [July 28, 2026, 9:15am UTC](https://community.homey.app/t/app-pro-mysql-client/62459/117 "2026-07-28T09:15:39Z")
Is the DB running on the NAS directly or also inside a container? If on the NAS, you should be able to use the NAS IP and DB port. If the DB is inside a container, it depends on container settings (host/bridge mode and if the ports are mapped from container to outside). ---
**Author:** ![Peter\_vd\_Kerkhof](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_vd_kerkhof/32/48934_2.png) [@Peter\_vd\_Kerkhof](https://community.homey.app/u/Peter_vd_Kerkhof)\ **Post date:** [July 28, 2026, 9:35am UTC](https://community.homey.app/t/app-pro-mysql-client/62459/118 "2026-07-28T09:35:50Z")
MariaDB is running directly on my NAS (Standard package) With IP and port3307 is seems to connect, but then the output is immediately refreshed and i get an error message. See image ![mysqlerr1](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/7/5/75835b1ab0b73834703f154d8200d88da4c6fdfc.jpeg) ---
**Author:** ![Peter\_vd\_Kerkhof](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_vd_kerkhof/32/48934_2.png) [@Peter\_vd\_Kerkhof](https://community.homey.app/u/Peter_vd_Kerkhof)\ **Post date:** [July 28, 2026, 10:00am UTC](https://community.homey.app/t/app-pro-mysql-client/62459/119 "2026-07-28T10:00:56Z")
Verified that MariaDB is running on port 3306 Verified user&password! ![mysqlerr2](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/2/02ebc640c996eb8a3bf99a9947e18b8cd1b0a794.jpeg) [Previous page](https://community.homey.app/t/app-pro-mysql-client/62459.md?page=5)