Installation of MySQL environment under Window

Source: Internet
Author: User
Tags mysql download

Installation brief for MySQL environment under Window:

MySQL is the most popular relational database management system, and in Web applications MySQL is one of the best RDBMS (relational database Management system: relational databases Management systems) application software.
I chose it for several reasons:

    1. Small size, fast speed
    2. Free, source code open source, cross platform
    3. Large user volume, easy to find solutions to problems
Download:

You can download the required version on their official website, note that some premium version is charged, but for most users, the free version is enough, recommended: MySQL Community Server 5.6, can download the free installation package, decompression after eliminating the installation program.

Installation:
    1. After unpacking the zip package, go to the CMD command line tool under this directory D:\MySQL\mysql-5.6.40-winx64\bin (adjust it yourself according to your installation location)
    2. Install MySQL Service, execute mysqld Install
    3. Log in to MySQL, the first login by default is the root account, there is no password, so you can enter the direct carriage.
      D:\MySQL\mysql-5.6.40-winx64\bin > Mysql-u root-p
    4. Query user password,mysql> select host,user,authentication_string from Mysql.user;
      The password is encrypted, cannot see the plaintext, this is a string of characters, but can see the user name
    5. Set or modify user password,mysql> update mysql.user set Authentication_string=password ("123456") where user= "root";
      Root is the user name and can be changed according to the current user
    6. To modify the root user name:
      mysql> use MySQL;
      mysql> Update user set user= ' xly ' where user= ' root ';
    7. Quit MySQL, mysql> quit
Other:
    1. Environment variables
    2. Generate Data file, mysqld--initialize-insecure--user=mysql Generate Data directory in D:\MySQL\mysql-5.6.40-winx64 directory
Reference Links:

installation, configuration and use of MySQL download under Windows
Windows installation mysql-text

Installation of MySQL environment under Window

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.