Is it possible to have both mySQL and ODBC on the same machine simoltaneously? Not necessarily running at the same time, but having them both installed, so I can switch back and forth. The company I work for uses Access but I want to get some mySQL experience.
So if I install mySQL on my computer with ODBC already in place, will everything still function with no problems? Is there anything special I have to do?
Are you trying to connect to two different DB's from the same script? If you are, make sure you use an identifier for your $link parameter in your database connection functions. I have done this on my local development server, connecting to MySQL, Access and SQL Server all in the same script.
That's cool to know that that's possible, but that's not what I need to do. I just want to teach myself how to use mySQL without messing up the existing Access stuff. I downloaded and installed mySQL, but I don't really know what to do now.
Oh, so you're asking if the databases can be on the same server without causing any conflicts. I get it! Amazing how fast I can complicate something.
To answer your question appropriately, yes, you can have MySQL, Access, SQL Server, PostgreSQL, yada yada, all on the same machine withour porking your system. I have MySQL, Access and SQL Server Express on my development machine right now and there are no conflicts.