What is best method for learning how to use mySQL with Coldfusion?

[Guest]

I have been using access databases for years with Coldfusion. I have a client that wants me to build an online classroom. I figure it's time to finally start using mySQL, but there is so much info out there, I don't know which way to turn.

Where do you experts recommend I get started?

Also, I am using coldfusion entrprise on my system at home. My machine is a 64-bit, 3.30Ghz AMD FX - 6100 six-core processor with 8gig of ram. Can I install mySQL on the machine and run CF8 without any problems?

[p_sim]

How much RAM left on your system? If the computer is strictly for development, then you have more than enough to run ColdFusion, MySQL, browsers, and other development tools.

For MySQL download the MySQL Community Server and MySQL Workbench. There is also all-in-one package for Windows, http://dev.mysql.com/downloads/windows/installer/ that you don't need to download the server and workbench separately. The installation should be straight forward.

By the way, other CF users may suggest you to use MariaDB (https://mariadb.org/), which is a branch of MySQL.

[Guest]

I just installed the MySQL Community Server all-in-one package for Windows. SInce this is a new machine, I just installed CF8 as well. Now starts the fun. How do I create a database with mySQL and set its permissions so I can access it in CF? I am trying to find tutorials online, but most of the tutorials are for their specific platforms. Any suggestions?

[p_sim]

There is a UI for creating and administering MySQL. You might want to adventure yourself. Perhaps, YouTube has some videos how to do it.

For setting up database permissions, you might need a bit more knowledge about the database itself because permissions can be very specific. For example, you can assign read only to a table, but not delete any records. Another one, create a special user that can only access a specified database.