MariaDB addon - sql workbench fails to connect

Configuration
1

I’m playing around with the mariadb. The connection string used core-mariadb not the IP.
It is connected now and feeding in data.

Eventually got grafana to connect by using ‘core-mariadb’ instead of localhost or the IP.
I was almost ready to delete the add on and add the mysql core on ubuntu using command line interface

But I would really like to use msql workbench also. I’ve added odbc connection but cannot get it to connnect to the mysql db.

Had anyone successfully connected to mariadb using the workbench?

Thanks

2

Now we’re in business!!!

Needed to add 3306 under HOST in the config.
Now I can see everything clearly.

mysql
mysql1837×960 89.2 KB

1 Like
3

I used setting as you suggested but still cannot get connected to the DB.
Do you still use this configuration?
Do you know if any SSL setting were defined? Any other information would be greatly appreciated.
thanks,

4

image

5

I was able to use my HA IP to make a connection. Along with my db admin creds.

6

Hello,
I would like to connect to my MariaDB instance hosted on Home Assistant using MySQL Workbench via the URL provided by Home Assistant Cloud. Could you provide guidance on how to achieve this.
Thank you!