Mysql 5.7.11 winx64.zipan Assembly placement tutorial, 5.7.11winx64.zip

Mysql 5.7.11 winx64.zipan Assembly placement tutorial, 5.7.11winx64.zip

Install and configure the MySql database system.

1. Download

http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.11-winx64.zip

2. decompress the zip package

D:\Program Files\mysql-5.7.11-winx64 

3. Configure Environment Variables

3.1 add path,

D:\Program Files\mysql-5.7.11-winx64\bin

3. 2. Modify the mysql-default.ini configuration file,

Original

# These are commonly set, remove the # and set as required.# basedir = .....# datadir = .....# port = .....# server_id = .....

Change

# These are commonly set, remove the # and set as required. basedir = D:\Program Files\mysql-5.7.11-winx64 datadir = D:\Program Files\mysql-5.7.11-winx64\Data port = 3306# server_id = .....

4. Enter the command prompt cmd as an administrator

Go to the bin directory of mysql,

Microsoft Windows [version 6.3.9600] (c) 2013 Microsoft Corporation. All rights reserved. C: \ Users \ Administrator> cd D: \ Program Files \ mysql-5.7.11-winx64 \ binC: \ Users \ Administrator> d: D: \ Program Files \ mysql-5.7.11-winx64 \ bin>

Execute the mysqld.exe -- initialize command,

D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe --initializeD:\Program Files\mysql-5.7.11-winx64\bin>

Data DIRECTORY created

5. Execute the mysqld-install command

D: \ Program Files \ mysql-5.7.11-winx64 \ bin> mysqld-installService successfully installed. // successfully install the service

6.execute mysqld.exe-nt -- skip-grant-tables

Note: The Window does not respond.

Microsoft Windows [version 6.3.9600] (c) 2013 Microsoft Corporation. All rights reserved. C: \ Users \ Administrator> cd D: \ Program Files \ mysql-5.7.11-winx64 \ binC: \ Users \ Administrator> d: D: \ Program Files \ mysql-5.7.11-winx64 \ bin> mysqld.exe -- initializeD: \ Program Files \ mysql-5.7.11-winx64 \ bin> mysqld-installService successfully installed. // service installed successfully D: \ Program Files \ mysql-5.7.11-winx64 \ bin> mysqld.exe-nt -- skip-grant-tables

7. Open the dos window again and run mysql-u root.

Go to the mysql command line and run the command use mysql; update user set authtication_string = Password ('000000') where user = "root"; set password = Password ('20140901 ');

Press Ctrl + C to copy the code

Microsoft Windows [version 6.3.9600] (c) 2013 Microsoft Corporation. All rights reserved. C: \ Users \ Administrator> mysqld.exe-nt -- skip-grant-tablesC: \ Users \ Administrator> mysql-u rootWelcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 3 Server version: 5.7.11 MySQL Community Server (GPL) Copyright (c) 2000,201 6, Oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. other names may be trademarks of their respectiveowners. type 'help; 'or' \ H' for help. type '\ C' to clear the current input statement. mysql> use mysqlDatabase changedmysql> update user set authtication_string = Password ('000000') where user = "root"-> set password = Password ('000000')->

Press Ctrl + C to copy the code

8. Terminate the mysqld process in the task manager and enable the mysql service.

Installation is complete.

Highlights: mysql installation tutorials for different versions mysql5.7 installation tutorials for various versions mysql5.6 installation tutorials

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.