MySQL free install zip under win

MySQL for the win Test simple zip installation to understand the beauty of the my.in configuration file (show variables), the local build MySQL service test engine!

01. Download

Https://dev.mysql.com/downloads/mysql

Mysql-5.6.34-winx64.zip

Http://pan.baidu.com/s/1kVKBJgz Password: 1QCF

02, Decompression:

Mysql-5.6.34-winx64.zip

03. Modification:

My-default.ini--->my.ini

Modify My.ini

basedir    = d:\mysql-5.6.34-winx64        #mysql的家目录datadir    = d:\mysql-5.6.34-winx64\data   #数据存放目录Port       3306server_id  0

04. Admin CMD:

Open C:\windows\system32\cmd.exe as an administrator #右键管理员身份运行

05. Initialize the database:

D: #切换到d盘

CD Mysql-5.6.34-winx64\bin

Mysqld-install #安装mysql服务

NET Start|stop MySQL #启动关闭mysql服务

06. Initialize Root Password

mysqladmin-u Root Password 123123 #初始化root密码

Mysql-uroot-p123123 #登录

Grant All on * * to ' root ' @ '% ' identified by ' 123123 '; #设置任何主机都可以登录数据库

07. Set up MySQL boot automatically:

Open the Service--mysql service---startup mode-automatic

MySQL free install zip under win