test for mysql interfaces