mysql centos source code installation

MySQL is a popular open source relational database management system that can provide efficient, reliable, and secure data storage and access. CentOS is an open source operating system based on the Linux kernel and can be used as the operating environment for MySQL. This article will introduce the steps to install MySQL through source code compilation on CentOS.

Step 1: Install the compilation tool

Install the compilation tool on CentOS so that you can compile the source code of MySQL.

yum install -y gcc-c++ cmake make

Step 2: Download the MySQL source code package

Enter the MySQL official website (https://dev.mysql.com/downloads/mysql/) to download the corresponding version of the source code package and upload it to the CentOS server.

Step 3: Unzip the source code package

Extract the downloaded MySQL source code package to the specified directory (for example, /usr/local/src/mysql-8.0.25).

tar -zxvf mysql-8.0.25.tar.gz -C /usr/local/src/

Step 4: Install required libraries

yum install -y zlib-devel openssl-devel ncurses-devel bison-devel

Step 5: Create MySQL user

Create a user and group for MySQL.

groupadd mysql
useradd -r -g mysql mysql

Step 6: Configure MySQL

Enter the MySQL source code directory and configure it according to the actual situation.

cd /usr/local/src/mysql-8.0.25
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql 
-DMYSQL_DATADIR=/usr/local/mysql/data 
-DSYSCONFDIR=/etc 
-DMYSQL_TCP_PORT=3306 
-DWITH_INNOBASE_STORAGE_ENGINE=1 
-DWITH_ARCHIVE_STORAGE_ENGINE=1 
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 
-DWITH_MEMORY_STORAGE_ENGINE=1 
-DWITH_PARTITION_STORAGE_ENGINE=1 
-DWITH_READLINE=1 
-DENABLED_LOCAL_INFILE=1 
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock 
-DDEFAULT_CHARSET=utf8 
-DDEFAULT_COLLATION=utf8_general_ci

Description:

• --prefix: installation location
• --datadir: database data file storage directory
• --sysconfdir: configuration File storage directory
• --with-innodb: supports InnoDB storage engine
• --with-archive-storage-engine: supports Archive storage engine
• --with-blackhole -storage-engine: Support Blackhole storage engine
• --with-memory-storage-engine: Support Memory storage engine
• --with-partition-storage-engine: Support Partition storage engine
• --with-readline: Use the readline library to support command line editing
• --enable-local-infile: Support loading data from local
• --without-server: No Compile MySQL server
• --without-client: Do not compile MySQL client

Step 7: Compile and install MySQL

Use the make command to compile the MySQL source code, And use the make install command to install MySQL.

make
make install

Step 8: Configure the MySQL service

Use the following commands to initialize the configuration and start the MySQL service.

cd /usr/local/mysql/bin
./mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
./mysqld_safe --user=mysql &

Step 9: Set the MySQL root password

mysqladmin -u root password 'new-password'

Step 10: Test whether MySQL is successfully installed

Use the following command to test whether MySQL is successfully installed.

mysql -u root -p

If the returned result contains Welcome to the MySQL monitor information, it means that MySQL has been successfully installed and can be used normally.

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