tried to configure MySQL v2 sensor. got this error: "Authentication with old password no longer supported, use 4.1 style passwords"
MySQL v2 : Authentication with old password no longer supported, use 4.1 style passwords
Modified on 2025-06-10 22:41:11 +0200
Disclaimer:
The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.
The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.
The password used in the connection between client (PRTG sensor) and server is send in a hashed format.
For this to work properly, client and server need to use the same hashing algorithm.
The original hashing algorithm used by MySQL (prior to 4.1) has been deemed to be unsecure. Version 4.1 implements a new hashing algorithm, where the sensor is apparently still using the original hashing algorithm.
The server complains about this by sending the error "Authentication with old password no longer supported, use 4.1 style passwords"
To allow the database to accept the old style hash you can run
SET old_passwords=TRUEDec, 2015 - Permalink