Mysql 5.7.14 download, install, configure, and use the detailed tutorial, mysql5.7.14

Mysql 5.7.14 download, install, configure, and use the detailed tutorial, mysql5.7.14

Download

A. I use the ZIP Archive version here. All 64-bit win8 machines support this. So I suggest using this version. This is also simple and clean. Click Download.

B. click it to go to another page, but it does not download it. You don't have to worry about it. It doesn't matter if you don't understand it. It means you can log on (login ), you can also register an account (sign up) and download it after logging on or registering. (Remember that the password must be a combination of letters and numbers, and be case-insensitive)

C. If you have one, you can log on directly.

Click DownNow. The file is not big. It is more than 300 mb. It will arrive at the place below in a short time, but if it cannot be found, it will be necessary to exit again, and the operation just now will go again.

Similarly, if you want to download MySQL from linux, you can find it here;

After the download is complete, install and configure it.

The method and steps are as follows:

The ZIP Archive version is free of installation. You just need to decompress the package. It is no different from the installation version, but it does not need to be installed. Find the downloaded mysql-5.7.10-winx64.zip file and right-click it (decompress it to...) and put it in the desired location. If you like C, you can choose C. If you don't like C, you can choose C. I personally like F. After all, the C drive is hard to put too many things on the system disk. It's easy to decompress the package.

Are you sure you want to ask? How to use it? \ How does mysql.exe in the binpoint fail to respond to a black window?

No response because the service is not available yet!

Configure the default file

In theory, you can directly install the service now, but because it is the default configuration, we will encounter many problems when using it. For example, the Chinese characters in it are all garbled characters, so we recommend that you configure the default file first. Under the mysql-5.7.10-winx64 directory, create a new my. ini. Copy the following code and save it. My. ini replaces the drop-down my-default.ini file. The INI file is the configuration file in the window. Save various default data. The installation version allows you to select and save it to you during the installation process. The zip archieve is written by yourself, both of which are the same. What does the code syntax mean? You need to check your own documents. I want to know more about it. Here I can't explain it clearly.

[Mysql]; set mysql client default character set default-character-set = utf8 [mysqld]; set port 3306 = 3306; set mysql installation directory basedir = F: \ mysql-5.7.10-winx64; set datadir = F: \ mysql-5.7.10-winx64 \ data; Maximum number of connections allowed max_connections = 200; the default character set used by the server is the 8-bit latin1 character set character-set-server = utf8. When creating a new table, the default storage engine default-storage-engine = INNODB

Install mysql Service

A. right-click Start and select search and Enter cmd. a command prompt is displayed, right-click and select Run as administrator. Otherwise, an error code with insufficient identity will appear, this is a feature of windows. If my. ini is wrong, the error code is 1067.

1. 2. Open the cmd window as an administrator and switch the directory to the bin directory of the decompressed file. Enter mysqld install and press enter to run the command. Note that mysqld is not mysql. The installation is successful. This is because I have already installed it.

Then, enter net start mysql to start the service. Or if it is not too troublesome, start it manually. Open the service and start the mysql service.

2. 3. Let us know how to open the win10 service interface. Open the Task Manager (right-click the task manager or press ctrl + alt + delete, as you like ). Click the following service. Is it very simple.

However, the service cannot be started. I found a difference when comparing the differences between version 5.7 and version 5.6. It is estimated that MySQL was acquired by oracle. To make MySQL difficult to use, he deleted some files in the data folder.

So we can first initialize the data directory with mysqld -- initialize. Restart to solve the problem.

Change Password

Open the MySQL/bin directory and enter mysql-uroot-p. By default, there is no password. Generally, press enter directly, but ERROR 1045 (28000) may occur ): access denied for user 'root' @ 'localhost' (usingpassword: YES) error.

A lot of people found this error on the Internet. The general solution is to add a command skip-grant-tables under the [mysqld] entry in the configuration file, and then restart it to skip the password.

Enter mysql-u root-p in cmd to log on without a password. When password: is displayed, press enter to enter without ERROR 1045 (28000 ), however, many operations are restricted because there is no password that cannot be granted (no permission ).

1. Enter the 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: 1 Changed: 1 Warnings:

3. Refresh the database (remember to refresh it)

mysql>flushprivileges; QueryOK, 0 rows affected (0.00 sec)

4. Exit mysql:

mysql> quit

Comment out the skip-grant-tables in the configuration file. The next time you enter mysql-uroot-p, you can log on with the new password.

The above section describes how to download, install, configure, and use mysql 5.7.14. I hope it will help you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!