MySQL - Installing the Test Environment
Installation Overview
How will installation be used? o Testing environment? o Production environment? o What application will be using DB? MySQL as part of a package o XAMPP package: cross-platform, simple to install and use apachefriends.org MySQL standalone: o dev.mysql.com/downloads For MySQL support: o forums.mysql.com o google.com MySQL GUI Tools o dev.mysql.com/downloads/gui-tools/ Text editor not a word processor o Mac: BBEdit or TextWrangler o Win: Notepad++ Command Line Prompt o Mac: Terminal.app included with OS X or iTerm (iterm.sourceforge.net) o Win: cmd.exe included with Windows
Installing in Windows
Download XAMPP and right the installer and run as administrator. Open XAMPP Control Panel Application, start MySql first and then start Apache. Open web browser and type http://localhost/xampp/splash.php Click on Status to check whats running and working, and what isnt working. For mysql, click on control panel, system, and then on Advanced system settings. Open Environment Variables to edit a system variable called path to add c:\xampp\mysql\bin. Click Ok to save the changes. Now you will be able to run mysql in command line prompt.