Mysql Tricks : Print defaults for the current client connection

 Print defaults for the current client connection

            $ 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

        Reference tip 38 on setting up ssl connections.

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image