I don’t monitor KDE Discuss that actively, but happened to note this thread.
As a general “try-building-again”, the message
contains something you could probably try.
Amarok/Development/Compiling - KDE Community Wiki is probably the most up-to-date resource on building
Also, can you check initial cmake output and confirm if
* MySQL, MySQL Client Library (libmysqlclient), <https://www.mysql.com>
and/or
* MySQLe, MySQL Embedded Library (libmysqld), <https://www.mysql.com>
are listed as found or not found. You probably will want a MySQLe database ( = mariadb embedded), the package name varies somewhat, but generally something called libmariadbd-devel is required for that