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

First, preliminary preparation (windows7+mysql-8.0.18-winx64)

1. Download address: https://dev.mysql.com/downloads/

two。 If you choose not to log in to the account directly, the downloaded package is about 200 M, and about one G after decompression.

3. Compress the file, remember the location of the compressed file, the following need to add environment variables, my: C:\ Program Files\ mysql-8.0.18-winx64, put the file in a place you are accustomed to, and create a data folder and a my.ini file, the data file is empty, there are many combination methods on my.ini, depending on personal needs

My.ini: [mysqld] character-set-server=utf8# binds IPv4 and port 3306 bind-address = 0.0.0.0port = 3306sqlroommode = "STRICT_TRANS_TABLES NO_ENGINE_SUBSTITUTION "default_storage_engine=innodbinnodb_buffer_pool_size=1000Minnodb_log_file_size=50M# sets the installation directory of mysql:\ Program Files\ mysql-8.0.18-winx64# sets the directory where the data of the mysql database is stored datadir=C:\ Program Files\ mysql-8.0.18-winx64\ data# allows the maximum number of connections max_connections=20# skip_grant_ tables [MySQL] default-character-set=utf8 [mysql.server] default-character-set= utf8 [MySQL _ safe] default-character-set=utf8

4. Add environment variables, search for environment variables, or right-click my computer properties for advanced system configuration

Click the environment variable

Click New

Put the path of mysql's bin directory on it, and then make sure.

Second, install MYSQL

1. Initialize mysql,cmd to open the command line

Mysqld-- initialize-- user=mysql-console there is a warning below, you can ignore the error report, remember the temporary password, right-click and then right-click to complete the copy, paste to another place

two。 Installation succeeded

3. Start the mysql service

Or start the mysql service in the service. The service name here is mysqld-install + plus the service name. I didn't add it here. It should be the default service name.

4. Log in to mysql and enter the password you recorded earlier

5. Reset password set password='123456'

6. Create a database for testing, oracle,mysql still feels comfortable and concise after using it for a long time

In fact, this way to install mysql is also very fast, and green, download directly from the official website

Summary

The above is the illustration of the mysql8.0.18 deployment and installation tutorial under windows7 introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

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.