Windows free install MySQL Green edition configuration

Source: Internet
Author: User

MySQL Green Edition installation

1.

https://dev.mysql.com/downloads/mysql/

  

2. Configuring the My.ini File

Unzip the downloaded file to the specified directory. Such as:

  

My.ini File Contents:

[mysql]default-character-set=utf8[mysqld]basedir=c:\users\venn\mysql-5.7.18-winx64datadir=c:\users\venn\ Mysql-5.7.18-winx64\dataport=3306max_connections=200character-set-server=utf8default-storage-engine=innodb

3. Perform the installation of MySQL

The command line enters the file directory:

Execute mysqld Install command, the following prompt, the installation is successful.

Service sucessfully installed.

Note: If there is

Install/remove of the Service Denied

Please use the administrator to start the command line.

4. Initializing the database

Execute mysqld--initialize

The command does not have an output hint.

   

The new MySQL default does not have the Data folder, can not be manually created, initialization will generate a root password.

The root password is initialized in the Data folder *.err file:

  

5. Start the MySQL service

Execute net start MySQL

  

Note: Starting the MySQL service can be under any path, and the command line must be run as an administrator.

6. Go to MySQL

Execute mysql-u root-p #注: This command can only be executed in the MySQL bin file path.

Enter the password and enter the system.

  

7. Change the root password

Execute set password for [email protected] = password (' 123 ');

  

8. Add an environment variable (optional)

Add "C:\Users\venn\mysql-5.7.18-winx64\bin" to the path to execute the MySQL command in any location.

  

Windows free install MySQL Green edition configuration

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.