MySQL Install

Mysql Installation

• Extract the install archive to the chosen installation location (Say "C:\MyLocation\mysql\MySQL\MySQL Server x.x.xx" ).
• Copy .ini file (say "my-default.ini") from "...\MySQL Server x.x.xx\my-default.ini" to "...\MySQL Server x.x.xx\data\my-default.ini".
• Edit "...\MySQL Server x.x.xx\data\my-default.ini" and type the following lines

basedir =C:\MyLocation\mysql\MySQL\MySQL Server x.x.xx
datadir =C:\MyLocation\mysql\MySQL\MySQL Server x.x.xx\data

• To start the server, enter command:

C:\> "C:\MyLocation\mysql\MySQL\MySQL Server x.x.xx\bin\mysqld" --console

• To start the mysqld server:

C:\> "C:\MyLocation\mysql\MySQL\MySQL Server x.x.xx\bin\mysqld"

• The path to mysqld may vary depending on the install location of MySQL on your system.
• To stop the mysqld server:

C:\> "C:\MyLocation\mysql\MySQL\MySQL Server x.x.xx\bin\mysqladmin" -u root shutdown

• Add/update "Path" variable in "Environment Variables" - "System Variables" - Path with "C:\MyLocation\mysql\MySQL\MySQL Server x.x.xx\bin".
• Stop the server & Install the server as a service using this command:

C:\> "C:\MyLocation\mysql\MySQL\MySQL Server x.x.xx\bin\mysqld" --install