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

This article shares the installation and configuration tutorials of mysql 8.0.16 Win10 zip version for your reference. The details are as follows

First, go to mysql's official website to download the latest version of mysql.

1. Select community as shown in the figure

two。 Click on the icon download

3. Decompress it to the specified disk

Example: F:\ mysql8.0.16

4. Configure environment variables

MYSQL_HOME:F:\ mysql8.0.16`

Add;% MYSQL_HOME%\ bin after path

5. Add File my.ini File

6. Put the following code in the my.ini file

Mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set 3306 port port = 330mm set mysql installation directory basedir=F:\ mysql8.0.16# set mysql database data storage directory datadir=F:\ mysql8.0.16\ data# allow maximum number of connections the character set used by the max_connections=200# server defaults to 8-bit coded latin1 character set character-set-server=utf8# creation The default storage engine default-storage-engine=INNODB that will be used when creating new tables

Special note: basedir and datadir, please modify them according to your actual installation directory

7. To open cmd.exe, you must run as an administrator

7.1 initialize the database

Mysqld-initialize-user=mysql-console

Remember the assigned password:

7.2 installation Services

Mysqld-install MySQL

7.3 start the service

Net start MySQL

If the prompt service starts, everything will be fine if it succeeds.

The first time use mysql will prompt you to change your password.

Alter user 'root'@'localhost' identified by' root' (new password)

After the modification is successful, you can exit and log in to mysql again.

The following other commands may be used

Out of Service

Net stop MySQL

Delete a service

Sc delete MySQL (executable if a problem occurs)

Uninstall mysql

Mysqld-remove

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.