Shulou(Shulou.com)06/01 Report--

MYSQL 5.6has different features from previous versions. The default password of root installed for the first time is not empty, but randomly generated. The specific process is as follows

1. Download this version.

We chose to download Windows (x86, 64-bit), ZIP Archive.

two。 After downloading, unzip it, get a folder mysql-5.7.14-winx64, copy this folder to CJV, and rename it mysql. We will find that there is no data subdirectory in this directory.

3. Configure environment variables. My computer-> Properties-> Advanced-> Environment variables

Select PATH and add after it: the path to your mysql bin folder (e.g. C:\ mysql\ bin) PATH=.;C:\ mysql\ bin (note that it is appended, not overwritten)

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 (directory where mysql resides)

Datadir=C:\ mysql\ data (directory where mysql resides\ data)

5. Run cmd as an administrator (be sure to run as an administrator, otherwise there are not enough privileges)

Enter: cd C:\ mysql\ bin to enter the bin folder of mysql (no matter whether you have configured the environment variable or not, enter the bin folder, otherwise you will still report error 2 after starting the service)

Enter mysqld-install (if you do not run as an administrator, there will be an error due to insufficient permissions: Install/Remove of the Service Denied!)

Service successfully installed installed successfully

6. Initialize mysql

Run the command mysqld-- initialize, which is why we found an extra data directory under the mysql directory

7. Start the mysql service net start mysql

The mysql service is starting.

The mysql service has started successfully

8. Log in to mysql

Enter mysql-uroot-p.

At this time, the root user needs a password. The password is in a file with an err suffix under the mysql\ data directory. For example, my own file is kingsun-pc.err. When we open this file, we find that its password is

2016-09-02T17:27:35.666902Z 1 [Note] A temporary password is generated for root@localhost: FauCC CYuse mysql

Mysql > UPDATE user SET password=PASSWORD ("123456") WHERE user= "root'

Mysql > FLUSH PRIVILEGES

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.