Guest User

Untitled

a guest
Mar 21st, 2018
262
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. # mysql --ssl
  2. mysql> show variables like '%ssl%';
  3. +---------------+-----------------+
  4. | Variable_name | Value |
  5. +---------------+-----------------+
  6. | have_openssl | YES |
  7. | have_ssl | YES |
  8. | ssl_ca | ca.pem |
  9. | ssl_capath | |
  10. | ssl_cert | server-cert.pem |
  11. | ssl_cipher | |
  12. | ssl_crl | |
  13. | ssl_crlpath | |
  14. | ssl_key | server-key.pem |
  15. +---------------+-----------------+
  16.  
  17. mysql> status
  18. --------------
  19. mysql Ver 14.14 Distrib 5.7.21-20, for debian-linux-gnu (x86_64) using 6.3
  20.  
  21. Connection id: 31
  22. Current database:
  23. Current user: root@localhost
  24. SSL: Cipher in use is ECDHE-RSA-AES128-GCM-SHA256
  25.  
  26. mysql -h 127.0.0.1 -P 3306 -u root -p --ssl-ca=/var/lib/mysql/ca.pem --ssl-cert=/var/lib/mysql/server-cert.pem --ssl-key=/var/lib/mysql/server-key.pem
  27.  
  28. ERROR 2026 (HY000): SSL connection error: error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed
Add Comment
Please, Sign In to add comment