centos source code installation mysql

When using CentOS system for development or deployment, installing MySQL is a basic task. Although you can use the system's default package manager yum to install MySQL, in some cases (such as customizing compilation options, etc.), using source code to install MySQL is a more flexible option. This article will introduce how to install MySQL from source code on CentOS systems, including steps such as dependency installation, compilation and installation of MySQL.

1. Install dependencies

Before installing the MySQL source code, we need to install some dependencies. In the CentOS system, you can install it through the following command:

yum install -y gcc gcc-c++ make ncurses-devel cmake bison

Among them, the functions of each dependency are as follows:

• gcc, gcc-c: C, C compiler
• make: Compilation tool
• ncurses-devel: Provides ncurses library, including API for processing terminal input and output
• cmake: Compilation tool, used to generate Makefile files
• bison: Syntax analyzer generator, used for compiling MySQL source code

2. Download and decompress the MySQL source code

from the MySQL official website (https://dev.mysql. com/downloads/mysql/) to download the latest version of the MySQL source code package (tar.gz format), and select the appropriate platform version. This article takes version 5.7.32 as an example for demonstration. After the download is complete, use the following command to decompress the source code package:

tar -xzf mysql-5.7.32.tar.gz
cd mysql-5.7.32

3. Edit the compilation options

MySQL default compilation options do not necessarily meet our needs, so we need to edit the compilation options. After entering the MySQL source code directory in the previous step, use the following command to open the CMakeLists.txt file:

vim CMakeLists.txt

Find the following lines in the file:

# Settings for a "typical" MySQL build, using all of the default components.
SET(VARIANTS a b c)
SET(BUILD_CONFIG "community")

Among them, the VARIANTS variable in the second line The compilation options of MySQL are defined, and we can use the following command to overwrite them to the compilation options we need:

SET(VARIANTS server)

In this way, MySQL will only compile server-side programs, excluding client programs and other components. In addition, we also need to modify the following two lines:

SET(DEFAULT_CHARSET "utf8")
SET(DEFAULT_COLLATION "utf8_general_ci")

Modify them respectively to:

SET(DEFAULT_CHARSET "utf8mb4")
SET(DEFAULT_COLLATION "utf8mb4_general_ci")

In this way, MySQL will use the utf8mb4 character set by default and support the storage of 4-byte unicode character.

4. Compile MySQL source code

After editing the compilation options, use the following command to generate the Makefile:

cmake .

After that, use the make command to compile MySQL:

make

The compilation takes a long time, please wait patiently. If you encounter an error during compilation, please fix it according to the error message.

5. Install MySQL

After successful compilation, use the following command to install MySQL:

make install

After successful installation, MySQL is installed in the /usr/local/mysql directory by default . We also need to perform some configuration operations:

cd /usr/local/mysql
chown -R mysql:mysql .
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
chown -R root .
chown -R mysql:mysql data
bin/mysqld_safe --user=mysql &

The meaning of the above commands is as follows:

• Use the chown command to attribute the ownership of the MySQL directory to the mysql user and mysql group;
• Use the mysqld command to initialize MySQL and generate a temporary password for the root user;
• Use the chown command again to attribute the ownership of the MySQL data directory to the mysql user and mysql group;
• Use the mysqld_safe command Start the MySQL service.

At this point, we have successfully installed and started the MySQL service.

6. Set the MySQL root user password

In the fifth step just now, MySQL generated a temporary password for the root user during initialization. We need to use this password to log in to MySQL and change the password of the root user:

bin/mysql -uroot -p

At this time, the system will prompt you to enter the password. We enter the temporary password we just generated. After successful login, use the following SQL to modify the root user password:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password';

Among them, your_new_password is the new password you set.

At this point, we have successfully completed the entire process of installing MySQL from source code on the CentOS system.

The above is the detailed content of centos source code installation mysql. For more information, please follow other related articles on the PHP Chinese website!