How to install MySQL from source in CentOS

There are many ways to install MySQL on CentOS, the simpler way is to install it through local or other software sources. However, installing MySQL from source gives you more control over the details of the installation and allows you to customize settings more precisely, so it is an option. This article will introduce how to install MySQL from source in CentOS.

Prerequisites

Before installing the MySQL source code, you need to ensure that your operating system has the following software installed:

• gcc
• cmake
• make

If it is not installed, please use the following command to install it:

sudo yum install gcc cmake make

In addition, you also need to ensure that the following ports are not occupied, otherwise MySQL will Unable to install successfully:

• 3306 (MySQL default port)
• 3307 (MySQL default X Protocol port)
• 33060 (MySQL default X Protocol TLS/SSL port)
• 3308 (MySQL Router default port)

Get MySQL source code

Before installing the MySQL source code, you need to download the MySQL source code. In this article, we will use MySQL 8.0 as the installed version. You can choose to download the source code of version 8.0 on the download page of the MySQL official website.

You can use the wget command in the terminal to download the source code of MySQL 8.0 version:

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.25.tar.gz

Decompress the source code

After the download is completed, decompress the source code to the specified path:

tar -xvf mysql-8.0.25.tar.gz -C /usr/local/

The source code is decompressed to the /usr/local/mysql-8.0.25 directory.

Configuring the installation path

Since the default source code installation path of MySQL is /usr/src/mysql, but in this article, we use /usr/local/mysql-8.0.25 as the source code path. Therefore, you need to configure the installation path first.

First enter the /usr/local/mysql-8.0.25 directory and use the following command to enter the MySQL installation configuration mode:

cd /usr/local/mysql-8.0.25
sudo cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-8.0.25 -DMYSQL_DATADIR=/usr/local/mysql-8.0.25/data -DSYSCONFDIR=/etc

Among them:

• -DCMAKE_INSTALL_PREFIX= /usr/local/mysql-8.0.25 specifies the installation path of MySQL.
• -DMYSQL_DATADIR=/usr/local/mysql-8.0.25/data specifies the MySQL data storage path.
• -DSYSCONFDIR=/etc specifies the MySQL configuration file storage path.

Compile and install

After the installation configuration is successful, use the following commands to compile and install:

sudo make
sudo make install

After a while, MySQL will be compiled and installed to the specified directory.

Configuring MySQL

After the installation is completed, you can configure MySQL.

Enter the /usr/local/mysql-8.0.25 directory and execute the following command to initialize:

sudo bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql-8.0.25 --datadir=/usr/local/mysql-8.0.25/data

Among them:

• --initialize-insecure means using Unsafe way to initialize MySQL.
• --user=mysql Specifies the user mySQL runs as mysql.
• --basedir=/usr/local/mysql-8.0.25 Specifies the MySQL installation directory.
• --datadir=/usr/local/mysql-8.0.25/data Specifies the MySQL data directory.

In addition, you also need to use the following command for simple configuration:

sudo cp support-files/mysql.server /etc/init.d/mysql
sudo systemctl daemon-reload
sudo systemctl enable mysql
sudo systemctl start mysql

At this point, the MySQL source code installation is complete.

Summary

Source code installation of MySQL is an ideal way for customized and personalized needs. Of course, for novices, it is also easier to install using package management tools such as yum. No matter which installation method is used, as long as it can meet the needs, it is the best method.

During the process of installing MySQL from source code, you also need to pay attention not to cause conflicts with the ports, otherwise you will not be able to install it successfully. In addition, after installing MySQL, you also need to configure the installation path, data path and other information. These are also important things to pay attention to during the MySQL source code installation process.

The above is the detailed content of How to install MySQL from source in CentOS. For more information, please follow other related articles on the PHP Chinese website!