patternsqlMinor
Set private key password for mysql using ssl
Viewed 0 times
privatepasswordmysqlforusingsslsetkey
Problem
2016-05-09T20:05:05.772747Z 0 [ERROR] SSL error: Unable to get private key from 'server-key.pem'
2016-05-09T20:05:05.772764Z 0 [Warning] Failed to set up SSL because of the following SSL library error: Unable to get private keyMy installation correctly locates the certificate files however it does not start SSL as it is unable to get the pass phrase for the private key.
How can I configure a passphrase in the mysql configuration?
I have tried removing the passphrase from the key but openssl on ubuntu 16.04 requires a minimum passphrase length of 4 characters.
Solution
I had to make sure that mysql owned the .pem files by cd to directory that contains the .pem files and:
After doing that the problem was solved.
chown -R mysql .
chgrp -R mysql .After doing that the problem was solved.
Code Snippets
chown -R mysql .
chgrp -R mysql .Context
StackExchange Database Administrators Q#138051, answer score: 2
Revisions (0)
No revisions yet.