{"id":10919,"date":"2025-01-17T07:20:55","date_gmt":"2025-01-17T07:20:55","guid":{"rendered":"https:\/\/www.webystrata.co.uk\/blog\/?p=10919"},"modified":"2025-01-17T07:20:55","modified_gmt":"2025-01-17T07:20:55","slug":"how-to-enable-mysql-connections","status":"publish","type":"post","link":"https:\/\/www.webystrata.co.uk\/blog\/how-to-enable-mysql-connections\/","title":{"rendered":"How to Enable Encrypted MySQL Connections"},"content":{"rendered":"

\"How<\/a><\/h1>\n

How to Enable Encrypted MySQL Connections<\/h1>\n
\n
\n

To use WHMCS with an encrypted MySQL\u00ae connection, you will need to perform additional steps to configure the necessary settings to the configuration.php<\/code>\u00a0file.<\/p>\n<\/div>\n<\/div>\n

\n
\n

We added support for encrypted MySQL connections in WHMCS 8.8.<\/p><\/blockquote>\n<\/div>\n<\/div>\n

\n
\n

For steps to configure encrypted MySQL connections on cPanel & WHM servers, see\u00a0cPanel’s How to Configure MySQL SSL Connections Documentation<\/a>.<\/p><\/blockquote>\n<\/div>\n<\/div>\n

\n
\n

You\u00a0cannot\u00a0<\/strong>configure this before or during the installation process using the browser-based installation method. Because of this, you\u00a0cannot\u00a0<\/strong>use the browser-based method if your server\u00a0requires\u00a0<\/strong>encrypted connections.<\/p><\/blockquote>\n<\/div>\n<\/div>\n

\n

Configuration Before Installation (CLI)<\/h2>\n
\n
\n

To enable encrypted MySQL connections before proceeding with the\u00a0CLI-based installation method<\/a>:<\/p>\n

    \n
  1. Open the\u00a0configuration.php<\/code>\u00a0file in your preferred text editor.<\/li>\n
  2. Update the necessary configuration settings, replacing the example values below with your server’s information:<\/li>\n<\/ol>\n<\/div>\n<\/div>\n
    \n
    $db_tls_ca='\/path\/to\/ca\/file';\r\n$db_tls_ca_path='\/path\/to\/ca\/directory';\r\n$db_tls_cert='\/path\/to\/client\/cert';\r\n$db_tls_cipher='AES256-SHA';\r\n$db_tls_key='\/path\/to\/client\/key';\r\n$db_tls_verify_cert='0';<\/code><\/pre>\n
    <\/div>\n<\/div>\n
    \n
    \n
    The settings that you configure will depend on your server’s configuration.<\/p><\/blockquote>\n<\/div>\n<\/div>\n
    \n
    \n
    3. Proceed with installation via the command line.<\/p>\n<\/div>\n<\/div>\n<\/div>\n
    \n
    Configuration During Installation (CLI)<\/h2>\n
    \n
    \n
    To enable encrypted MySQL connections during the\u00a0CLI-based installation process<\/a>, use the\u00a0-c<\/code>\u00a0or\u00a0--config<\/code>\u00a0options while running the command-line installation script.<\/p>\n
    Include the following lines in your JSON input, replacing the example values below with your server’s information:<\/p>\n<\/div>\n<\/div>\n
    \n
    \"db_tls_ca\":\"'\/path\/to\/ca\/file'\",\r\n\"db_tls_ca_path\":\"'\/path\/to\/ca\/directory'\",\r\n\"db_tls_cert\":\"'\/path\/to\/client\/cert'\",\r\n\"db_tls_cipher\":\"'AES256-SHA'\",\r\n\"db_tls_key\":\"'\/path\/to\/client\/key'\",\r\n\"db_tls_verify_cert\":\"'0'\",<\/code><\/pre>\n
    <\/div>\n<\/div>\n
    \n
    \n
    The settings that you configure will depend on your server’s configuration.<\/p><\/blockquote>\n<\/div>\n<\/div>\n<\/div>\n
    \n
    Configuration After Installation (CLI or Browser)<\/h2>\n
    \n
    \n
    To enable encrypted MySQL connections after you have completed installation:<\/p>\n
      \n
    1. Open the\u00a0configuration.php<\/code>\u00a0file in your preferred text editor.<\/li>\n
    2. Update the necessary configuration settings, replacing the example values below with your server’s information:<\/li>\n<\/ol>\n<\/div>\n<\/div>\n
      \n
      $db_tls_ca='\/path\/to\/ca\/file';\r\n$db_tls_ca_path='\/path\/to\/ca\/directory';\r\n$db_tls_cert='\/path\/to\/client\/cert';\r\n$db_tls_cipher='AES256-SHA';\r\n$db_tls_key='\/path\/to\/client\/key';\r\n$db_tls_verify_cert='0';<\/code><\/pre>\n
      <\/div>\n<\/div>\n
      \n
      \n
      The settings that you configure will depend on your server’s configuration.<\/p><\/blockquote>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
      How to Enable Encrypted MySQL Connections To use WHMCS with an encrypted MySQL\u00ae connection, you will need to perform additional steps to configure the necessary settings to the configuration.php\u00a0file. We added support for encrypted MySQL connections in WHMCS 8.8. For steps to configure encrypted MySQL connections on cPanel & WHM servers, see\u00a0cPanel’s How to Configure […]<\/p>\n","protected":false},"author":1,"featured_media":10920,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-10919","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-whmcs"],"_links":{"self":[{"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/posts\/10919","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=10919"}],"version-history":[{"count":1,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/posts\/10919\/revisions"}],"predecessor-version":[{"id":10921,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/posts\/10919\/revisions\/10921"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/media\/10920"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=10919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=10919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=10919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}