R
R
Rollex2021-05-20 15:20:55
MySQL
Rollex, 2021-05-20 15:20:55

How to enable SSL on MySQL 8.0?

The thoughts are gone. Can't stop connecting without SSL. Connects with or without keys. What I have:
Percona mysql 8.0
Created a user with the following settings:

CREATE USER 'user'@'%' IDENTIFIED BY 'pass' REQUIRE SSL;
GRANT ALL ON *.* TO 'pass'@'%';
FLUSH PRIVILEGES;

Tried adding to /etc/mysql/my.cnf
[mysqld]
#ssl
ssl_ca= /var/lib/mysql/ca.pem
ssl_cert= /var/lib/mysql/server-cert.pem
ssl_key= /var/lib/mysql/server-key.pem

[mysqld]
# Require clients to connect either using SSL
# or through a local socket file
require_secure_transport=ON

But since this is mysql 8.0, these settings are parallel to it.
I also tried
mysql>SET PERSIST require_secure_transport=ON;
To no avail...

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question