MySQLインストールチュートリアル（Windows用）詳細

まえがき

MySQL ライブラリに興味を持つすべてのパートナーに、取材のため、あるいは知識を広げるために、このライブラリから何かを学んでもらい、その助けとなることを目指しています。

1、ダウンロードする前に知っておくべきいくつかの概念

私たちがダウンロードするために公式サイトに入ると、公式サイトが多くの種類のバージョンを提供していることがわかりますが、それらは一体何を意味し、どれが私たちが必要とするものなのでしょうか？ここでは、一般的なものを以下のように簡単に紹介します。

MySQL Enterprise Editionです。 Mysql 最新の機能や管理ツールを搭載し、技術サポートも受けられる（ただし有償）「Enterprise Edition」。

MySQL Cluster CGE。 データへの高速で安定したアクセスと高いスループットを実現するオープンソースのトランザクションデータベースで、次のものが含まれています。 MySQL Cluster MySQL Cluster MySQL Enterprise Edition ,

MySQL Cluster Manager
The functions of the
MySQL Community (GPL).
The version of MySQL that follows the GPL open source agreement, most of the community versions we use follow this agreement (it's free)
MySQL Installer: 
is an installation manager that provides a unified tool for managing downloads, as the MySQL family includes many products.
MySQL Community Server:
MySQL Community 
(GPL) under the open source community version, which is the open source version of the database used (free, disk it). 
Workbench: 
Similar to
navicat
is a graphical interface UI tool that enables remote
Mysql
Database access (at first it is not recommended to use the graphical management tools directly, it is recommended to understand through the command line, so that you can know Mysql faster, the masters are using the command line (PS: if you need graphical tools can be private me)).
2. Choose the version you need
Go to the official website and download the version you need (
www.mysql.com/)
Or download it directly from the cloud (private message me, it's faster this way),
The download steps are as follows:
(1) Go to the MySQL website => Select the "DOWNLOADS" option => Click on MySQL Community (GPL) Downloads "
(2) Choose "MySQL Community Server (without GUI - recommended)" or MySQL Workbench (with GUI) according to your needs
(3) Download the installation package (32-bit computer download the 32-bit installation package, 64-bit computer download the 64-bit installation package)
(4) Unzip the downloaded installation package
(5) Configure environment variables
Environment variables: 
refers to when you belong to any value on the command line,
win
The system will match the environment variables in the pool, and if it matches an executable path, it will go directly to the corresponding path for execution.
If you type
mysql
then you configure the path of your MySQL installation in the environment variable as:D:\mysql8.x\bin, then the system will match to D:\mysql8.x\bin\mysql, if there is this executable file in this directory, then run it as follows:.
3. Connect to MySQL service
(1) Start MySQL server and log in
(2) If you find that the MySQL service cannot be started, you can configure it as follows
in
mysql
Add the following my.ini file to the compressed path, as follows (change the two working paths to your own path):
[mysqld]
# Set port 3306
port=3306
# Set the mysql installation directory
basedir=D:\Mylargeprogram\Mysql\mysql-8.0.12-winx64
# Set the mysql database data storage directory
datadir=D:\Mylargeprogram\Mysql\mysql-8.0.12-winx64\data
# Maximum number of connections allowed
max_connections=200
# The number of failed connections allowed. This is to prevent someone from that host from trying to attack the database system
max_connect_errors=10
# The default character set used on the server is UTF8
character-set-server=utf8
# Default storage engine to be used when creating new tables
default-storage-engine=INNODB
# Default authentication with "mysql_native_password" plugin
default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set for mysql client
default-character-set=utf8
[client]
# Set the default port used by mysql clients when connecting to the server
port=3306
default-character-set=utf8



Execution execution 
mysqld --initialize-insecure 
command to configure, the installation path will generate a data folder by default, the
as follows:
(3) Type mysqld --install to register mysql to the Window service, skipping it if it prompts you that it already exists
(4) Start the mysql service:
net start mysql
(5) Connect to the Mysql service: 
mysql -u root -p 
Enter (the default password is empty, enter the password directly, for security, remember to change the password Oh), Mysql installation is complete, you can operate at will!
(6) To change the password, there are two versions of MySQL: 5.x and 8.x. The steps are as follows:
Select mysql database: use mysql
Change the password of the root user
// Version 5.x changes
UPDATE USER SET PASSWORD=PASSWORD('your password') WHERE USER='root';

// Version 8.x modification
// Format: alter table name username@user table username corresponding Host field value IDENTIFIED WITH specify which encryption technique to use BY 'modified password'
ALTER USER root@localhost IDENTIFIED WITH caching_sha2_password BY '123456';


To this point this article about details
windows
under
MySQL
This is the end of the article on MySQL installation tutorials. For more information on MySQL installation tutorials, please search the previous articles in the Codedevlib or continue to browse the following related articles.

[mysqld]
# Set port 3306
port=3306
# Set the mysql installation directory
basedir=D:\Mylargeprogram\Mysql\mysql-8.0.12-winx64
# Set the mysql database data storage directory
datadir=D:\Mylargeprogram\Mysql\mysql-8.0.12-winx64\data
# Maximum number of connections allowed
max_connections=200
# The number of failed connections allowed. This is to prevent someone from that host from trying to attack the database system
max_connect_errors=10
# The default character set used on the server is UTF8
character-set-server=utf8
# Default storage engine to be used when creating new tables
default-storage-engine=INNODB
# Default authentication with "mysql_native_password" plugin
default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set for mysql client
default-character-set=utf8
[client]
# Set the default port used by mysql clients when connecting to the server
port=3306
default-character-set=utf8

windows