Which version of MySQL database is recommended for openEuler-22.03-LTS-x86_64?

Help, which version of MySQL database is recommended for openEuler-22.03-LTS-x86_64?

Isn’t this supposed to be based on business scenarios, MySQL’s lifecycle, official support, or feature selection? Installing MySQL on openEuler (using pre-compiled binaries or compiling from source) poses no issues.

1 Like

How to install the MySQL database?

If the openEuler repository contains the final selected MySQL version (e.g., 8.0.44, 8.0.45, 8.0.46), you can directly install it using yum install -y.

If you choose a different version, you can install it using a pre-compiled binary package or by compiling from source. The official MySQL documentation provides detailed instructions: MySQL :: MySQL 8.4 Reference Manual :: 2 Installing MySQL

mysql不同的版本是不是需要有对应版本的my.cnf文件?

Most parameters are universal.

However, there are a few special cases—for example, MySQL 8.0 introduces new features, deprecates certain functionalities, and changes parameter names compared to MySQL 5.7. These differences can be referenced in the official MySQL documentation.

You can also set up the general configuration first, then look up and add specific settings as needed. If any parameter is incorrectly configured, MySQL will fail to start and log an error message.

还想请教一下,mysql5.7.44的版本是可以用的嘛

As far as I recall, both the 5.7 and 8.0 LTS versions have already reached end-of-life and are no longer receiving updates for features or security fixes. However, there are likely still many existing servers running these older versions.

The current latest LTS versions are 8.4 and 9.7, though 9.7 has just been released and probably isn’t widely adopted yet.

For detailed lifecycle information, check this: MySQL | endoflife.date

Wouldn’t the 8.4.4 version work then?