MySQL - Installation under Windows

April 2017



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

Download MySQL


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

SiteFile
www.mysql.commysql-shareware-win32-X.zip
www.mysql.commyodbc-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.

Installing and first launch


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.

Related


Published by deri58. Latest update on March 29, 2013 at 04:28 AM by deri58.
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).