Secure remote sql through ssl

Hi, we have a customer with a Magento website. There was indexing issues which caused 5 days of stress, which we eventually found was caused by MariaDB 10.3 after upgrading based on Cpanel's "recommeded" in WHM! We migrated the database to another server and set up an account with remote sql, then allowed Magento to connect through the firewall. I have seen articles requesting SSL support for the env file in Magento and there are ways to add it. Is there a way of making Cpanel's remote sql in Cpanel use SSL to ensure the data is secure between the server and Magento on anther server.

cPanelLauren

October 29, 2019 16:28

Hello, I'd suggest reading the following thread for this: As far as the indexing issues you encountered, from which version of MySQL did you move from?

uk01

October 29, 2019 17:15

Hi thanks I"ll take a look at the link. It was MariaDB 10.1 or 2. Cpanel puts 10.3 recommended but there is a bug in 10.3 which affects Magento indexing. Something relating to requests wrapped in quotes.

Secure remote sql through ssl

Comments

Didn't find what you were looking for?