I posted this in a thread and several people liked it, so I thought I would put it here in the resources. Maybe there's others that do no know how. I have over 30 CD's "RIPPED" to the flash drive that's in my console. I would recommend getting a USB extension so it lays flat in the bottom of your console. Also, I understand the newer vehicles have 2-ports, one is dedicated for Apple/Android car play, the other is for your media device.
Link on Mazda 24/7
RIP CDs to Flash Drive from Media Player
Link on Mazda 24/7
RIP CDs to Flash Drive from Media Player