How do I connect my Data Adapter to MySQL databases in MAMP?

[j.t.casperson]

I need a test environment for creating reports on my local machine and I'm unsure which JDBC Driver and Url I should use. I've connected my MySQL Workbench to my databases already and now just need to connect a Jasper studio data adapter to them. I'm on a Mac. 

What I've tried: 

JDBC Driver: I've tried mainly "org.hsqldb.jdbcDriver" and "com.mysql.jdbc.Driver" for no reason other than the fact that they look the most generic to me. 

JDBC Url: I've tried a variety of things, but my two closest attempts I think are "jdbc:mysql://localhost:8889/Applications/MAMP/Library/bin/mysql" and "jdbc:hsqldb:Applications/MAMP/Library/bin/mysql". I think it should map the file path to where the data bases are stored which is Applications/MAMP/Library/bin/mysql. (For example, to view/edit the databases directly I put "/Applications/MAMP/Library/bin/mysql -uroot -p" in the terminal.)

Data Atapter: I've been using a "Database JDBC Connection"

I've been using jaspersoft studio now for almost a month and this is my first question that after several hours I just can't find the answer to. Thanks in advance for answers!