This new tutorial covers where to get a free mysql database and a free apache/mod perl web server. Along with how to create and add tables to your MySQL database. How to configure the Apache MySQL drivers/wrappers and lastly, a sample perl script to connect to your MySQL database. MySql Tutorial.
Some useful commands when installing a MySQL database on Win2k.
- Install MySQL in the default directory c:/mysql
- Add c:/mysql/bin to the path
- Stop an existing MySQL database Windows Service:
net stop mysql - Remove an existing MySQL service:
mysqld-nt –remove - Shutdown MySQL if it’s running:
mysqladmin -u root shutdown - Test if MySQL is configured properly:
mysqld-nt –console - Again shutdown the MySQL database:
mysqladmin -u root shutdown - Install MySQL as a Windows Service:
mysqld-nt –install - Start the MySQL database Windows Service:
net start mysql - Connect to the MySQL database
mysql
Commands successfully tested with Win2k and [MySQL 4.0]
Here is more excellent documentation on how to access MySQL from C# using the ODBC drivers. 7.5 Can I access MySQL from .NET environment using Connector/ODBC ?
Exploring MySQL in the Microsoft .NET Environment
ByteFX.Data – MySQL Native .NET Providers