diff options
| author | Pjotr Prins | 2023-11-12 10:45:58 +0100 |
|---|---|---|
| committer | Pjotr Prins | 2023-11-12 10:45:58 +0100 |
| commit | 2acf22848c9cc7409dbdd4a589cb0128064e2695 (patch) | |
| tree | 7dcbb428130e1b8a98dad583ce19dcc9ed150590 | |
| parent | fdc57d7e7373414305172728966b8485e0a7b45c (diff) | |
| download | gn-gemtext-2acf22848c9cc7409dbdd4a589cb0128064e2695.tar.gz | |
Info on running mariadb over the network
| -rw-r--r-- | topics/setting-up-local-development-database.gmi | 16 | ||||
| -rw-r--r-- | topics/systems/mariadb/precompute-mapping-input-data.gmi | 2 |
2 files changed, 16 insertions, 2 deletions
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: |