The MySQL API stored in the library adamysql uses the client library of MySQL, which means the following linker options have to be passed to gnatmake:
gnatmake .... -largs .. L/usr/lib/mysql -ladamysql -lmysqlclient