Free installation MySQL installation and configuration

1: Download the free install version on MySQL website

http://downloads.mysql.com/archives/community/

Download link

Http://downloads.mysql.com/archives/get/file/mysql-noinstall-5.1.72-winx64.zip

2: Unzip to local directory E:\ProgramFiles\mysql-noinstall-5.1.72-winx64

Create a new log folder under this directory, E:\ProgramFiles\mysql-noinstall-5.1.72-winx64\log;

Create a new My.ini file in the E:\ProgramFiles\mysql-noinstall-5.1.72-winx64 directory, write the following (encoded format dos\windows--->ansi):

5.1.72 version Note the commented out content #innodb-strict-mode = 1, otherwise the creation of the service will error:

160328 19:57:23 innodb:started; Log sequence number 0 44233
160328 19:57:23 [ERROR] e:\programfiles\mysql-noinstall-5.1.72-winx64\bin\mysqld:unknown variable ' Innodb-strict-mode=1 '

[mysql]# CLIENT #port = 3306socket = e:/programfiles/mysql-noinstall-5.1.72-winx64/mysql.sock[mysqld]# General #user = Rootdefault-storage-engine = Innodbsocket = E:/programfiles/mysql-noinstall-5.1.72-winx64/mysql.sockpid-file = E:/ programfiles/mysql-noinstall-5.1.72-winx64/mysql.pid# MyISAM #key-buffer-size = 32mmyisam-recover = FORCE,BACKUP# SAFETY #max-allowed-packet = 16mmax-connect-errors = 1000000skip-name-resolvesql-mode = Strict_trans_tables,error_for _division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_ Date,only_full_group_byinnodb = Force#innodb-strict-mode = # DATA STORAGE #basedir = e:/programfiles/ Mysql-noinstall-5.1.72-winx64datadir = e:/programfiles/mysql-noinstall-5.1.72-winx64/data# BINARY LOGGING #log-bin = E:/programfiles/mysql-noinstall-5.1.72-winx64/mysql-binexpire-logs-days = 14sync-binlog = # CACHES and LIMITS # Tmp-table-size = 32mmax-heap-table-size = 32mquery-cache-type = 0query-cache-size = 0max-connectioNS = 500thread-cache-size = 50open-files-limit = 65535table-definition-cache = 1024table-open-cache = 2048# INNODB #innodb -log-files-in-group = 2innodb-log-file-size = 128minnodb-flush-log-at-trx-commit = 1innodb-file-per-table = 1innodb-buffer-pool-size = 3g# LOGGING #log-error = e:/programfiles/mysql-noinstall-5.1.72-winx64/log/ mysql-error.loglog-queries-not-using-indexes = 1slow-query-log = 1slow-query-log-file = E:/ProgramFiles/ Mysql-noinstall-5.1.72-winx64/log/mysql-slow.log

3: Open the cmd command line as an administrator, enter the following in turn, and return each time the input is complete:

First time:CD E:/programfiles/mysql-noinstall-5.1.72-winx64/bin

Second time: E:
Third time: mysqld install MySQL--defaults-file= "E:/programfiles/mysql-noinstall-5.1.72-winx64/my.ini"
Fourth time: net start MySQL

Fifth time: Mysql–uroot
Sixth time:mysql> show databases;

Seventh time: Mysql>use MySQL;
Eighth time: Mysql>update user set password= "123456" where user= ' root ';

Nineth Time:mysql>exit;

Tenth time: Mysql–u Root

11th Time: Mysql>grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT option;

12th time:mysql> use MySQL;
13th time:mysql> Select User,host,password from Mysql.user;

14th time: Mysql>flush privileges;

15th Time:mysql>quit;

4: Connect MySQL database with Navicat Premium

Download the software and install it, right-click to connect--->mysql---> Fill in the Properties---> Connect test pass, OK save.

Free installation MySQL installation and configuration