mysql cli test

gistfile1.txt

morgo@rbook:~/sandboxes/msb_5_6_16$ cat /tmp/my.cnf 
[mysql]
user=root
password=testtttt
------------------------------------------------------------------------------------------------------------------------------------- 15:16:39
morgo@rbook:~/sandboxes/msb_5_6_16$ ~/Documents/mysql-installs/5.6.16/bin/mysql --defaults-extra-file=/tmp/my.cnf --defaults-file=/Users/morgo/sandboxes/msb_5_6_16/my.sandbox.cnf
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.6.16-log MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql [localhost] {msandbox} ((none)) > \s
--------------
/Users/morgo/Documents/mysql-installs/5.6.16/bin/mysql  Ver 14.14 Distrib 5.6.16, for osx10.7 (x86_64) using  EditLine wrapper

Connection id:		15
Current database:	
Current user:		msandbox@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.6.16-log MySQL Community Server (GPL)
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	utf8
Conn.  characterset:	utf8
UNIX socket:		/var/folders/j_/yn_r8b8d531839w0jkzglz500000gn/T//mysql_sandbox5616.sock
Uptime:			1 hour 5 min 14 sec

Threads: 1  Questions: 45  Slow queries: 0  Opens: 70  Flush tables: 1  Open tables: 63  Queries per second avg: 0.011
--------------

mysql [localhost] {msandbox} ((none)) > exit
Bye
------------------------------------------------------------------------------------------------------------------------------------- 15:17:11
morgo@rbook:~/sandboxes/msb_5_6_16$ cat ~/.my.cnf
cat: /Users/morgo/.my.cnf: No such file or directory
------------------------------------------------------------------------------------------------------------------------------------- 15:17:19
morgo@rbook:~/sandboxes/msb_5_6_16$ ~/Documents/mysql-installs/5.6.16/bin/mysql --defaults-file=/Users/morgo/sandboxes/msb_5_6_16/my.sandbox.cnf --defaults-extra-file=/tmp/my.cnf
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 5.6.16-log MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql [localhost] {msandbox} ((none)) > \s
--------------
/Users/morgo/Documents/mysql-installs/5.6.16/bin/mysql  Ver 14.14 Distrib 5.6.16, for osx10.7 (x86_64) using  EditLine wrapper

Connection id:		16
Current database:	
Current user:		msandbox@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.6.16-log MySQL Community Server (GPL)
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	utf8
Conn.  characterset:	utf8
UNIX socket:		/var/folders/j_/yn_r8b8d531839w0jkzglz500000gn/T//mysql_sandbox5616.sock
Uptime:			1 hour 6 min 13 sec

Threads: 1  Questions: 51  Slow queries: 0  Opens: 70  Flush tables: 1  Open tables: 63  Queries per second avg: 0.012
--------------

mysql [localhost] {msandbox} ((none)) >