What is the exact location of MySQL database tables in XAMPP folder?

Your database is in this directory:
C:\xampp\mysql\data

For Mac, your database files are located at:

/Applications/XAMPP/xamppfiles/var/mysql

You might need admin permissions to access or delete your files.

Rather late I know, but you can use SELECT @@datadir to get the information.

Happy file huntin' SO community :)

This is how it looks when ran in phpmyadmin: