From 7cb0678f263326983a24b97d366d6b2ef67ce58b Mon Sep 17 00:00:00 2001 From: Frederick Muriuki Muriithi Date: Mon, 22 Aug 2022 07:38:57 +0300 Subject: Use ${HOME} for documentation. --- topics/setting-up-local-development-database.gmi | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/topics/setting-up-local-development-database.gmi b/topics/setting-up-local-development-database.gmi index 3c6c291..9d55d33 100644 --- a/topics/setting-up-local-development-database.gmi +++ b/topics/setting-up-local-development-database.gmi @@ -84,8 +84,8 @@ MariaDB [mysql]> GRANT ALL PRIVILEGES ON webqtlout.* TO 'webqtlout'@'localhost'; Now logout, and log back in as the new webqtlout user: ``` -/home/frederick/opt/gn_profiles/gn2_latest/bin/mysql \ - --defaults-file=/home/frederick/genenetwork/mariadb/my.cnf \ +${HOME}/opt/gn_profiles/gn2_latest/bin/mysql \ + --defaults-file=${HOME}/genenetwork/mariadb/my.cnf \ --user=webqtlout --host=localhost --password webqtlout ``` @@ -124,16 +124,16 @@ ${HOME}/opt/gn_profiles/gn2_latest/bin/mysqld_safe \ Then update the databases ``` -$ /home/frederick/opt/gn_profiles/gn2_latest/bin/mysql_upgrade \ - --defaults-file=/home/frederick/genenetwork/mariadb/my.cnf \ +$ ${HOME}/opt/gn_profiles/gn2_latest/bin/mysql_upgrade \ + --defaults-file=${HOME}/genenetwork/mariadb/my.cnf \ --user=frederick --password --force ``` and login as the administrative user: ``` -$ /home/frederick/opt/gn_profiles/gn2_latest/bin/mysql \ - --defaults-file=/home/frederick/genenetwork/mariadb/my.cnf \ +$ ${HOME}/opt/gn_profiles/gn2_latest/bin/mysql \ + --defaults-file=${HOME}/genenetwork/mariadb/my.cnf \ --user=$(whoami) --password ``` @@ -146,8 +146,8 @@ MariaDB [mysql]> GRANT ALL PRIVILEGES ON db_webqtl_s.* TO 'webqtlout'@'localhost now logout as the administrative user and log back in as the normal user ``` -/home/frederick/opt/gn_profiles/gn2_latest/bin/mysql \ - --defaults-file=/home/frederick/genenetwork/mariadb/my.cnf \ +${HOME}/opt/gn_profiles/gn2_latest/bin/mysql \ + --defaults-file=${HOME}/genenetwork/mariadb/my.cnf \ --user=webqtlout --host=localhost --password db_webqtlout_s MariaDB [db_webqtlout_s]> SELECT * FROM ProbeSetData LIMIT 20; -- cgit v1.2.3