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

This article mainly introduces "the method of installation and configuration of mysql 8.0.26". In the daily operation, I believe that many people have doubts about the method of installation and configuration of mysql 8.0.26. The editor has consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "method of installation and configuration of mysql 8.0.26". Next, please follow the editor to study!

Step 1: first go to the official website to download

MySQL: Download MySQL Community Server

The default is the latest version (currently the latest 8.0.27)

Step 2: download and decompress to the directory you want to store

Step 3: there is no my.ini file in the extracted directory. You can create the my.ini added under the installation root directory (create a new text file and change the file type to .ini), and write to the basic configuration: ()

[mysqld] # set port 3306 port=3306# set mysql installation directory need to change basedir=C:\ Program Files\ MySQL# set mysql database data storage directory need to change datadir=C:\ Program Files\ MySQL\ Data# 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 utf8mb4character-set-server=utf8mb4# 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=utf8mb4 [client] # setting the default port port=3306default-character-set=utf8mb4 when the mysql client connects to the server

The configuration file is ready and then configure the MySQL environment configuration

My computer-> right-click-> Properties-> Advanced system Settings-> Environment variables

First create a new system variable

Variable name: MYSQL_HOME

The variable value is: the path of the current mysql file

Click 'Path' variable-> Edit-> New

Create a new environment variable in Path

% MYSQL_HOME%\ bin

Click OK to save the settings

Install and configure the MySQL service

Step one:

Open cmd as an administrator

Step 2:

After opening it, enter the bin directory of mysql and enter cd + space + your path.

Step 3:

Enter mysqld-- initialize-- console under the bin directory under the MySQL directory

(initialize MySQL to get the initial password)

Step 4:

To install the MySQL service, enter mysqld-- install [service name] (the service name can be mysql by default)

Step 5:

Enter net start mysql after the service installation is successful (start the service of MySQL)

Step 6:

Connect to MySQL, and I use Navicat to show

At this point, the study on the method of installation and configuration of mysql 8.0.26 is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.