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

This article is to share with you about how to install mysql 8.0.15 in windows, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Installation

1. Download zip on the official website

2. Decompress and copy to the specified directory. Create a new data file. Add environment variabl

3. Create a new my.ini file

[mysqld] # set port 3306 port=3306# set the installation directory of mysql:\\ MySQL\\ mysql-8.0.15-winx64# set the directory where the data of mysql database is stored datadir=D:\ MySQL\\ data# allow the maximum number of connections max_connections=200# allows the number of connection failures. The character set used by the max_connect_errors=10# server defaults to the default storage engine default-storage-engine=INNODB# that UTF8character-set-server=utf8# will use when creating new tables using the "mysql_native_password" plug-in authentication # mysql_native_passworddefault_authentication_plugin=mysql_native_ password [MySQL] # setting the mysql client default character set default-character-set=utf8 [client] # setting the default port port=3306default-character-set=utf8 when the mysql client connects to the server

4. The administrator runs the command line window to configure MySQL

Go to the bin directory and execute the command

Mysqld-install-console

Then execute id integer,-> name varchar (8),-> password varchar (20))

Insert data

Insert into student (id,name,password)-> value (1001, "xx", 123456)

Select data

Select * from student

Navicat connection MySQL

Link: Navicat Premium 12.0

Open exe and create a MySQL connection

The connection success icon is green

Solve the problem of database Can't connect to MySQL server on 'localhost' (10061)

Can't connect to MySQL server on 'localhost' (10061). I don't seem to have touched it either. I can't help it. I can't open it all the time.

Open Task Manager-> Click Services-> find MySQ, then right-click to start the service, and then wait a moment to reopen the database.

The above is how to install mysql 8.0.15 in windows. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please 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.