{"id":10919,"date":"2025-01-17T07:20:55","date_gmt":"2025-01-17T07:20:55","guid":{"rendered":"https:\/\/www.trustedhosting.in\/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.com\/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…<\/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.com\/blog\/wp-json\/wp\/v2\/posts\/10919","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/comments?post=10919"}],"version-history":[{"count":1,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/10919\/revisions"}],"predecessor-version":[{"id":10921,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/10919\/revisions\/10921"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media\/10920"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media?parent=10919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/categories?post=10919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/tags?post=10919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}