summaryrefslogtreecommitdiff
path: root/topics/setting-up-local-development-database.gmi
diff options
context:
space:
mode:
Diffstat (limited to 'topics/setting-up-local-development-database.gmi')
-rw-r--r--topics/setting-up-local-development-database.gmi16
1 files 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;