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

This article mainly introduces how to install and configure mysql 8.0.15 compressed version, the article is very detailed, has a certain reference value, interested friends must read it!

The details are as follows

1. Download the mysql8.0.15.zip file

two。 Add a configuration file named my.ini under the mysql directory: the content is:

[mysqld] # set port 3306 port=3306 # set the installation directory of mysql:\ Program Files\ mysql\ mysql-8.0.15-winx64# set the directory where the data of mysql database is stored datadir=D:\ Program Files\ mysql\ Data # allow the maximum number of connections max_connections=200# allows the number of connections to fail. The character set used by the max_connect_errors=10 # server defaults to UTF8 character-set-server=utf8 # the default storage engine that will be used when creating a new table default-storage-engine=INNODB # uses the "mysql_native_password" plug-in authentication # mysql_native_password default_authentication_plugin=mysql_native_password [mysql] # sets the mysql client default character set default-character-set=utf8 [client] # sets the default port port=3306 default-character-set=utf8 when the mysql client connects to the server

Among them: set up the data storage directory of mysql and decide according to your own installation path.

3. Open cmd as an administrator and go to the bin directory in mysql:

4.mysql initialization: execute: mysqld-- initialize-- the contents of the red box in the console diagram, and write down the temporary password (in the green box): excluding the first space

5.mysql installation service: re-enter cmd, execute: mysqld-- install, execute sc delete mysql and then execute mysqld-- install if the following occurs

6. Start the mysql service: execute net start mysql

7. You can change the initial password of mysql according to your personal situation: it is recommended to use the navicat tool to change the password. When you use the navicat tool to connect to the mysql database for the first time, the test passes and navicat will prompt you to reset your password:

The above is all the contents of the article "how to install and configure mysql 8.0.15 compressed version". Thank you for reading! Hope to share the content to help you, more related 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.