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

This article shares the installation tutorial of mysql 8.0.12 for your reference. The details are as follows

Download address: address link

Now the lowest community version, that is, the free version

After that, we will see that there are two options for downloading, one is the zip package format and the other is the Install version. It is personally recommended to download the zip package format, which is faster to download and install, and more convenient.

After downloading, extract the file to the location of the mysql file you want to place

Step 1: set environment variables

Add the bin directory in the file you unzipped to path. For example: d:\ Sql Server\ mysql-8.0.12-winx64\ bin

Step 2: configure initialization my.ini

Create and add my.ini in D:\ Sql Server\ mysql-8.0.12-winx64

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=D:\\ Sql Server\\ mysql-8.0.12-winx64 # remember to use double slash\\ here, single slash will make an error here. # set the directory where the data of the mysql database is stored: datadir=D:\\ Sql Server\\ mysql-8.0.12-winx64\\ Data # here is the same as above # maximum number of connections allowed the number of connection failures allowed by max_connections=200#. This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=10# server of the database system from this host. By default, the default storage engine default-storage-engine=INNODB# that UTF8character-set-server=utf8# will use when creating a new table uses the "mysql_native_password" plug-in authentication default_authentication_plugin=mysql_native_ password [MySQL] # to set the mysql client default character set default-character-set=utf8 [client] # setting. Set the port port=3306default-character-set=utf8 used by default when the mysql client connects to the server

Step 3: run the cmd command as an administrator and change the path to the bin directory of mysql

3.1 initialize the database, run the command: mysqld-- initialize-- console

Paste this sentence into your notepad in case you forget, it's the default password.

A temporary password is generated for root@localhost: rI5rvf5x5G,E

3.2 install service, allow command: mysqld-- install [service name] in which the service name can be left unwritten. The default is mysql.

At this point, mysql is installed.

Run mysql

Net start mysql

Stop mysql

Net stop mysql

Want to change the password

Run cmd and run the command under the bin directory: mysql-u root-p enter the password recorded above, and change the password

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.