Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to install and use mysql 5.7.18 zip version", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to install and use mysql 5.7.18 zip version" this article.

Mysql 5.7.18 zip version of MySQL is not like the kind of click can be installed immediately, has been the next step on the OK, this needs to be configured by myself, although a little troublesome, I still prefer to use this version, because it is relatively simple, not because of installing the database, but also to install other plug-in tools.

1. Download path

Download address of MySQL zip files on the official website

Click the download button and follow the prompts to download without logging in to the account; (download the file to, for example: d:\)

two。 Extract the mysql-5.7.18-winx64.zip downloaded to D:\\

After unzipping, the file directory address of mysql is: d:\\ mysql-5.7.18-winx64

3. Configure system environment variables

In the computer configuration, add MYSQL_HOME:D:\\ mysql-5.7.18-winx64 to the system environment variable

Add;% MYSQL_HOME%\ bin after path

4. Add the my.ini file required for the MySQL installation service

Create the file my.ini under the directory D:\\ mysql-5.7.18-winx64

Put the following code in the my.ini file and save it

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=D:\ mysql-5.7.18-winx64# set mysql database data storage directory datadir=D:\ mysql-5.7.18-winx64\ data# allow maximum number of connections the character set used by the max_connections=200# server defaults to 8-bit encoded latin1 characters Set default-storage-engine=INNODB, the default storage engine that character-set-server=utf8# will use when creating new tables

Basedir and datadir are mentioned in the file:

Basedir: refers to the root directory of MySQL

Datadir: it is worth the data storage directory of the subsequent database, so you need to create a data folder under the MySQL root directory (you can create a directory location according to your own ideas, but the configuration in the file needs to be consistent)

The files and folders created are listed below:

5. Initialize the database

To open cmd.exe, you must run as an administrator, because the environment variables have been configured, and the following command can be executed successfully:

Mysqld-initialize-user=mysql-console

Remember the assigned password and use it when logging in for the first time:

6. Install the background service of MySQL

Execute the command in the cmd terminal in the previous step:

Mysqld-install MySQL57

7. Start the MySQL system service

Net start MySQL57

Note: the above steps can be installed successfully, the following other commands may be used

Stop service: net stop MySQL57

Delete service: sc delete MySQL57 (executable if a problem occurs)

Possible problems

Loss of msvcp120.dll

Install vcredist_x86.exe or vcredist_x64.exe, depending on your system.

Other questions

If you execute the sc delete MySQL57 directive, remember to clear all files under the data folder.

If the net start MySQL57 instruction is executed

Appear:

'The MySQL service is starting.

The MySQL service could not be started.

The service did not report any errors.

'

To configure environment variables or misconfigure environment variables, please check carefully.

8. Log in for the first time and change your password

Log in with the initial password: mysql-u root-p

After logging in successfully, use the show databases; command to find that it cannot be used, and prompt you to reset the password:

Set password for root@localhost=password ("your password")

9. Congratulations on completing the installation task of the MySQL zip version

The above is all the contents of the article "how to install and use mysql 5.7.18 zip version". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.