Solved HeidiSQL and remote MariaDB / MySQL DB

Hi folks
You might find tht if you use HediSQL to access / get queries / data from MySQL / MariaDB tyoe of DB's on remote servers - the default has been changed in the MySQL /MariaDB config file. The default is now Localhost so you won't get a connection say from a Windows laptop wanting to connect to a remote MySQL type DB - this also includes accessing a DB on a VM from a Windows Host even if the VM is physically on the same host as the Windows system. Same problem if you use EXCEL queries to retrieve data from the remote DB's.

For EXCEL you also need to install the MariaDB ODBC driver on windows.

So you need to comment out the line in blue (extract from the config file).
Note that the location of the config file depends on the host etc.

Restart the Database server after updating the file.

Extract of config file :

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]

#
# * Basic Settings
#

#user = mysql
pid-file = /run/mysqld/mysqld.pid
basedir = /usr
#datadir = /var/lib/mysql
#tmpdir = /tmp

# Broken reverse DNS slows down connections considerably and name resolve is
# safe to skip if there are no "host by domain name" access grants
#skip-name-resolve

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.

#bind-address = 127.0.0.1 <<<<<=====================This line

#
# * Fine Tuning
#

,,,,,,

If you don't then you can only access the DB's if they are on localhost.

Cheers
jimbo