MySQL and Cold Fusion

Hi,
All these years I have been using access database with cold fusion with dsn.

Now I m trying to use MYSQL instead of Access.

I need to know how I would start? I already created a table.

So for example to display records from access I used to do write the following query.

<CFQUERY DATASOURCE="dsn" NAME="getinfo" >
SELECT * FROM non_music where id = 122
</CFQUERY>

<cfoutput query="getinfo">

#vdo_code#
</cfoutput>

--Now how would I do the same if I m using MYSQL instead of Access?

Thanks