As a rule, it is not possible to install two versions of the same package. Usually this leads to unsolvable file conflicts, although there are rare cases where you can have several versions of a package without conflicts (for example, the kernel package).
You can create a “fake” package that satisfies the missing dependency, although this means that something on your system is fundamentally broken (as a rule, someone installed something that was not really intended for use in the particular distribution you are using) . You will need to create a specification file with the Provides: line corresponding to your dependency, line by line:
Provides: mysql = 5.5.22
I once wrote a tool called fakeprovide that helps with such things ... if nothing else it can provide you with a template specification file for working with.
You can also grab the source RPM for collectd and rebuild it for compatibility with the version of MySQL installed on your system.
source share