Centos compile and install mysql

On Centos operating system, MySQL is a commonly used relational database management system. Scalable and manageable. MySQL has the characteristics of open source, high performance and strong reliability, and is widely used in web server applications and other data storage scenarios.

There are many ways to install MySQL under Centos, such as rpm package installation, yum installation, etc. However, these installation methods have many default configurations, which may be inconsistent with our needs. In order to better control and modify the MySQL configuration, Custom compilation and installation is the best choice.

This article will introduce how to compile and install MySQL through the source code package on the Centos operating system.

The steps are as follows:

1. Download the source code package

Download the MySQL source code package on the MySQL official website. You can choose to download the latest version of the source code package and download it to local.

2. Decompress the source package

Use the tar command to decompress the MySQL source package:

tar -zxvf mysql-8.0.25.tar.gz

Use the cd command to enter the decompressed directory:

cd mysql-8.0.25

3. Configure compilation options

After decompression, execute the following command to configure compilation options:

cmake .
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql
-DMYSQL_DATADIR=/usr/local/mysql/data
-DSYSCONFDIR=/etc
-DMYSQL_USER=mysql
-DWITH_MYISAM_STORAGE_ENGINE=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_ARCHIVE_STORAGE_ENGINE=1
-DWITH_BLACKHOLE_STORAGE_ENGINE=1
-DWITH_MEMORY_STORAGE_ENGINE=1
-DWITH_SSL=system
-DWITH_LIBWRAP =0
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock
-DDEFAULT_CHARSET=utf8mb4
-DDEFAULT_COLLATION=utf8mb4_general_ci
-DDOWNLOAD_BOOST=1
-DWITH_BOOST=/path/to/boost/

In the above command, "" is used for line break. You can write the entire command in one line.

Here is the meaning of each parameter:

CMAKE_INSTALL_PREFIX: Specify the installation directory as /usr/local/mysql.

MYSQL_DATADIR: The storage directory for MySQL data files is /usr/local/mysql/data. This directory name can be modified according to your own needs.

SYSCONFDIR: Specify the configuration file storage directory as /etc.

MYSQL_USER: Specify the user required for MySQL to run as mysql.

WITH_MYISAM_STORAGE_ENGINE, WITH_INNOBASE_STORAGE_ENGINE, WITH_ARCHIVE_STORAGE_ENGINE, WITH_BLACKHOLE_STORAGE_ENGINE and WITH_MEMORY_STORAGE_ENGINE: These parameters are used to determine whether MySQL needs to be compiled to support the storage engine. If necessary, set the value of this parameter to 1, otherwise set to 0.

WITH_SSL: Specify whether SSL support is required when compiling MySQL. We set it to system here, so that the compiled MySQL will use the SSL library that comes with the operating system (Centos).

WITH_LIBWRAP: Specifies whether to compile libwrap. This parameter is generally set to 0.

MYSQL_UNIX_ADDR: Specify the location of MySQL's UNIX socket file, here set to /var/lib/mysql/mysql.sock.

DEFAULT_CHARSET: Specifies the default character set of MySQL, here it is set to utf8mb4.

DEFAULT_COLLATION: Specify the default collation of MySQL, here set to utf8mb4_general_ci.

DOWNLOAD_BOOST and WITH_BOOST: MySQL8 depends on the boost library. If there is no boost library locally, you need to download and compile it through DOWNLOAD_BOOST and WITH_BOOST.

4. Compile and install

After completing the configuration, use the make command to compile:

make

Use the make install command to install:

make install

5. Start MySQL

After completing the installation, you can use the following command to start MySQL:

/usr/local/mysql/bin/mysqld - -initialize

Start the MySQL service:

systemctl start mysqld

Verify whether MySQL is installed successfully through the following command:

systemctl status mysqld

6. Set the MySQL root account

After MySQL is installed, you need to set the password of the root account. You can use the following command to set it:

mysqladmin -u root password "newpassword"

The "newpassword" in the above command is the new password set. To change an existing password, you can use the following command:

mysqladmin -u root -p oldpassword newpasswort

In the above command, "oldpassword" represents the existing password and "newpassword" represents the new password password.

7. Connect to MySQL

After the installation and configuration are complete, you can use the following command to connect to MySQL:

mysql -u root -p

In After entering this command, the system prompts for a password. You can enter the password of the root account to connect.

The above are the steps and precautions for compiling and installing MySQL on the Centos operating system. Compared with other installation methods, this method is more flexible and has more customizable space. In the case of changing needs, Provides more freedom.

The above is the detailed content of Centos compile and install mysql. For more information, please follow other related articles on the PHP Chinese website!