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

This article shares the download and installation of mysql8.0 for your reference. The details are as follows

The first thing to do is to download the 8.0 version of mysql. You can go to the official website and search for mysql download directly from Baidu. Select the following page.

After entering, choose the community version, that is, community.

Select the zip version corresponding to the number of computer digits at the bottom

You can also download the 64-bit version directly.

1. Installation and configuration files

Unzip the downloaded installation package, and the path is random, so that you can find it easily. Before initialization, we need to configure the my.ini file, because there is no my.ini file in the unzipped folder, so we need to create a new one, then copy the following, and modify part of the path according to the following tips

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=C:\ Program Files\ MySQL / / modify to your database installation directory # set the mysql database data storage directory datadir=E:\ database\ MySQL\ Data / / generally in the database root directory, that is, add Data# to the above path plus the maximum number of connections allowed by max_connections=200#. This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=10# server of the database system from this host. By default, the default storage engine default-storage-engine=INNODB# that UTF8character-set-server=utf8# will use when creating a new table uses the "mysql_native_password" plug-in authentication default_authentication_plugin=mysql_native_ password [MySQL] # to set the mysql client default character set default-character-set=utf8 [client] # setting. Set the port port=3306default-character-set=utf8 used by default when the mysql client connects to the server

two。 Database initialization

Run the command prompt as an administrator and go to the bin directory of the MySQL installation directory to execute the command: mysqld-- initialize-- console. I don't know how to enter the bin directory. You can go to Baidu. I won't elaborate here.

C:\ Program Files\ MySQL\ bin > mysqld-- initialize-- console2018-04-28T15:57:17.087519Z 0 [System] [MY-013169] [Server] C:\ Program Files\ MySQL\ bin\ mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 49842018-04-28T15:57:24.859249Z 5 [Note] [Server] A temporary password is generated for root@localhost: rI5rvf5x5G,E

Localhost is followed by a random password generated after initialization.

3. Install and start the database service

Still continue to execute the command mysqld-install in the bin directory, and after the installation is complete, you can start the MySQL service by executing the command net start mysql

C:\ Program Files\ MySQL\ bin > mysqld-- installService successfully installed.C:\ Program Files\ MySQL\ bin > the net start mysqlMySQL service is starting.. the MySQL service has started successfully. C:\ Program Files\ MySQL\ bin >

4. Login and change password

Execute the command in the bin directory of the MySQL installation directory: mysql-u root-p, and then enter the initialization password. After entering successfully, execute the command in MySQL: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' new password;, as shown in the following figure, change the password successfully

C:\ Program Files\ MySQL\ bin > mysql-u root-pEnter password: * Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 8Server version: 8.0.11 Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners. 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' new password; Query OK, 0 rows affected (0.06 sec) mysql >

At this point, the installation and deployment is complete. You can use the command to check the default installation of the database: show databases, as shown in the following figure, the entire database installation process has been completed successfully.

Mysql > show databases;+-+ | Database | +-+ | information_schema | | mysql | | performance_schema | | sys | +-+ 4 rows in set (0.01 sec) mysql >

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.