Win7-64bit under Installation mysql-5.7.16

# # # Long time did not install MySQL in Windows Download, today just use, simply record the installation process to keep watch.

(1) Download:mysql-5.7.16-winx64.zip

(2) extract to:D:\ProgramFiles\mysql-5.7.16

(3) Configuring environment variables in Path:D:\ProgramFiles\mysql-5.7.16\bin

(4) Simple configuration:D:\ProgramFiles\mysql-5.7.16\my.ini # Add the following:

[Client]

Default-character-set=utf8

[Mysqld]

Character-set-server= UTF8

Basedir = D:\ProgramFiles\mysql-5.7.16

DataDir = D:\ProgramFiles\mysql-5.7.16\data

(5) initializing MySQL

# # # Run command prompt as Administrator

>CD D:\ProgramFiles\mysql-5.7.16\bin

>mysqld--initialize-insecure--user=mysql # self-built data file and create default database

>mysqldinstall mysql--defaults-file= "D:\ProgramFiles\mysql-5.7.16\my.ini"

# Register MySQL as a Windows system service, if removed using:mysqld Remove

Servicesuccessfully installed.

>net start MySQL # turn on mysql >net stop MySQL # close MySQL

The MySQL service is starting .

The MySQL service has started successfully.

>mysql-uroot

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| Information_schema |

| MySQL |

| Performance_schema |

| SYS |

+--------------------+

4 rows in Set (0.02 sec)

mysql> use MySQL # to change the root password

mysql> UPDATE user SET Authentication_string=password (' Jiubugaoshuni ') WHERE user= ' root ';

mysql> FLUSH privileges;

# # # test environment, no specific configuration optimization, just simple installation. Note: Install MySQL as a Windows system service here by default is self-booting, afraid to boot slow classmate can be modified to manually start.

This article is from the "Old Wafangdian" blog, please be sure to keep this source http://laowafang.blog.51cto.com/251518/1869435

Win7-64bit under Installation mysql-5.7.16