Mysql-5.7.11-winx64.zip Download, install, configure and use (installed in Windows)

　

Want to say is, have MySQL certain basic personnel, learn big data of hive, HBase is more valuable!

First, download

    Http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.11-winx64.zip

　
     

Second, installation

1. Unzip the ZIP package

　

Here to say is, we all know, about the installation of software, there are two kinds of MSI way and compressed package decompression installation.

About the installation of MSI, I will not repeat here, see

Http://jingyan.baidu.com/article/7e440953d6f0702fc1e2ef61.html

Compression Package Decompression Method Installation:

Then, in this step there is information that modifies the default configuration file My-default.ini. Here, I do. In general, for professional specifications, the default My-default.ini modification is named My.ini (which is modeled after the Hadoop/spark) in the configuration file to try.

2. Become

# for advice The change settings

# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

# * * * Don't EDIT this FILE. It ' s a template which'll be copied to the

# * * * default location during install, and would be replaced if you

# * * * * Upgrade to a newer version of MySQL.

[Mysqld]

# Remove Leading # and set to the amount of RAM for the most important data

# Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove Leading # to turn on a very important data integrity option:logging

# Changes to the binary log between backups.

# Log_bin

# These is commonly set, remove the # and set as required.

# Basedir = ...

# DataDir = ...

# port = .....

# server_id = ...

# Remove Leading # To set options mainly useful for reporting servers.

# The server defaults is faster for transactions and fast selects.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

Sql_mode=no_engine_substitution,strict_trans_tables

3, make the following changes

# for advice The change settings
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# * * * Don't EDIT this FILE. It ' s a template which'll be copied to the
# * * * default location during install, and would be replaced if you
# * * * * Upgrade to a newer version of MySQL.

[Mysqld]

# Remove Leading # and set to the amount of RAM for the most important data
# Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove Leading # to turn on a very important data integrity option:logging
# Changes to the binary log between backups.
# Log_bin

# These is commonly set, remove the # and set as required.
Basedir = D:\SoftWare\MySQL\mysql-5.7.11-winx64
DataDir = D:\SoftWare\MySQL\mysql-5.7.11-winx64\Data
Port = 3306
# server_id = ...

# Remove Leading # To set options mainly useful for reporting servers.
# The server defaults is faster for transactions and fast selects.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

Sql_mode=no_engine_substitution,strict_trans_tables

4. Configure Environment variables

New, Mysql_home,

In Windows path, add the following

;%mysql_home\bin; (Note plus semicolon)

5. Register MySQL as Windows system service, that is, initialize MySQL

To do this, execute the following command on the command line (you need to run the command line as an administrator):

The following commands are performed on the DOS command line

Need to switch to the bin directory of the MYSQ installation,

Otherwise, the service directory is specified as C:\Program files\mysql\mysql Server 5.7\mysqld

Here, by the way, learn some of the common commands in DOS windows!

Run as an administrator,

c:\users\administrator>cd/d d:\

d:\>CD D:\SoftWare\MySQL\mysql-5.7.11-winx64

d:\software\mysql\mysql-5.7.11-winx64>CD Bin

D:\software\mysql\mysql-5.7.11-winx64\bin>

6. Create your own new data directory

7, the execution of Mysqld.exe--initialize command,

d:\software\mysql\mysql-5.7.11-winx64\bin>mysqld--initialize

Enter

　　

　　　　

8. Execute Mysqld-install command

D:\SoftWare\MySQL\mysql-5.7.11-winx64\bin > mysqld Install

Or

D:\SoftWare\MySQL\mysql-5.7.11-winx64\bin >

mysqld Install MySQL--defaults-file=

"D:\SoftWare\MySQL\mysql-5.7.11-winx64\bin\my.ini"

　　　

Or

Displays the service successfully installed. Indicates that the initialization was successful!

9, the implementation of Mysqld.exe-nt--skip-grant-tables

Note: The window does not respond

10. Reopen the DOS window and execute mysql-u root

11. Execute Mysql-u Root

mysql> use mysql

Database changed

mysql> Update user set Authtication_string=password (' Rootroot ') where user= "root"

set Password=password (' Rootroot ')

-

12. Terminate the mysqld process in the Task Manager,

　

13. Turn on the MySQL service.

d:\software\mysql\mysql-5.7.11-winx64\bin> net start MySQL

Installation is complete.

Iv. Use of

Later, every time, is to the bin

Thanks for the following link blogger:

　　Http://www.cnblogs.com/endv/p/5205435.html

Summarize:

For Windows installed MySQL, there will be a variety of problems, in this, I also on this basis, has been recognized and promoted!!!

Problem:

Workaround 1:

Mysqld–remove MySQL

Turn "Finally know why my MySQL is always uninstalled dirty and always can't find the My.ini file

Http://blog.sina.com.cn/s/blog_6fc5bfa90100qmr9.html

Http://www.cnblogs.com/zlslch/p/5862100.html

Mysql-5.7.11-winx64.zip Download, install, configure and use (installed in Windows)