- Win32 F/OSS :
- Kool Aid :
- MinGW :
- Editor :
- CVS - Install :
- CVS - Use :
- Assorted Tools :
- Apache Install :
- PHP Install :
- MySQL Install :
- Ada :
- Asm :
- Awk :
- Basic :
- C++ :
- Caml :
- cLisp :
- Cobol :
- D :
- Fortran :
- Eiffel :
- Erlang :
- Haskell :
- Java :
- Javascript :
- Logo :
- Pascal :
- Perl :
- php :
- Prolog :
- Postscript :
- Python :
- Ruby :
- Scheme :
- Smalltalk :
- Tcl/Tk :
win32 F/OSS development - MySQL Install
Next up is MySQL. MySql is a RDBMS that's part of the LAMP bundle. A MySql database can be accessed from any language that supports ODBC. Native APIs also exist for freeBasic, Python, Ruby, Perl, and others.
From the downloads page, click the curent release of the 'MySQL Community Edition'. Grab the 'Windows (x86)' version. Extract the Setup.exe file and run it.
;)
Choose the custom install and install to c:\www\MySQL.
When it's finished, go ahead and run the configuration when prompted.
;)
Select the detailed configuration.
;)
Choose the 'Developer Machine' option...
;)
Make it a multifunction database.
;)
If space or security is an issue, you can move the databases to a different drive. Normally you'll leave them in the default install path.
;)
Since this a developer setup, leave it as OLAP not OLTP
;)
Leave the default port (unless you have a reason to change it...)
;)
Next set your deafult character set.
;)
Here we create the MySQL service, but don't auto start it. We'll also check the box to add the C:/WWW/MySQL/bin/ directory to the PATH...
;)
Lastly, setup the root password. I'm also allowing anonymous access.
;)
To test the install, run the command-line client. From the start menu click on MySQL -> MySQL Server xx -> MySQL Command Line Client
To make life a bit easier, we'll also install phpMyAdmin. This assumes both Apache and Php are installed. Head to the download site and grab the latest version as a zip file. Extract the zip with path (7z x <myZipFileName>) to c:\www\webroot\phpMyAdmin Also create a folder named 'config' in c:\www\webroot\phpMyAdmin\
;)
First you'll need to run the setup script by pointing to http://127.0.0.1/phpMyAdmin/scripts/setup.php.
;)
Click ADD. Add 'localhost' as the server hostname. Define a config user (usually root) and make sure you define a password.
;)
When you're finished copy the file C:\www\webroot\phpMyAdmin\config\config.inc.php to C:\www\webroot\phpMyAdmin\config.inc.php
;)
Test it out by pointing a browser to http://127.0.0.1/phpMyAdmin/
