Date: Thu, 8 Oct 2009 10:32:29 +0700 (ICT) From: Olivier Nicole <Olivier.Nicole@cs.ait.ac.th> To: freebsd-questions@freebsd.org Subject: MySQL + SSL Message-ID: <200910080332.n983WTW3018483@banyan.cs.ait.ac.th>
next in thread | raw e-mail | index | archive | help
Hi, I have been strugling to find the correct syntax for the mysql(1) command to connect with SSL. My server is accepting SSL connections: db2<root>: mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.4.2-beta FreeBSD port: mysql-server-5.4.2 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SHOW VARIABLES LIKE '%ssl%'; +---------------+-------------------------------------------+ | Variable_name | Value | +---------------+-------------------------------------------+ | have_openssl | YES | | have_ssl | YES | | ssl_ca | /usr/local/ssl/ca/ait-itserv.crt | | ssl_capath | | | ssl_cert | /usr/local/ssl/crt/db2.cs.ait.ac.th.crt | | ssl_cipher | DHE-RSA-AES256-SHA:AES128-SHA | | ssl_key | /database/mysql/database.cs.ait.ac.th.key | +---------------+-------------------------------------------+ 7 rows in set (0.00 sec) mysql> quit Bye db2<root>: TIA, Olivier
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200910080332.n983WTW3018483>