linux mysql source code installation

Under the Linux system, MySQL is the most popular relational database management system. It is efficient, stable, safe, reliable, and easy to use. However, if you want some customization and optimization, source installation becomes a good choice. The following are detailed source code installation steps.

1. Preparation

Before starting to install MySQL from source code, you need to make several preparations.

First, you need to download the MySQL source code package. You can download the latest version of the source code package from the MySQL official website, or download it from the mirror site.

Then, you need to install some necessary software dependencies to avoid errors during the installation of MySQL. It is recommended to install the following software packages and development tools:

sudo apt-get update
sudo apt-get install build-essential
sudo apt-get install cmake
sudo apt-get build-dep mysql-server

2. Compile and install

Before compiling and installing MySQL, you need to unzip the source code package, enter the MySQL source code directory and execute the following command :

tar -zxvf mysql-5.7.17.tar.gz
cd mysql-5.7.17

Then, use CMake to compile the MySQL source code. Here we choose to install MySQL in the /usr/local/mysql directory and execute the following command:

cmake 
  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql 
  -DMYSQL_DATADIR=/usr/local/mysql/data 
  -DSYSCONFDIR=/etc 
  -DWITH_MYISAM_STORAGE_ENGINE=1 
  -DWITH_INNOBASE_STORAGE_ENGINE=1 
  -DWITH_ARCHIVE_STORAGE_ENGINE=1 
  -DWITH_BLACKHOLE_STORAGE_ENGINE=1 
  -DENABLED_LOCAL_INFILE=1 
  -DENABLE_DTRACE=0 
  -DDEFAULT_CHARSET=utf8 
  -DDEFAULT_COLLATION=utf8_general_ci 
  -DMYSQL_UNIX_ADDR=/var/run/mysqld/mysqld.sock 
  -DMYSQL_TCP_PORT=3306 
  -DWITH_SSL=bundled 
  -DWITH_ZLIB=system 
  -DWITH_LIBWRAP=0 
  -DEXTRA_CHARSETS=all 
  -DWITH_READLINE=1 
  -DWITH_EMBEDDED_SERVER=0 
  -DWITH_DEBUG=0 
  .

Among them, the parameter meaning is as follows:

-DCMAKE_INSTALL_PREFIX: Specify the installation path of MySQL.

-DMYSQL_DATADIR: Specify the data directory of the MySQL database.

-DSYSCONFDIR: Specify the MySQL configuration file path.

-DWITH_MYISAM_STORAGE_ENGINE: Enable the MyISAM storage engine.

-DWITH_INNOBASE_STORAGE_ENGINE: Turn on the InnoDB storage engine.

-DWITH_ARCHIVE_STORAGE_ENGINE: Enable Archive storage engine.

-DWITH_BLACKHOLE_STORAGE_ENGINE: Turn on the Blackhole storage engine.

-DENABLED_LOCAL_INFILE: Enable the function of importing data from local.

-DENABLE_DTRACE: Disable DTrace function.

-DDEFAULT_CHARSET: Set the default character set for MySQL.

-DDEFAULT_COLLATION: Set the default collation of MySQL.

-DMYSQL_UNIX_ADDR: Specifies the Unix socket file path for MySQL.

-DMYSQL_TCP_PORT: Specify the TCP port number that MySQL listens to.

-DWITH_SSL: Enable SSL support.

-DWITH_ZLIB: Enable Zlib support.

-DEXTRA_CHARSETS: Enable additional character sets.

-DWITH_READLINE: Enable Readline support.

-DWITH_EMBEDDED_SERVER: Disable the embedded server.

-DWITH_DEBUG: Turn off debug mode.

Note, if an error occurs during the execution of the CMake command, please check whether there are missing dependency packages.

After executing the CMake command, run the following command to compile:

make

After the compilation is completed, run the following command to install:

sudo make install

During the installation process, you need to enter the root username password.

3. Configuring MySQL

After the MySQL installation is completed, necessary configurations are required. First, execute the following command to create MySQL users and groups:

sudo groupadd mysql
sudo useradd -r -g mysql mysql

Then, execute the following command to initialize MySQL data:

cd /usr/local/mysql
sudo chown -R mysql:mysql .
sudo bin/mysqld --initialize-insecure --user=mysql

Among them, the --initialize-insecure parameter indicates using an empty password to initialize MySQL data.

Next, start the MySQL service and set the Root user password:

sudo bin/mysqld_safe --user=mysql &
sudo /usr/local/mysql/bin/mysqladmin -u root password 'newpassword'

The 'newpassword' here refers to the password you want to set. Please pay attention to password strength and security.

4. Start MySQL

After installing and configuring MySQL, we need to start the MySQL service:

sudo /etc/init.d/mysql start

You can use the following command to check whether the MySQL service has been started :

sudo netstat -tap | grep mysql

If you can see output similar to the following, it means that the MySQL service has been started:

tcp        0      0 localhost:mysql         *:*                     LISTEN      8537/mysqld

5. Verify MySQL

Finally, we need to verify Whether MySQL has been successfully installed and configured.

First, use the following command to log in to MySQL:

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

After entering the password, if you successfully log in to the MySQL command line interface, it means that MySQL has been successfully installed and configured.

Then, you can execute the following command to check the MySQL version:

SELECT VERSION();

If you can see the MySQL version number, it means that the MySQL installation is successful.

Summary

This article introduces the steps and precautions for using source code to install MySQL under Linux system. By installing from source, you can do more customization and configuration to suit your specific needs and environment. Of course, when installing source code, you need to pay attention to various dependency packages and configuration parameters to avoid errors. I hope this article can help you.

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