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

This article shares the manual installation tutorial of mysql 8.0.13 for your reference. The details are as follows

First, step interpretation

1. Download MySQL

Download address

Select Downloads-- > Community-- > MySQL Community Server, then pull to the bottom of the page, and click download.

At this point, you will generally be prompted to log in, ignore it, and click the bottom "No thanks, just start my download." Download directly.

We choose Generally Available (GA) Release to download. GA refers to the general version of the software, which generally refers to the officially released version.

two。 Extract to a path, for example: d:\ Mysql

3. Set the environment variable:

Append after path; D:\ Mysql\ bin

4. Create a new configuration file my.ini in the root directory and edit the file

[mysqld] # bind IPv4bind-address = 0.0.0.0 # set the installation directory of mysql That is, the location where you unzipped the installation package basedir = D:/Mysql # set the data storage directory of the mysql database datadir = D:/Mysql/data # set the port number port = 3306 # allow the maximum number of connections max_connections = 200# set the character set to utf8loose-default-character-set = utf8character-set-server = utf8 # start the query cache explicit_defaults_for_timestamp = true sql_mode=NO_ENGINE_SUBSTITUTION STRICT_TRANS_TABLES [client] # set client character set port=3306loose-default-character-set = utf8 [WinMySQLadmin] Server = D:/Mysql/bin/mysqld.exe

5. Register mysql as a Windows system service

5.1Open CMD with plumber privileges (note administrator privileges)

5.2 run the service installation command

Mysqld install MySQL-defaults-file= "D:/Mysql/my.ini"

When the installation is successful, it will prompt you to install successfully.

Note: if you want to remove the service, use the command: mysqld-remove

Install vcredist_x64.exe if msvcr120.dll is missing

6. Start the mysql service

Note: it is not possible to start the mysql service normally at this time, because version 5.7.18 does not come with the data folder

You need to create the data folder and the default database through the command

6.1 create command

Mysqld-initialize-insecure-user=mysql

6.2 the start service command is

Net start mysql

6.3 Open Administrative tools-Services to find the MySQL service. Start the service by right-clicking Startup or clicking Startup on the left

7. Modify the password of the root account (the following instructions need to be entered in the console, and some with semicolons)

When the installation is completed, the default password for the root account is empty. At this time, you can change the password to the specified password.

Open the database

Mysql-uroot-p (prompt Enter password, enter directly, default password is empty) use mysql;UPDATE user SET authentication_string = PASSWORD ('root') WHERE user =' root';FLUSH PRIVILEGES;exit

At this point, the password modification is complete.

At this point, the MySQL database is installed on the server side!

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.