Centos compile and install mysql

CentOS Compile and Install MySQL

MySQL is a popular relational database and one of the key components required for many web applications. CentOS is a widely used Linux distribution that provides a reliable platform on which MySQL can be installed and run. In this article, we will introduce how to compile and install MySQL on CentOS.

Step 1: Install dependent software

Before compiling and installing MySQL, you need to install some necessary software packages and tools. They can be installed via the following command on the terminal:

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

The above command will install the gcc-c, cmake, make, bison-devel and ncurses-devel packages. These are the necessary packages to compile MySQL.

Step 2: Download the MySQL source code

Before starting to compile and install MySQL, you need to download the MySQL source code from the MySQL official website. Please visit the following link to download the latest MySQL source code:

https://dev.mysql.com/downloads/mysql/

Select the corresponding version according to your needs, and then download the corresponding source code file.

Step 3: Unzip the MySQL source code

Once you download the MySQL source code, you need to unzip it. You can use the following command line to decompress:

$ tar zxvf mysql-x.x.x.tar.gz

where x.x.x represents the downloaded MySQL version number.

Step 4: Configure MySQL compilation options

Next, you need to configure the MySQL compilation options. You can configure MySQL by running the following command:

$ cd mysql-x.x.x
$ cmake 
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql 
-DMYSQL_DATADIR=/usr/local/mysql/data 
-DWITH_INNOBASE_STORAGE_ENGINE=1 
-DWITH_ARCHIVE_STORAGE_ENGINE=1 
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock 
-DMYSQL_TCP_PORT=3306 
-DENABLED_LOCAL_INFILE=1 
-DDEFAULT_CHARSET=utf8 
-DDEFAULT_COLLATION=utf8_general_ci 
-DWITH_BOOST=/usr/local/boost

In the above command, you need to make sure to change the MySQL version number that mysql-x.x.x unpacked for you, and execute these commands under it:

• -DCMAKE_INSTALL_PREFIX=/usr/local/mysql option specifies the installation location of MySQL. In this example, we installed MySQL in the /usr/local/mysql directory.
• -DMYSQL_DATADIR=/usr/local/mysql/data option specifies the MySQL data directory.
• -DWITH_INNOBASE_STORAGE_ENGINE=1 option enables the InnoDB storage engine.
• -DWITH_ARCHIVE_STORAGE_ENGINE=1 option enables the Archive storage engine.
• -DWITH_BLACKHOLE_STORAGE_ENGINE=1 option enables the Blackhole storage engine.
• -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock option specifies the location of the socket file.
• -DMYSQL_TCP_PORT=3306 option specifies the port number for MySQL.
• -DENABLED_LOCAL_INFILE=1 option enables loading data files from local. The
• -DDEFAULT_CHARSET=utf8 and -DDEFAULT_COLLATION=utf8_general_ci options specify the default character set and collation.
• -DWITH_BOOST=/usr/local/boost option specifies the location of the dependent Boost library. If you do not have the Boost library installed, you must install it before compiling MySQL.

Step Five: Compile and Install MySQL

You can compile and install MySQL by running the following command:

$ make && make install

This will compile and install MySQL. Depending on your server's configuration and performance, compiling and installing MySQL may take several minutes.

Step 6: Configure MySQL

Now, you need to configure MySQL. You can configure it by running the following command:

$ cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
$ cd /usr/local/mysql
$ chown -R mysql:mysql .
$ ./bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
$ ./bin/mysql_secure_installation

The above command will copy the MySQL default configuration file to /etc/my.cnf, initialize the MySQL data directory, and start the MySQL server.

Once MySQL is running, you can run the mysql_secure_installation command to further strengthen MySQL security, including changing the root user password.

Step 7: Start the MySQL server

You can start the MySQL server through the following command:

$ systemctl start mysqld

The above command will start the MySQL server. You can also set it as your system startup entry using the following command:

$ systemctl enable mysqld

This will automatically start the MySQL server at system startup.

Summary

Compiling and installing MySQL on CentOS may require some time and configuration work, but once completed, you will have a reliable relational database. Through the steps described in this article, you can easily compile and install MySQL and provide reliable back-end database support for your web applications.

The above is the detailed content of Centos compile and install mysql. For more information, please follow other related articles on the PHP Chinese website!