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)