installing MySQL 5.6

MYSQL 5.6 is different from the previous version of the features, the first installation of the root of the default password is not empty, but randomly generated, the specific process is as follows

1. Download the version.

We chose to download this version of Windows (x86, 64-bit), ZIP archive.

2. After downloading, unzip, get a folder mysql-5.7.14-winx64, copy this folder to C:, and rename MySQL. We will find that this directory does not have a subdirectory of data.

3. Configure the environment variables. My Computer, properties, advanced environment variables

Select path and add the following: The path to your MySQL bin folder (e.g. C:\mysql\bin) path= ...; C:\mysql\bin (note is append, not overwrite)

4. Copy My-default.ini in the MySQL directory and rename it to My.ini. Modify the My.ini as follows:

[Mysqld]

Basedir=c:\mysql (MySQL directory)

Datadir=c:\mysql\data (MySQL directory \data)

5. Run cmd as administrator (be sure to run as administrator, or not have enough permissions),

Input: cd C:\mysql\bin into the MySQL Bin folder (regardless of whether the environment variable has been configured, also to enter the Bin folder, or after the start of the service will still report error 2)

Enter Mysqld-install (if run without administrator, there will be an error due to insufficient permissions: Install/remove of the Service denied!)

Installation successful Service successfully installed

6. Initialize MySQL

Run the command mysqld--initialize, which is what we found in the MySQL directory with a more data directory

7. Start MySQL service net start MySQL

The MySQL service is starting.

MySQL Service has started successfully

8. Log in to MySQL

Mysql-uroot-p Enter.

At this time the root user needs a password, the password in the Mysql\data directory under the Err suffix file inside, such as my own file is Kingsun-pc.err, open this file, we found its password is

2016-09-02t17:27:35.666902z 1 [Note] A temporary password is generated for [email protected]: FAUCC!CY<6KD

9. Use this password to log in to change this password immediately to operate.

Use this statement to change the password to hfhe2000

ALTER USER ' root ' @ ' localhost ' identified by ' hfhe2000 ';

======

In addition, if you use the method mysqld--initialize-insecure, then the root user's password is empty,

You also need to change your password after logging in

Mysql>use MySQL;

Mysql>update user SET Password=password ("123456") WHERE user= "root";

Mysql>flush privileges;

This article is from the "Epicor, Magento" blog, so be sure to keep this source http://3154408.blog.51cto.com/3144408/1969437

installing MySQL 5.6