MySQL 8.0.21 installation steps and problem solutions

Download the official website

First go to the official website to download MySQL

The link jumps to the download address of mysql: https://dev.mysql.com/downloads/mysql/
The latest version is 8.0.21

After decompression, it is as shown below.

Initial configuration

Since there is no my.ini file in the downloaded and unzipped folder, I created a new one here. I have given the configuration, and you can just copy it and modify it according to your actual situation.

[mysqld]
# Set port 3306 port=3306
# Set the installation directory of MySQL basedir=D:\Program Files (x86)\mysql-8.0.21-winx64\MySQL
# Set the storage directory of MySQL database data datadir=D:\Program Files (x86)\mysql-8.0.21-winx64\MySQL\Data
# Maximum number of connections allowed max_connections=200
# The number of connection failures allowed.
max_connect_errors=10
# The default character set used by the server is utf8mb4
character-set-server=utf8mb4
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
#Default authentication is done with the "mysql_native_password" plugin #mysql_native_password
default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set of the mysql client to default-character-set=utf8mb4
[client]
# Set the default port used by the mysql client to connect to the server port = 3306
default-character-set=utf8mb4

About time zone settings

• Refer to the author's time zone configuration
• Add default-time_zone = '+8:00' to the mysqld section of the my.ini file
  

About the problem of discontinuous id after deleting data

In order to output the id in sequence, we need to initialize the id and reset it
alter table user3 drop id;
alter table user3 add id int not null primary key auto_increment first;

Formal installation

Okay, the preparations are complete, let's start the installation.

Simply enter cmd in the address bar to enter the command line interface for installation.
Some of you may not have the permission to run the program, so you have to run it as an administrator.

I. . Crying, I actually believed it, but the same thing happened after reinstalling. Okay, I'll go download it.

Hiss, that’s too much!

The author cried and installed a VM virtual machine, regained his confidence, and restarted the computer

Configuration

mysqld --initialize --console

🆗!!!

This is a temporary password.

Execute the following command: mysqld --install to install

This is success

Start MySQL

The installation is successful, ready to start MySql:

net start mysql, this is to start the mysql service net stop mysql, this is to shut down the mysql service

By the way, regarding how to visually operate MySQL, I personally use this one

Do you still have the previous password saved?

Hiss, maybe it has been too long, I can actually set a password directly.

Of course, you can also connect to the database in the mysql\bin directory we just operated on:
mysql -u root -p
Enter the password and press Enter

When you see mysql> appear, you know you have entered the MySQL command line and can now change your password!
ALTER USER 'root'@'localhost' IDENTIFIED BY 'your new password';

Press Enter and then **exit; **This will exit MySQL

About the system error 2 reported during the installation process

Even if we configure the system environment variables, there is still system error 2.
There is no need to panic at this time, just continue according to the author's instructions.
Note: first remove the service we installed incorrectly, or uninstall the remaining service

• mysqld remove
• mysqld install
• net start mysql

Then it succeeded.

The service already exists!

If we display this sentence after mysqld --install: The service already exists!
Use sc delete mysql to delete the service.
Then run mysqld --isntall
It will show Service successfully installed.

This is the end of this article about the installation steps of MySQL 8.0.21 and solutions to problems. For more information about the installation steps of MySQL 8.0.21, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!