Skip to content

Instantly share code, notes, and snippets.

@morgo
Created June 9, 2014 22:18
Show Gist options
  • Save morgo/19153cfb8f502e0d0206 to your computer and use it in GitHub Desktop.
Save morgo/19153cfb8f502e0d0206 to your computer and use it in GitHub Desktop.
mysql cli test
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)) >
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment