MySQL5.5.42 Install-free configuration (log)

configuration for MySQL under Windows

For example, download Windows (x86, 32-bit), ZIP Archive (official download page: http://dev.mysql.com/downloads/mysql/5.1.html#) with the MySQL 5.5 free install version Downloads)

Configuration steps:

1. Unzip the downloaded mysql-5.5.42-win32.zip such as: mine is extracted to the root directory of the D drive

2. Locate the My-small.ini configuration file under the installation folder, rename it to My.ini, open for editing, and add a line under [client] and [mysqld]: default-character-set = utf8

3. Open the Windows environment variable setting, create a new variable name mysql_home, the variable value is MYSQL extract directory path, here is D:\mysql-5.5.42-win32

4. Add the Path variable to the environment variable ;%mysql_home%\bin;

5. Install the MySQL service, open the Windows command prompt, execute the command: mysqld--install mysql--defaults-file= "D:\mysql-5.5.42-win32\my.ini"

(Note that the path must be the full path, responsible for starting MySQL will be reported 1053 error, in the online waste a great effort, just try to find a solution)

Tip "Service successfully installed." Indicate success;

Start, stop, and uninstall of MySQL service

Run at the Windows command prompt:

Startup: net start MySQL

STOP: net stop MySQL

Uninstall: SC Delete MySQL

MySQL5.5.42 Install-free configuration (log)