Solved Mariadb / MySQL databases --remote access


jimbo45

Well-known member
Pro User
VIP
Local time
9:29 PM
Posts
5,807
Location
Hafnarfjörður IS
OS
Windows XP,11 Linux Fedora Rawhide pre-release 45
Hi folks
for people who like to use MariaDB / MySQL databases remotely - even if you are on a Windows VM and the DB is on the Host system (that as far as the VM is concerned) is a remote system.

Note the MySQL db here is NOT MySQL from Microsoft but the equivalent to the now much more used free open source Mariadb (source and command compatible). It's the same file whether on Windows or Linux -- not sure what the directory name on Windows is but I'm sure it's easily findable.

Simply change the bind-address parameter in the MariaDB / MySQL configuration file on the machine containing th DB you want to access and restart the mariadb server to 0.0.0.0.

The default setting is to localhost access only.


Screenshot_20240418_102445.png


Cheers
jimbo
 

My Computer My Computer

At a glance

Windows XP,11 Linux Fedora Rawhide pre-releas...2 X Intel i7
OS
Windows XP,11 Linux Fedora Rawhide pre-release 45
Computer type
PC/Desktop
CPU
2 X Intel i7
Screen Resolution
4KUHD X 2
Back
Top Bottom