dotfiles/my.cnf at master · goodtimeaj/dotfiles · GitHub

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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
# vim:ft=sh:

# Passed to all MySQL clients
[client]
# Set utf-8 (default: latin1)
default-character-set=utf8
user=root
password=
host=127.0.0.1
port=3306
socket=/tmp/mysql.sock

# MySQL server
[mysqld]
tmpdir=/tmp
datadar=/usr/local/var/mysql
socket=/tmp/mysql.sock

# MySQL prompt
[mysql]
# Set utf-8 (default: latin1)
default-character-set=utf8
# Start MySQL faster but need to `rehash` for tab completion
# no-auto-rehash
# Show warnings after each statement if there are any
show-warnings
# Custom terminal prompt
prompt='\u @ \h : \d> '

# List of all MySQL command shortcuts:
# http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html
# Note that all text commands must be first on line and end with ';'
# ?         (\?) Synonym for `help'.
# clear     (\c) Clear command.
# connect   (\r) Reconnect to the server. Optional arguments are db and host.
# delimiter (\d) Set statement delimiter.
# edit      (\e) Edit command with $EDITOR.                                   *
# ego       (\G) Send command to mysql server, display result vertically.
# exit      (\q) Exit mysql. Same as quit.
# go        (\g) Send command to mysql server.                                *
# help      (\h) Display this help.
# nopager   (\n) Disable pager, print to stdout.
# notee     (\t) Don't write into outfile.
# pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
# print     (\p) Print current command.
# prompt    (\R) Change your mysql prompt.
# quit      (\q) Quit mysql.                                                  *
# rehash    (\#) Rebuild completion hash.
# source    (\.) Execute an SQL script file. Takes a file name as an argument.
# status    (\s) Get status information from the server.
# system    (\!) Execute a system shell command.
# tee       (\T) Set outfile [to_outfile]. Append everything into given
#                outfile.
# use       (\u) Use another database. Takes database name as argument.
# charset   (\C) Switch to another charset. Might be needed for processing
#                binlog with multi-byte charsets.
# warnings  (\W) Show warnings after every statement.
# nowarning (\w) Don't show warnings after every statement.