From 2acf22848c9cc7409dbdd4a589cb0128064e2695 Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Sun, 12 Nov 2023 10:45:58 +0100
Subject: Info on running mariadb over the network

---
 topics/setting-up-local-development-database.gmi         | 16 +++++++++++++++-
 topics/systems/mariadb/precompute-mapping-input-data.gmi |  2 +-
 2 files changed, 16 insertions(+), 2 deletions(-)

(limited to 'topics')

diff --git a/topics/setting-up-local-development-database.gmi b/topics/setting-up-local-development-database.gmi
index 58e19ad..edac4e0 100644
--- a/topics/setting-up-local-development-database.gmi
+++ b/topics/setting-up-local-development-database.gmi
@@ -92,7 +92,7 @@ export TMPDIR=/tmp
 mysqld_safe --datadir='/var/lib/mysql/' --port=3307 --user=$USER --group=users --nowatch --socket=/var/run/mysqld/mysqld.sock
 ```
 
-Now from outside the container you should be able to connect with
+Now from the container you should be able to connect with the socket
 
 ```
 /export/mysql$ ~/opt/guix-pull/bin/guix shell mysql -- mysql --socket=var/run/mysqld/mysqld.sock -uwebqtlout -pwebqtlout db_webqtl
@@ -121,6 +121,20 @@ MariaDB [(none)]> show databases;
 4 rows in set (0.001 sec)
 ```
 
+To run/bind on a network interface we can open up completely (dangerous) with:
+
+```
+export TMPDIR=/tmp
+mysqld_safe --datadir='/var/lib/mysql/' --port=3307 --user=$USER --group=users --nowatch --bind-address 0.0.0.0 --socket=/var/run/mysqld/mysqld.sock
+```
+
+Test
+
+
+```
+ ~/opt/guix-pull/bin/guix shell mysql -- mysql -uwebqtlout -pwebqtlout db_webqtl -h 127.0.0.1 --port=3307
+```
+
 If you need to tweak the server configuration you can load the my.cnf file with the `--defaults-file=var/my.cnf` inside and outside the container.
 
 ## Method 3 (Manual method without Guix)
diff --git a/topics/systems/mariadb/precompute-mapping-input-data.gmi b/topics/systems/mariadb/precompute-mapping-input-data.gmi
index 20b23d4..a3142e6 100644
--- a/topics/systems/mariadb/precompute-mapping-input-data.gmi
+++ b/topics/systems/mariadb/precompute-mapping-input-data.gmi
@@ -706,7 +706,7 @@ mkdir tmp
 mkdir run
 tux04:/export/mysql$ ~/opt/guix-pull/bin/guix shell -C -N coreutils sed mariadb --share=/export/mysql/var=/var --share=/export/mysql/tmp=/tmp
     export TMPDIR=/tmp
-    mysqld_safe --datadir='/var/lib/mysql/' --port=3307 --user=$USER --group=users --nowatch --socket=/var/run/mysqld/mysqld.sock
+    mysqld_safe --datadir='/var/lib/mysql/' --protocol tcp  --port=3307 --user=$USER --group=users --nowatch
 ```
 
 and a client with:
-- 
cgit v1.2.3