Skip to main content
A
Anonymous
September 24, 2013
Question

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

  • September 24, 2013
  • 1 reply
  • 726 views

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?

    This topic has been closed for replies.

    1 reply

    p_sim
    p_sim
    Participating Frequently
    September 25, 2013

    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.

    A
    Anonymous
    September 25, 2013

    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
    p_sim
    Participating Frequently
    September 25, 2013

    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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices