A few words of thanks would be greatly appreciated.

MySQL - Installation under Windows

Since version 3.23.19, MySQL is licensed under GPL (both under Linux and Windows), which means it can be used for free.

MySQL for Windows is available for free download on MySQL.com.

Site File
www.mysql.com mysql-shareware-win32-X.zip
www.mysql.com myodbc-X_X_X-win95.zip (pour Windows 95)

The second file is only needed for Windows 95. It will allow you to install the ODBC drivers (.dll files) for MySQL.
The installation is not complicated, just read the onscreen instructions
Once installed, launch MySQL is from a MS-DOS window:

  • mysqld (or mysqld-opt) or
  • mysql-shareware (depending on your version).

--language=french allows, for example, to have the MySQL messages in French.
--skip-grant-tables prevent the use the MySQL privileges.
--skip-name-resolve to never resolve hostnames.
--port=3306 to specify the port number.
Here is an example command line to start MySQL:
c:\mysql\bin\mysqld-opt --skip-name-resolve --skip-grant-tables
--language=french --port=3306

To close MySQL:
C:\mysql\bin\mysqladmin -u root shutdown
It may be practical to create two batch files (.bat extension) in the MySQL bin directory to run the above commands.
E.g cmysql.bat and fmysql.bat

Original document published on CommentcaMarche.net.


A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « MySQL - Installation under Windows », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).