MySQL5.7.10 installation-free configuration and mysql5.7.10 installation-free Configuration

MySQL5.7.10 installation-free configuration and mysql5.7.10 installation-free Configuration

The latest version of Mysql does not provide graphic interface installation. the download is a compressed package. How can we use it and let it work for us?

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

 

I. Download

Download something, definitely go to the official website to download, click Download http://dev.mysql.com/downloads/mysql/

Select a version for download.

You can click to skip this step. You can directly download it without logging in.

 

Ii. Configure Environment Variables

I used to install the software under D: \ Program Files, So I decompress it to the D: \ Program Files directory,

Then enter the D: \ Program Files \ mysql-5.7.10-winx64 \ bin directory, copy the directory path, configure the environment variables (configure user environment variables can also, the system environment variables can also ), append the PATH; D: \ Program Files \ mysql-5.7.10-winx64 \ bin

(Note: the front side has a semicolon. This is a requirement for windows. in Linux, there is an interval, which is used for windows. Note: it must be in English .)

Then, confirm..., and the configuration is complete.

 

3. Edit the MySQL configuration file

Go to the installation directory of MySQL, there is a my-default.ini file under the installation directory, MySQL will read this file at startup, we configure this file

Enter mysqld -- install under the bin directory

This command is used to install the service. After the command is executed, the prompt is displayed in English. At this time, you can see the MySQL service in your windows service.

(Because I have installed the MySQL database, it is displayed that it has been started. You must have not "started ".)

 

V. initialize MySQL

Enter mysqld -- initialize -- console in the command prompt.

This is the initialization database, and you can see at the end of the initialization there is a root @ localhost: followed by a series of alphanumeric symbols, This is the random password automatically generated by MySQL for you. remember, we will use it later when logging on to the MySQL database.

 

6. Start the MySQL Service

Start the MySQL service before you can use the MySQL database.

There are two ways to start MySQL:

Method 1: Start with a command

Net start mysql

Method 2: Start windows Services

 

7. Modify the default MySQL password

After starting, log on to the MySQL database and enter the command

Mysql-uroot-p

Press enter to enter the password. Then, enter the password randomly generated by MySQL, and press enter to log in.

After logging in, enter:

Set password = PASSWORD ('your new password ');

In the mysql-5.7.10, the system's user table does not have the password column, and there is.

We used to update the root password directly with the update statement when using mysql-5.6.

This method can't be used in the mysql-5.7.10, we can only use set password = PASSWORD ('your new password'); to change the PASSWORD.

After the password is changed, the MySQL service must be restarted to take effect.

 

8. Configure the SQLyog graphical Tool

I prefer to use SQLyog graphical tools to operate MySQL databases. Navicat is also a good graphical management tool. How can I use SQLyog to connect to MySQL databases? Easy to use.

Click the http://pan.baidu.com/s/1dEnnvGH to download SQLyog software, which contains the cracked file.

Install the software first, do not open it after installation, and then run the Registry patch. After running, open the software, click New, enter the name, enter the password, and click the link. (The premise is that the MySQL service is started ).

I hope it will be helpful to you.