How Do I Disable SSL for a Database?_Database Security Service_Huawei Cloud (2024)

Updated on 2023-12-27 GMT+08:00

View PDF

If SSL is enabled for a database, the database cannot be audited. To use database audit, disable SSL first.

The MySQL database client is used as an example. Perform the following steps:

1. Log in to the MySQL database client as user root.
2. Run the following command to check the connection mode of the MySQL database:

   \s

   • If information similar to the following is displayed, SSL has been disabled for the MySQL database.

     1	SSL: Not in use

     See Also

     How to Fix the “SSL Handshake Failed” and "Cloudflare 525" Error (5 Methods)SupportSteps to disable SSLv3 protocol (POODLE VULNERABILITY) on Appservers that are supported by Identity ManagerQualys Discussions
   • If information similar to the following is displayed, SSL has been enabled for the MySQL database. Go to 3.

     1	SSL: Cipher in use is XXX-XXX-XXXXXX-XXX

3. Log in to the MySQL database in SSL mode.
   1. Run the following command to exit from the MySQL database:

      exit

   2. Log in to the MySQL database as user root.

      Add the following parameters at the end of the login command:

      --ssl-mode=DISABLED

      Or

      --ssl=0

      

      If you logged in to the MySQL database in SSL mode, you can disable SSL only for this login. To use the database audit function, log in to the MySQL database as instructed in this step.

   3. Run the following command to check the connection mode of the MySQL database:

      \s

      If information similar to the following is displayed, SSL has been disabled for the MySQL database.

      See Also

      Apache - Disable SSL 2.0, SSL 3.0 and opt fore a modern safe SSL…

      1	SSL: Not in use

Previous topic: Operations

Next topic: How Do I Set Database Audit Rules for All Databases?

Feedback