Install MySQL under Windows

This article is mainly about MySQL decompression version under Windows installation and configuration, on the official website http://www.mysql.com/ download Mysql-cluster-gpl-7.3.7-winx64.zip, and then extract MySQL to any path, such as: D:\ mysql-cluster-gpl-7.3.7-winx64.

Open computer, properties, advanced system settings, environment variables, add your MySQL root directory after the path variable (note is not overwritten), such as:;D: \ mysql-cluster-gpl-7.3.7-winx64\bin.

Then create a new My.ini under the root directory. Add the following content:

 [mysql]# set MySQL client default character set  default - Character-set  =utf8 [mysqld] #设置3306端口port  = 3306   # Set the installation directory for MySQL basedir  =d:\ Mysql-cluster-gpl-7.3 . 7 -winx64# set the data storage directory for the MySQL database datadir  =d : \mysql-cluster-gpl-7.3 . 7 -200  # server defaults to a 8-bit encoded latin1 character set character -set -server=utf8# the default storage engine that will be used when creating a new table  default -storage-engine=innodb 

Open a command prompt, enter the D:\mysql-cluster-gpl-7.3.7-winx64/bin directory, and execute the command: Mysqld-install install MySQL to the Windows service. After successful execution, service successfully installed will be prompted.

Uninstall Service execution command: Mysqld-remove.

Then execute it at the command prompt: net start MySQL will start MySQL.

You want to stop the Service input command: net stop MySQL.

If you want to set MySQL to start automatically, you can set it up in the Start menu, run, enter Service.msc to open service management.

Login time Input: Mysql-u root–p, have not set a password directly press ENTER.

In order to secure, enter the first to set the password, there are many ways to set the password, here is a: set password =password (' Your password '), here are 123456 for example.

The password will be used the next time you log on.

Quit MySQL, use the command quit, or exit;.

Install MySQL under Windows