Solved Remote access to Mysql / Maria DB

Hi folks
If you are having problems getting remote access to Mariadb / MySQL databases and the DB is hosted on a Debian based Linux server a common fault is that the DB server config is set by default to only accept local host connections.

Assuming you are authorised to acces the DB you need to comment out a line in the config file :


# 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





If you don't do this then the system only listens (usually on port 3306) via local host. The file is on most debian type systems in /etc/mysql/mariadb.conf.d /50-server-cnf but could be different for different distros. If you have MariaDB / MySQL on a Windows server / host then similllar needs to be done although where the config file is ????.

Cheers
jimbo

On windows, the file is my.ini in the mariadb data folder.

z3r010 said:

On windows, the file is my.ini in the mariadb data folder.

Click to expand...

Thanks !!!

Will try it on on Windows too. What is strange that even on Windows you can connect to a remote computer via phypmadmin using a browser such as firefox (enter remoteserver ip addr/myphpadmin as the url and it will connect - assuming myphmadmin is installed on the remote server regardless of the settings in the mariadb config file, even though other methods such as hiedisql or data query via excel both of which require an obdc connector won't connect until you disable the only listen to localhost. So some security loophole there it would appear in default settings of phpmyadmin whivh is actually quite a good tool !!!

However unless you are using Apache on Windows and have installed the W.A.M.P stack (Windows, Apache, MySql(MariaDB) and php it might be a moot point since many probably use IIS as their Internet server or equivalent - although Apache is easy too.

I'll have a play with this as it could be a bit of a security nightmare !!.

cheers
jimbo