Mysql:Print defaults for the current client connection

by Mohan 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
904
like
0
dislike
0
mail
flag

You must LOGIN to add comments