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

This article mainly introduces the detailed method of mysql-5.7.21 installation under windows, the contents of the article are carefully selected and edited by the author, with a certain pertinence, and is of great significance to everyone's reference, the following is to understand the detailed method of mysql-5.7.21 installation under windows with the author.

download

Go to the MySQL official website, find the download link, and find the download as shown in the figure:

Installation

Extract the downloaded installation package directly to the installation path (I put it under D:\ mysql)

Under the unzipped D:\ mysql\ mysql-5.7.21-winx64 directory, manually create the my.ini file, which I created with Notepad++, as follows:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] skip-name-resolveskip-grant-tables# setting 3306 port port = 330 setting mysql installation directory basedir=D:\ mysql\ mysql-5.7.21-winx64# set mysql database data storage directory datadir=D:\ mysql\ mysql-5.7.21-winx64\ data# maximum number of connections allowed by the max_connections=200# server Set defaults to 8-bit encoded latin1 character set character-set-server=utf8# default storage engine default-storage-engine=INNODB to use when creating new tables

Install the MySQL service

Run cmd as an administrator and go to the D:\ mysql\ mysql-5.7.21-winx64\ bin directory

Execute command: mysqld install

The prompt "service successfully installed" indicates that the installation is successful.

To create a data file, note that it is not created manually. Also execute the command in this directory: mysqld-initialize-insecure-user=mysql. At this time, the data folder appears in the D:\ mysql\ mysql-5.7.21-winx64 directory, and the default database is set up. The login user name is root and the password is empty.

To start the MySQL service, there are several ways to start it:

Find the windows task manager, switch the services tab, and click the "Services" button on the lower right, needless to say.

Enter cmd in the D:\ mysql\ mysql-5.7.21-winx64\ bin directory and enter the command: net start mysql.

If you don't want to switch to the bin directory to execute the MySQL statement, you can add the bin directory path to the environment variable, not to mention much.

Log in to the database and enter the command: mysql-u root-p. The password is empty.

Show which databases are available, show databases; (notice that the sql statement is followed by a semicolon to indicate the end of the statement, execute the statement):

Modify the password

Access to mysql database: use mysql

Change the password: update user set authentication_string= "123456"; in this case, the password is changed to 123456

At this point, the local database can be used happily. You can use navicat to manage and use the database more easily, as shown below:

After reading the above detailed methods of installing mysql-5.7.21 under windows, many readers must have some understanding. If you need more industry knowledge and information, you can continue to follow our industry information column.

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.