WIN10 install MySQL free install version

Source: Internet
Author: User
Tags mysql client mysql free mysql login

One: Download and unzip

This is not much to say https://dev.mysql.com/downloads/mysql/, simple very

Second: MySQL root directory under new My.ini

[mysql]# set MySQL client default character set Default-character-set=utf8 [mysqld] #设置3306端口port = 3306 # Set the installation directory for MySQL Basedir=c:\program files\mysql-5.7.18-winx64# set the data storage directory for the MySQL database Datadir=c:\program files\mysql-5.7.18-winx64\data# allow the maximum number of connections Max_ The character set used by the connections=200# service side defaults to a 8-bit encoded latin1 character set character-set-server=utf8# the default storage engine that will be used when creating a new table default-storage-engine= INNODB

  

Second: Install the MySQL service and initialize it

Admin mode run PowerShell, and then navigate to the MySQL root directory, run Mysqld-install MySQL MySQL for the service name

Run mysqld--initialize to initialize MySQL, the data folder will be generated automatically, the process is a bit slow, please wait patiently

Where Zoulu.err is named after the machine name, which contains the MySQL initial password

Four: Change Password

Open Zoulu.err (different for everyone), find

2017-06-22t13:33:36.505799z 1 [Note] A temporary password is generated for [email protected]: L (fbz+i-,0>g

Local Host: The following is the initial password.

Run the net start MySQL startup service, or go to the service management interface to start

Run Mysql-u root-p; Then enter the password to login MySQL login MySQL

Run the show databases; test it and you'll be prompted to reset your password

Run alter user ' root ' @ ' localhost ' identified by ' root '; change the password to root, change the other values can also

Then run the show databases;

WIN10 install MySQL free install version

Related Article

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.