Location>code7788 >text

Windows mysql8 installation zip

Popularity：552 ℃/2025-03-07 14:05:52

MySQL is a widely used relational database management system, and MySQL 8 is its latest major version, combining excellent performance and rich functionality.

1. Preparation

1. Download the MySQL 8 zip package

First, you need to get the MySQL 8 compressed package. Visit MySQL official download page in your browser

2. Unzip the zip file

After the download is complete, select a suitable directory to store MySQL. Usually, we can create a folder named mysql under C:\ and extract the downloaded zip file into that folder.
C:\-winx64
After decompression, make sure to include the following files:

  • bin
  • data
  • include
  • lib
  • README

2. Install MySQL

1. Create a configuration file

Next, we need to create a configuration file to set the basic parameters of MySQL. Create a file named as follows:

[mysqld]
# MySQL server port
port=3306

# MySQL data directory
datadir=C:/-winx64/data

# Server character set
character-set-server=utf8mb4

# Default storage engine
default-storage-engine=INNODB

2. Initialize the database

Open a command prompt and navigate to MySQL's bin directory. Then run the following command to initialize the database:

cd C:\-winx64\bin
mysqld --initialize-insecure --user=mysql --datadir=C:\-winx64\data
  • The --initialize-insecure option will not set the root user's password, but it can be convenient for subsequent operations for the first time.

3. Start MySQL service

Next, you can start the MySQL service. Run the following command:
mysqld --console
This will start the MySQL server and display the running status in the command line window.

4. Connect to MySQL

Open another command prompt window, enter the bin directory of MySQL, and connect to MySQL using the following command:
mysql -u root
At this point you will connect to MySQL as root.

3. Create database and user

After connecting to MySQL, you can start creating databases and users. Execute the following SQL statement to create a database named testdb:
CREATE DATABASE testdb;
Next, create a new user and grant it access to testdb:

CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'password123';
GRANT ALL PRIVILEGES ON testdb.* TO 'testuser'@'localhost';
FLUSH PRIVILEGES;

4. View created databases and users

You can view all databases through the following SQL command:
SHOW DATABASES;
To view all users, you can run:
SELECT User, Host FROM ;

5. Frequently Asked Questions and Solutions

You may encounter some problems while using MySQL. The following table lists some common problems and their solutions:

question Solution
Unable to start MySQL service Check whether the path of datadir is correct
Connection refused Confirm that the firewall is not blocking port 3306 and ensure that MySQL is running
Login error Pay attention to whether the username and password are correct, use the -p mark to enter the password

6. Summary

Through the above steps, you have successfully installed and configured MySQL 8 on Windows. This allows you to develop, learn and test databases in your local environment.
MySQL 8 provides many new features, such as window functions, JSON multi-value indexing, etc., which are very suitable for modern application development. At the same time, by further learning SQL, you can help you understand the usage and principles of relational databases more deeply.

<Previous Next>