MySQL 5.7.14 download installation, configuration and use detailed tutorials _mysql

Download

A. I'm using the ZIP archive version, and WIN8 64-bit machines support this, so I suggest using this. And this is relatively simple and clean. The address is shown in the picture. Drag to the bottom, see clearly 64bit ZIP Archive, click Download.

B. After the opening will enter another page, but there is no download, this time do not be afraid, do not understand it does not matter, he means that you login (login), or register an account (sign up) on the line, login or register successfully after the download began. (Remember the password to combine letters and numbers, and to mix the case)

C. Of course, if you have, you can also log in directly.

Click Downnow after success. The file is not big, more than 300 m, will be in a moment to the following place, but if not found words will be back out, just the operation to go again.

Similarly, if you want to download the Linux platform under the MySQL is also found here;

Download complete, the following will be installed and configured.

The methods and steps are as follows:

The ZIP archive version is free of installation. Just unzip it on the line. It's no different from the installation version, but it doesn't need to be installed. Find the Download Mysql-5.7.10-winx64.zip right button Select (Extract to ...) ) and put it where you want to install it. Like to put the C-plate on the choice of C, do not like to choose their own is, I personally like to put in the F disk. After all, C disk is a system disk is not too much to put too many things. Decompression is OK, is not very simple AH.

Are you going to ask? How do you use it? How does the Mysql.exe in the bin point come out and a black window doesn't respond?

No response because the service has not yet opened!

Configure Default Files

In fact, we can install the service directly now, but because it is the default configuration, we will have a lot of problems when we use it. For example, the Chinese characters are all garbled and so on, so I suggest you configure the default file first. In the mysql-5.7.10-winx64 directory, create a new My.ini. Copy the following code to save it. My.ini will replace the following My-default.ini file. The INI file is the configuration file inside the window. Save the various default data inside. The installation version of the installation is to let you choose and then the system to save you in, Zip Archieve is their own write, are the same. What is the meaning of the code inside? Children's shoes are going to check their own data. I am the one who asks the talented person to know the point. I can't say a word in two sentences here.

[MySQL]
; Set the MySQL client default character set
Default-character-set=utf8
[mysqld]
; set 3306 port
= 3306 
; set MySQL installation directory
Basedir=f:\mysql-5.7.10-winx64
set up the data storage directory of MySQL database
datadir=f:\mysql-5.7.10-winx64\data
; Allow maximum number of connections
max_connections=200
; The character set used by the service side defaults to the 8-bit encoded latin1 character set
Character-set-server=utf8
; The default storage engine to use when creating new tables
default-storage-engine= INNODB

Install MySQL Service

A. Right-click Start button Select Search input cmd, there will be a command prompt right to choose to run this option as an administrator, or there will be a lack of identity error code, which is a feature of the Windows system to know on the line. If My.ini write wrong, the error code is 1067.

1.2 Open the CMD window as an administrator, and then switch the directory to your unpacked file bin directory. Then enter mysqld install carriage return to run on it, note that mysqld is not MySQL. A successful installation is possible. Because I've already installed it, that's what happened.

Then you start the service in the input net start MySQL. Or if it's not too much trouble, start it manually. Open the service and start the MySQL service.

2.3 tells you a way to open the Win10 service interface. Open Task Manager (right-select Task Manager or Ctrl+alt+delete, whatever you like). Point below the service is OK, is not very simple.

But then there is the problem that the service will not start, this is also my point to talk about the place. I found a difference between the 5.7 and the 5.6 versions. It is estimated that the reason for MySQL was acquired by Oracle. To make MySQL difficult to use, he deleted some of the files in the inside Data folder.

1.2 So we can first initialize the data directory with Mysqld--initialize. After the reboot, the problem is solved.

Modify password

Open the Mysql/bin directory to enter the MYSQL-UROOT-P, the default is no password, is generally directly entered into the Enter, but will appear error 1045 (28000): Access denied for user ' root ' @ ' localhost ' ( Usingpassword:yes) error.

A search on the internet a lot of people have this error. The general solution is to add a command to the configuration file [Mysqld] skip-grant-tables and then reboot to bypass the password.

In the cmd input mysql-u root-p can be without password login, appear password: When direct return can enter, will not appear error 1045 (28000), but many operations will be limited, because there is no grant (no permissions) password

1. Access to MySQL database:

mysql> Use mysql;database changed

2. Set a new password for the root user

mysql> Update Userset Authentication_string=password ("New password") whereuser= "root"; Query ok,1 rows Affected (0.01 sec) rows matched:1changed:1warnings:

3. Refresh the database (always remember to refresh)

mysql>flushprivileges; Queryok, 0 rows Affected (0.00 sec)

4. Exit MySQL:

Mysql> quit

Finally, the skip-grant-tables in the configuration file is commented out. The next time you enter Mysql-uroot-p, you can log in with your new password.

The above is a small set to introduce the MySQL 5.7.14 download installation, configuration and use of detailed tutorials, hope to help everyone, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!