aboutsummaryrefslogtreecommitdiff
path: root/sh/shrc.d/mysql.sh
blob: abb496d26d07ea3d405da8a3834c6ea3d4832e42 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
# If a file ~/.mysql/$1.cnf exists, call mysql(1) using that file, discarding
# the rest of the arguments. Otherwise just run MySQL with given args. Use
# restrictive permissions on these files. Doesn't allow filenames beginning
# with hyphens.
#
# Examples:
#
#   [client]
#   host=dbhost.example.com
#   user=foo
#   password=SsJ2pICe226jM
#
#   [mysql]
#   database=bar
#
mysql() {
    case $1 in
        -*) ;;
        *)
            [ -f "$HOME/.mysql/$1".cnf ] &&
                set -- --defaults-extra-file="$HOME/.mysql/$1".cnf
            ;;
    esac
    command mysql "$@"
}