aboutsummaryrefslogtreecommitdiff
path: root/sh/shrc.d/mysql.sh
diff options
context:
space:
mode:
Diffstat (limited to 'sh/shrc.d/mysql.sh')
-rw-r--r--sh/shrc.d/mysql.sh19
1 files changed, 19 insertions, 0 deletions
diff --git a/sh/shrc.d/mysql.sh b/sh/shrc.d/mysql.sh
new file mode 100644
index 00000000..00b6930c
--- /dev/null
+++ b/sh/shrc.d/mysql.sh
@@ -0,0 +1,19 @@
+# If a file ~/.mysql/$1.cnf exists, call mysql(1) using that file. Otherwise
+# just run MySQL with given args. Use restrictive permissions on these files.
+# Examples:
+#
+# [client]
+# host=dbhost.example.com
+# user=foo
+# password=SsJ2pICe226jM
+#
+# [mysql]
+# database=bar
+#
+mysql() {
+ if [ -f "$HOME"/.mysql/"$1".cnf ] ; then
+ shift
+ set -- --defaults-extra-file="$HOME"/.mysql/"$1".cnf "$@"
+ fi
+ command mysql "$@"
+}