Mysql:Print defaults for the current client connection
by Mohan[ Edit ] 2012-09-20 08:20:23
<h2> Print defaults for the current client connection
</h2>
$ my_print_defaults client mysql
--port=3306
--socket=/tmp/mysql.sock
--no-auto-rehash
Note, for client connections, you can put setting in
the user's .my.cnf file. This file is located in their
home directory.
~/.my.cnf
Example file that stores the user and password plus
ssl settings that will connect to the remote
hosts big.squeezel.com.
[client]
user=admin
password=pass32rD
host=big.squeezel.com
ssl-ca=/etc/mysql/cacert.pem
ssl-cert=/etc/mysql/laptopFOO-cert.pem
ssl-key=/etc/mysql/laptopFOO-key.pem