MySQL free install zip under win

Source: Internet
Author: User
Tags mysql free

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.