• Resolved benivalero

    (@benivalero)


    Hello
    I have a problem with the connection to my MySQL with SSL from my WordPress. I can to use from my computer with the cert .pem a client MySQL and connect without any problem to my BD. How I can use the .cert in WordPress ?

    I’ve connect to my MySQL editing the following file and add the cert

    Client Mysql –> Usuario@nginx-php:/$ nano /etc/mysql/my.cnf
    [client]
    ssl-ca = /var/cert_mysql/SSL_server-ca.pem
    ssl-cert = /var/cert_mysql/SSL_client-cert.pem
    ssl-key = /var/cert_mysql/SSL_client-key.pem

    I’ve read on the Internet as other users did… But it does not work –> Usuario@nginx-php:/$ nano /var/www/websites/domain01/wp-config.php

    define(‘MYSQL_SSL_KEY’, ‘/var/cert_mysql/SSL_client-key.pem’);
    define(‘MYSQL_SSL_CERT’, ‘/var/cert_mysql/SSL_client-cert.pem’);
    define(‘MYSQL_SSL_CA’, ‘/var/cert_mysql/SSL_server-ca.pem’);
    define(‘MYSQL_SSL_CA_PATH’, ‘/var/cert_mysql’);
    define(‘MYSQL_CLIENT_FLAGS’, MYSQLI_CLIENT_SSL );

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hey @benivalero

    Do you have any logs of the errors you’re getting back when using that setting?

    Thanks~

    Thread Starter benivalero

    (@benivalero)

    Log:

    Warning: mysqli_real_connect(): (HY000/1045): Access denied for user ‘wordpress_valero-torres’@’xx.xx.xx.xx’ (using password: YES) in /var/www/websites/domain01/wp-includes/wp-db.php on line 1635
    Access denied for user ‘wordpress_valero-torres’@’xx.xx.xx.xx’ (using password: YES)

    I’ve change MySQL ip by xx.xx.xx.xx

    If i forced my MySQL server to not use SSL i can connect witout any problem.

    Hey @benivalero,

    Based on that error it looks like the MySQL connection is working, but the DB access is not. There are a few items in the FAQ that may provide a solution to this issue, this one may get you going.

        – I’m running into issues with the Database what can I do?
        – https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-100-q

    See the section “Access Denied”

    Let me know if this helps~

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘MySQL SSL’ is closed to new replies.