HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Set private key password for mysql using ssl

Submitted by: @import:stackexchange-dba··
0
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 key


My 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:

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.