• notice
  • Congratulations on the launch of the Sought Tech site

Install the decompression version of Mysql on Windows10

mysql win10 decompression

Download and unzip

Mysql: Version 5.7.13 download link (you can download directly through the official website zip link, no need to register for an Oracle account)

Unzip mysql-5.7.13-winx64.zip to any directory, I unzip it to " D:/Program Files/mysql/mysql-5.7.13-winx64"

Configure system variables

Add a "D:\Program Files\mysql\mysql-5.7.13-winx64\bin" in the system variable PATH.

Modify the default configuration file

There is a configuration file my-default.ini in the directory "mysql-5.7.13-winx64", copy a copy as my.ini.

Modify basedir and datadir in my.ini

basedir = "D:/Program Files/mysql/mysql-5.7.13-winx64"
# This directory will be initialized after executing the mysqld --initialize command
datadir = "D:/Program Files/mysql/mysql-5.7.13-winx64/data"
# server_id must also be set, otherwise an error will be reported [ERROR] You have enabled the binary log, but you haven't provided the mandatory server-id.Please refer to the proper server start-up parameters documentation
# 2016-07-18T15:29:23.097024Z 0 [ERROR] Aborting
server_id = 1

Install

Execute mysqld --initialize --console in the mysql-5.7.13-winx64\bin directory, it must be the bin directory, and it must have --console.You can see the generated password in the last line, but you can't see the password Can you not log in anymore?

PS D:\Program Files\mysql\mysql-5.7.13-winx64\bin> mysqld --initialize --console
2016-07-18T15:56:17.820761Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.Please use --explicit_defau
lts_for_timestamp server option (see documentation for more details).
...
...
...
2016-07-18T15:56:18.449148Z 1 [Note] A temporary password is generated for root@localhost: :esIkHCaG2,d

This command will initially generate many files in the datadir directory set by my.ini.As shown in the picture

Startup

Then install mysql mysqld install to uninstall mysql when reinstalling mysql, command mysqld remove

Then start mysql

PS D:\Program Files\mysql\mysql-5.7.13-winx64\bin> net start mysql
The MySQL service is starting.
The MySQL service has been started successfully.

Run the command bin\mysql_secure_installation.exe for security settings, such as resetting the password and whether to allow remote access.

After starting mysql, run mysql -u root -p to perform database operations, for example, use the following command to see.

# Show which databases are there
show databases;
# Enter the database
use test;
# Display table
show tables;

The above is the introduction of the editor to install the decompressed version of MySql on Windows 10 (recommended), 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!

Tags

Technical otaku

Sought technology together

Related Topic

1 Comments

author

buy lipitor 20mg & lt;a href="https://lipiws.top/"& gt;lipitor 20mg cheap& lt;/a& gt; atorvastatin 80mg without preion

Azminf

2024-03-07

Leave a Reply

+