mysql linux source code installation

MySQL is an open source relational database management system, commonly used in website development, data storage and other fields. On the Linux operating system, you can install and configure it through source code installation to achieve customized installation.

This article will introduce the specific steps and precautions for source code installation of MySQL on the Linux operating system.

1. Preparation

Before installing MySQL, you need to ensure that the build tools, dependency packages and other software have been installed in the Linux system. In commonly used Linux distributions, you can use software package management tools (such as yum, apt-get, etc.) to install it.

The following are common software package names, choose to install according to actual needs:

• GCC and G (C/C compiler)
• CMake (build tool)
• bison (parser generator)
• ncurses-devel (library for developing terminal applications)

You can check whether the package is installed using the following command , and use the corresponding package management tool to install it.

# 检查软件包是否已安装
rpm -qa | grep package_name

# 使用yum安装软件包
yum install package_name

# 使用apt-get安装软件包
apt-get install package_name

2. Download MySQL source code

MySQL official website provides various versions of source code downloads. In Linux systems, you can use the wget command to download.

# 下载最新版本的MySQL源码
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.22.tar.gz

3. Decompress the source code package

After the download is complete, use the tar command to decompress it.

# 解压源码包
tar -zxvf mysql-8.0.22.tar.gz

Next, enter the unzipped directory.

cd mysql-8.0.22

4. Configuration

Execute the following command to start preconfiguration:

cmake .

At this time, CMake will start to analyze the system and environment, and then generate the Makefile.

Running the above command may prompt that some dependencies are missing. If you encounter this situation, you need to install the missing dependencies and re-execute the command.

5. Compile

Execute the following command to start compilation:

make

During the compilation process, some warnings or errors may be prompted. It needs to be repaired according to the actual situation. After the repair is completed, you can re-execute the make command to compile.

6. Installation

Execute the following command to install:

make install

At this time, MySQL has been installed in the system. MySQL will be installed in the default directory: /usr/local/mysql.

7. Configure MySQL

In the MySQL installation directory, create a new my.cnf file to store the MySQL configuration.

cd /usr/local/mysql
touch my.cnf

Edit the my.cnf file and add the following content:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysql/mysql_error.log
pid-file=/var/run/mysql/mysql.pid

The above content indicates that MySQL data files are stored in the /var/lib/mysql directory, and log files are stored in /var/log /mysql/mysql_error.log file, the process ID is stored in the /var/run/mysql/mysql.pid file.

8. Start MySQL

If everything goes well, MySQL has been installed and the MySQL service can be started. Execute the following command to start the MySQL service:

/usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/my.cnf &

If you need to stop the MySQL service, execute the following command:

/usr/local/mysql/bin/mysqladmin -u root -p shutdown

9. Set the root user password

After the MySQL installation is completed, the initial state The root user does not have a password. Set the password of the root user through the following command:

/usr/local/mysql/bin/mysqladmin -u root password "new_password"

Replace "new_password" with the password you want to set.

At this point, the source code installation of MySQL on the Linux system is completed. Before using MySQL, you need to perform some related configurations, such as creating users, creating databases, etc. We can use MySQL client programs, such as the mysql command line tool, for management.

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