This document summarizes the FAQs related to high reliability of TiDB.
Does TiDB support modifying the MySQL version string of the server to a specific one that is required by the security vulnerability scanning tool?
Since v3.0.8, TiDB supports modifying the version string of the server by modifying
server-version in the configuration file. When you deploy TiDB using TiUP, you can also specify the proper version string by executing
tiup cluster edit-config <cluster-name>:
server_configs: tidb: server-version: 'YOUR_VERSION_STRING'
tiup cluster reload <cluster-name> -R tidb command to make the modification above take effect to avoid the failure of security vulnerability scan.
Like MySQL, TiDB supports the SASL protocol for user login authentication and password processing.
When the client connects to TiDB, the challenge-response authentication mode starts. The process is as follows:
- The client connects to the server.
- The server sends a random string challenge to the client.
- The client sends the username and response to the server.
- The server verifies the response.
To modify the user password in TiDB, it is recommended to use
set password for 'root'@'%' = '0101001'; or
update mysql.user which might lead to the condition that the password in other nodes is not refreshed timely.
It is recommended to use the official standard statements when modifying the user password and privilege. For details, see TiDB user account management.