Solve the installation problem of mysql8.0.19 winx64 version

MySQL is an open source, small relational database management system developed by the Swedish company MySQL AB. Currently, MySQL is widely used in small and medium-sized websites on the Internet. Due to its small size, fast speed, low total cost of ownership, and especially its open source nature, many small and medium-sized websites choose MySQL as their website database in order to reduce their total cost of ownership.

This article focuses on solving the installation problem of mysql8.0.19 winx64 version. The specific content is as follows:

Download address: https://dev.mysql.com/downloads/mysql/, I downloaded the 187.8M one above.

By the way, Sina Weibo is really terrible recently. I can’t even log in to it.

I used to write at Sina.

I'll change this later. I suddenly found that I like this style.

==================================================
After downloading and unzipping, I found that there was no installation file at all. Then I searched on Baidu and found that I needed to create a my.ini and data directory first. I felt it was ridiculous that the installation required this.

After installation, when executing " mysql -u root -p ", the online tutorial just needs to enter the password, but an error message appears after entering:

“ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)”

Then I continued searching online and found a bunch of solutions. They all solved the problem, but mine couldn't be solved.

Insert a small error here:
PS C:\WINDOWS\system32>mysql --install mysql
mysql: [ERROR] unknown option '--install'.

The one with the letter d at the end is actually mysqld, not mysql. See below.

===================================================
Later I deleted data and my.ini.

Then follow the steps below step by step.

PS C:\WINDOWS\system32>mysqld --initialize --console
2020-03-07T11:07:18.159694Z 0 [System] [MY-013169] [Server] D:\Program Files\mysql-8.0.19-winx64\bin\mysqld.exe (mysqld 8.0.19) initializing of server in progress as process 5900
2020-03-07T11:07:22.120685Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Qy_kuyaC)1qg
PS C:\WINDOWS\system32>mysqld --install
The service already exists!
The current server installed: "D:\Program Files\mysql-8.0.19-winx64\bin\mysqld.exe" mysql
PS C:\WINDOWS\system32> net start mysql

The mysql service is starting.

The mysql service has been started successfully.

PS C:\WINDOWS\system32>mysql -uroot -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.19
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxxxxx';
Query OK, 0 rows affected (0.01 sec)

The next step is the operation of the database.

Enter the mysql directory and find that the data folder is automatically generated.

Summarize

This is the end of this article about solving the installation problem of mysql8.0.19 winx64 version. For more relevant mysql8.0.19 winx64 database installation content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!