MySQL + SSL

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
_______________________________________________
freebsd-questions@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: MySQL FC3
    ... >> After you get your mysql back up and running, ... > same user that the mysqld server runs as. ... > You can stop the MySQL server by sending a normal kill (not kill ... > cat command; these cause the output of cat to be substituted into the ...
    (Fedora)
  • Re: MySQL permission
    ... > you after installing the initial database you would not have this problem. ... I just gave the command "sudo yum install mysql-server". ... on my MySQL server, and have not had any problems on that score. ...
    (comp.os.linux.misc)
  • Re: mysql_connect stops via php
    ... But can you do it from a command line on your web server? ... And if it is another server, can you connect to the MySQL database from the command line there? ... phpinfo() still reported the MySQL ...
    (comp.lang.php)
  • Re: Tomcat connecting to MySQL - Ubuntu 8.10 Server
    ... Mysql must have a command line client. ... This should work on a default install, but ymmv if passwords and users ... I can use the mysql command line client with no problems. ... Server in a virtual machine, ...
    (Ubuntu)
  • Re: using mysql client to read a file to create a table in a database in a mysql server
    ... so I wonder what is the syntax of the mysql command, ... Also because I am using mysql server 4.1.16 the installed client ... When you issue a mysql statement from the command line, ... I know that I can create the table by typing the commands in to the ...
    (comp.lang.ruby)