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

First of all, let's have a chat with you. With the rapid update of MySQL, MySQL has been updated to version 8.0 by leaps and bounds, so what's the obvious difference between it and the 5.x version we used before? First of all, let's take a look at the query speed of MySQL5.X 's own table.

After that, the query speed of MySQL8.0 's own table is presented.

The result of the same data is obvious. I have walked all over the pit of MySQL8.0. In order to avoid detours, the following manual installation methods are presented.

1. Download and decompress the official website

I downloaded mysql-8.0.11-winx64, download address

Directly click on the hyperlink circled by my red marker, which means: no, just start downloading

two。 Set system environment variables

This does not say much about Baidu on a pile, the configuration of this is only for command line convenience.

3. Write a configuration file

If the decompression location is D:\ App\ MySQL\ mysql-8.0.11-winx64

Create the my.ini file manually here, with the following contents:

Pay attention to modifying the installation directory and data storage directory

[mysql]; set mysql client default character set default-character-set=utf8 [mysqld]; set port 3306 port = 3306; set mysql installation directory basedir=D:\ App\ MySQL\ mysql-8.0.11-winx64; set mysql database data storage directory datadir=D:\ App\ MySQL\ mysql-8.0.11-winx64\ data; allow maximum number of connections max_connections=200 The character set used by the server defaults to the 8-bit encoded latin1 character set character-set-server=utf8; the default storage engine default-storage-engine=INNODB that will be used when creating new tables

4. Database initialization

Run the command line as an administrator and enter the following command in the bin directory under the installation MySQL:

Automatically generate root users without a password:

Mysqld-initialize-insecure

Or with a random password:

Mysqld-initialize

The random password is saved in the error log under the (previously configured datadir) data folder with the file name: hostname. err

Note: if you want to reinitialize, you must first empty the data folder. (including stopping the next step of service)

The tutorial I read is that there is no such step, resulting in:

The service cannot be started.

The server did not report any errors.

Please type NET HELPMSG 3534 for more help.

5. Install and start the service

Execute under the command line.

Installation Services:

Mysqld-install

Start the service:

Net start mysql

When going back, it's the other way around.

Stop, uninstall the service:

Net stop mysqlmysqld-remove

6. Enter MySQL

Password-free access:

Mysql-u root

Access with a password:

Mysql-u root-p

If you have a password, you will be asked to enter it. If you have a random password, the location has been mentioned above.

Moved, finally saw:

Mysql >

Finally, if there is a caching-sha2-password problem in the client connection,

Solutions are as follows:

First, ALTER USER 'root'@'localhost' IDENTIFIED BY' password' PASSWORD EXPIRE NEVER; # modifies the encryption rules

Then: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' password'; # update the user's password

Finally: FLUSH PRIVILEGES; # refresh permissions

If you have any mistakes or do not understand in the comments below, I will answer patiently.

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.