How to install MySQL 8.0 on Windows/Linux?

The key to installing MySQL 8.0 is to follow the steps and pay attention to common problems. It is recommended to use the MSI installation package on Windows. The steps include downloading the installation package, running the installer, selecting the installation type, setting the root password, enabling service startup, and paying attention to port conflicts or manually configuring the ZIP version; Linux (such as Ubuntu) is installed through apt, and the steps are to update the source, installing the server, running security scripts, checking service status, and modifying the root authentication method; no matter which platform, you should modify the default password, create ordinary users, set up firewalls, adjust configuration files to optimize character sets and other parameters to ensure security and normal use.

Installing MySQL 8.0 is actually not too difficult, but it is easy for beginners to have many steps and errors. Whether it is Windows or Linux, the key is to be clear about the purpose and operation method of each step to avoid getting stuck.

The following is a two platform to talk about how to install MySQL 8.0, focusing on the operation process and common precautions.

Install MySQL 8.0 on Windows

There are two main ways to install MySQL under Windows: use the MSI installation package or manually decompress the ZIP file. It is recommended to use MSI installation package, which is simple and intuitive, and is suitable for most users.

The main steps are as follows:

• Download the Windows MSI installation package for MySQL 8.0 (can be obtained from the official website)
• After double-clicking to run, follow the prompts to install step by step
• Select "Server Only" in the configuration interface or complete installation
• Remember to save the root user password
• Finally, you can choose to enable MySQL as a service to start automatically

During the installation process, you may encounter port conflicts or service startup failures. At this time, you can check whether other programs occupy port 3306, or try to run the installer as an administrator.

In addition, if you want to control the installation process more flexibly, you can also download the ZIP decompression version, but you need to manually configure the environment variables and services.

Install MySQL 8.0 on Linux (taking Ubuntu as an example)

Installing MySQL on Linux is usually faster, especially when using a package manager. Ubuntu is very convenient to install using apt:

The installation steps are as follows:

• Update the software source list: sudo apt update
• Install MySQL server: sudo apt install mysql-server
• After the installation is completed, run the secure initialization script: sudo mysql_secure_installation
• Follow the prompts to set root password and other security options

After the installation is completed, you can use systemctl status mysql to view the service status. If the service is not started, you can start it with sudo systemctl start mysql .

Sometimes, MySQL root users who have just installed use auth_socket to log in by default, and cannot directly enter their password to log in. At this time, you need to use sudo mysql -u root to log in and modify the authentication method of the root user to mysql_native_password .

Basic configuration suggestions after installation

No matter which platform it is, it is best to make some basic configuration after installation to improve security and ensure normal use.

• Change the default root password, do not use empty or weak passwords
• Create a normal user for daily operations instead of using root all the time
• Pay attention to the firewall settings when enabling remote access (Windows requires opening port 3306, Linux may need to adjust ufw or iptables)
• Modify configuration files (usually my.ini or my.cnf) to adjust advanced settings such as character sets, log paths, etc.

For example, adding the following to the configuration file can make the default encoding become utf8mb4:

 [client]
default-character-set=utf8mb4

[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

Basically that's it. Although there are many steps to install MySQL 8.0, it is not a big problem as long as you follow the process step by step. The key is to make some basic security settings after installation, and don't ignore these details.

The above is the detailed content of How to install MySQL 8.0 on Windows/Linux?. For more information, please follow other related articles on the PHP Chinese website!