Shulou(Shulou.com)06/01 Report--

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

This article focuses on solving the installation problem of mysql8.0.19 winx64 version, which is as follows:

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

By the way, the latest Sina Weibo is so bad that I can't log in.

I have been writing in Sina before.

Let's change this place later, and suddenly I find that I like the style here very much.

=

After downloading, unzipping, found that there are no installation files, and then Baidu, found that to create a my.ini and data directory, I feel very bullshit, the installation actually needs this.

Then, after installation, when you execute to "mysql-u root-p", the online tutorials can enter the password, but the error is prompted after entering:

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

Then continue to search the Internet, a bunch of solutions, they unexpectedly solved, but I can not solve.

Here is a small mistake:

PS C:\ WINDOWS\ system32 > mysql-- install mysql

Mysql: [ERROR] unknown option'- install'.

The letter d on the last side is actually mysqld, not mysql. Look down there.

=

After that, I deleted data and my.ini, too.

Then follow these steps 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 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)

Then there is the operation of the database.

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

Summary

At this point, this is the end of this article on solving the installation problem of the mysql8.0.19 winx64 version. For more information about mysql8.0.19 winx64 database installation, please search for previous articles or continue to browse the relevant articles below. I hope you will support it in the future!

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.