MySQL5.7.10 Install-free version configuration

The latest version of Mysql does not provide a graphical interface to install, download down is a compressed package form, then how can we use it, let it work for us?

Environment: Mysql-5.7.10-winx64 + win7 (64-bit)

One: Download

Download things, it must be to the official website to download, click http://dev.mysql.com/downloads/mysql/Download

Select the corresponding version to download.

This place can be clicked to skip, without landing can be downloaded directly.

Two: Configure environment variables

I used to install the software under D:\Program files, so I unzipped to the D:\Program files directory,

Then go to the D:\Program files\mysql-5.7.10-winx64\bin directory, copy the directory path, configure environment variables (configure user environment variables can also, system environment variables can also), after path followed by;D: \program Files\ Mysql-5.7.10-winx64\bin

( Note that there is a semicolon at the front, which is the requirement for Windows, below the Linux system is the following: For the interval, Windows below is used; to interval, note: Must be in English.)

Then, determine ....., configuration complete.

Three: Edit the MySQL configuration file

Into the MySQL installation directory, under the installation directory there is a My-default.ini file, MySQL will read this file when it starts, we configure this file

Then enter Mysqld--install under the bin directory

This command is to install the service, after the execution, to prompt the success of English, this time you can see in your Windows Services MySQL service.

(Since I have installed the MySQL database, so here the display has started, you must not have "started".)

V: Initialize MySQL

Continue typing at the command prompt: mysqld--initialize--console

This is the initialization database, and then you can see an [email protected] on the last side of the initialization: there is a string of alphanumeric symbols behind it, which is the random password that MySQL automatically generates for you. To write it down, we'll use it when we log in to the MySQL database.

Six: Start the MySQL service

Start the MySQL service and start up before you can use MySQL database.

There are two ways to start MySQL:

Method One: Start with a command

net start MySQL

Method Two: Start from the Windows service

Seven: Modify MySQL default password

After the launch, we log in to the MySQL database and enter the command

Mysql-uroot-p

Enter, ask you to input the password, at this time, the MySQL randomly generated password input, and then enter, landed in.

Once logged in, enter directly:

SET PASSWORD = PASSWORD (' Your new password ');

In mysql-5.7.10, there is no password this column in the user table of the system, and in mysql-5.6.*.

We used mysql-5.6.* to update the root password directly with the UPDATE statement.

This method cannot be used in mysql-5.7.10, we can only use SET PASSWORD = PASSWORD (' Your new password '); To change the password.

After the password has been modified, the MySQL service needs to be restarted before it takes effect.

Eight: Configure SQLyog graphical tools

I prefer to use the SQLyog graphical tool to operate the MySQL database, Navicat is also a good graphical management tool. Personal preference, how to use SQLyog to connect MySQL database? and simple.

Click Http://pan.baidu.com/s/1dEnnvGH to download the SQLyog software with cracked files inside.

Install the software first, do not open after installation, and then run the registry patch, after running, open the software, click New, name casually lose, and then enter the password, click the link on it. (Provided the MySQL service is started).

That should be more detailed. I hope to help you a lot.

MySQL5.7.10 Install-free version configuration