Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to decompress mysql installation, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

The method of mysql unzipped installation is as follows: first, create a new my text, run cmd as an administrator and enter the bin directory of mysql; then configure the environment variable; then set the root administrator password; finally, start the mysql service.

The method of mysql unzipped installation:

1. Select the version of zip package that matches your operating system, and download it directly without logging in, as shown in the figure

2. Specify a local folder to store the downloaded zip package. The list of files in the downloaded file is as follows

3. Create a new my.ini text in the extracted directory, and use notepad to open and copy the following content and save it. Create a new data folder

[mysql]

Set the mysql client default character set

Default-character-set=utf8

[mysqld]

; set port 3306

Port = 3306

; set the installation directory of mysql

Basedir=C:\ mysql-5.7.19-winx64

; set the directory where mysql data is stored

Datadir=C:\ mysql-5.7.19-winx64\ data

; maximum number of connections allowed

Max_connections=200

The character set used by the server defaults to the 8-bit coded latin1 character set

Character-set-server=utf8

The default storage engine that will be used when creating new tables

Default-storage-engine=INNODB

4. Run cmd as an administrator and enter the bin directory of mysql, enter the mysqld install command to install, and after successful installation, enter the command mysqld-- initialize to initialize. Because it automatically reads the my.ini configuration, the data directory will be automatically generated under the root directory after running the command, and finally enter the command net start mysql to start the mysql service.

5. Configure environment variables

Add the bin directory path of mysql to the system environment variable so that the mysql command can be executed directly under cmd

6. Set the root administrator password

Close the mysql service and open a cmd window to enter mysqld-- skip-grant-tables

Open another cmd window

C:\ Users\ Administrator > mysqlWelcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 4Server version: 5.7.19 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql > use mysqlDatabase changedmysql > update user set authentication_string=password ('123456') where user='root';Query OK, 1 row affected, 1 warning (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1

Start the mysql service after completion

7. Log in successfully with the command mysql-uroot-p123456, as shown below

Thank you for reading this article carefully. I hope it is helpful for everyone to share how to decompress the installation of mysql. At the same time, I also hope that you can support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.