diff options
author | Frederick Muriuki Muriithi | 2022-08-22 07:39:23 +0300 |
---|---|---|
committer | Frederick Muriuki Muriithi | 2022-08-22 07:40:10 +0300 |
commit | 7e4b91fd0a314f90b21c2b62c32717949716ac49 (patch) | |
tree | 7c260b9ada4c095ecbe16ce59c8834667314694f | |
parent | 7cb0678f263326983a24b97d366d6b2ef67ce58b (diff) | |
download | gn-gemtext-7e4b91fd0a314f90b21c2b62c32717949716ac49.tar.gz |
Add notes on connecting via TCP ports, rather than Unix Sockets
-rw-r--r-- | topics/setting-up-local-development-database.gmi | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/topics/setting-up-local-development-database.gmi b/topics/setting-up-local-development-database.gmi index 9d55d33..ef2d31e 100644 --- a/topics/setting-up-local-development-database.gmi +++ b/topics/setting-up-local-development-database.gmi @@ -154,3 +154,33 @@ MariaDB [db_webqtlout_s]> SELECT * FROM ProbeSetData LIMIT 20; ``` verify you see some data. + +### A Note on Connection to the Server + +So far, we have been connecting to the server by specifying --defaults-file option, e.g. + +``` +${HOME}/opt/gn_profiles/gn2_latest/bin/mysql \ + --defaults-file=${HOME}/genenetwork/mariadb/my.cnf \ + --user=webqtlout --host=localhost --password db_webqtlout_s +``` + +which allows connection via the unix socket. + +We could drop that specification and connect via the port with: + +``` +${HOME}/opt/gn_profiles/gn2_latest/bin/mysql \ + --user=webqtlout --host=127.0.0.1 --port=3307 --password db_webqtlout_s +``` + +In this version, the host specification was changed from +``` +--host=localhost +``` +to +``` +--host=127.0.0.1 +``` + +^^^whereas, the --defaults-file file specification was dropped and a new --port specification was added. |