There is an post on it here:
But a short answer is download the jar connector file from here:
https://dev.mysql.com/downloads/connector/j/
Add it to the Neo4j dbmss-*****/plugins directory. Restart database.
Run this to list all tables in the database dbname:
call apoc.load.jdbc("jdbc:mysql://localhost:3306/dbname?user=dbuser&password=dbpassword",
"SELECT table_name,TABLE_ROWS
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'dbname'")
yield row
with row,toInteger(row.TABLE_ROWS) as antal
where antal>0
return row