mysql source code installation linux

MySQL is a free open source database management system that is widely used in Linux systems. This article will introduce the source code installation process of MySQL to help readers install MySQL and run it smoothly.

1. Download MySQL source code

The source code of MySQL can be downloaded from the official website of MySQL. Before downloading, you need to pay attention to the version number of the database and the system architecture. Downloading the correct version of the source code can ensure a successful installation.

2. Installing the compiler and dependency packages

Compilation of MySQL requires the use of the gcc compiler and some related dependency packages, such as zlib, openssl, cmake, etc. Before installation, you need to check whether these dependency packages are installed. In most Linux systems, these dependency packages are installed by default. However, if they are not installed, you can install them through the command line. For example, the command to install dependency packages in Ubuntu system:

sudo apt-get install build-essential cmake zlib1g-dev openssl libssl-dev

3. Unzip the source code package

After downloading the MySQL source code, you can unzip the compressed package to the appropriate directory. In this article, we unzip the source code to /usr/local.

4. Compile and install MySQL

After entering the MySQL source code directory, you can use the following command to compile and install MySQL:

cd /usr/local/mysql-5.7.28
cmake .
make && make install

Among them, the "." of cmake. Indicates that the current directory is passed into cmake as a parameter, and the Makefile required for compilation will be automatically generated. The make command will compile MySQL and you will need to wait from a few minutes to dozens of minutes. The specific length of time varies according to the computer hardware configuration. Finally, make install will install MySQL into the default installation directory (usually /usr/local/mysql).

5. Configure MySQL environment variables

In order to facilitate the use of MySQL, you need to configure some environment variables after the installation process. Edit the /etc/profile file and add the following lines at the end:

export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin

After saving and exiting, use the following command to make the environment variables take effect:

source /etc/profile

6. Initialize MySQL

After completing the compilation and installation, MySQL still needs to be initialized. First, you need to modify the MySQL configuration file my.cnf and set some properties of the database, such as listening address, port, character encoding, etc. Here you choose to use the vim editor to edit the my.cnf file:

cd /usr/local/mysql
cp support-files/my-default.cnf /etc/my.cnf
vim /etc/my.cnf

in my.cnf Add the following content to the file:

[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
port=3306
bind-address=127.0.0.1
character-set-server=utf8

Among them, basedir is the installation path of MySQL, datadir is the storage path of the MySQL database, port is the default listening port of MySQL, bind-address is the IP address of MySQL monitoring, character-set -server is the database character set. Save and exit after completing the modifications.

Next use the following command to initialize MySQL:

cd /usr/local/mysql
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

MySQL will generate a random password during initialization and save it in the MySQL log file. You can use the following command to view the password:

cat /usr/local/mysql/data/*-error.log | grep password

Use this password to log in to MySQL and change the password:

/usr/local/mysql/bin/mysql -uroot -p

Use the initial password you just obtained to log in to MySQL, and then change the password:

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

7. Start MySQL

Now, MySQL has been successfully installed and initialized. You can use the following command to start MySQL:

/usr/local/mysql/support-files/mysql.server start

If you are prompted for Permission denied, you need to change the permissions of the file:

chmod +x /usr/local/mysql/support-files/mysql.server

Then start MySQL:

/usr/local/mysql/support-files/mysql.server start

You can use the following command to verify MySQL Status:

/usr/local/mysql/support-files/mysql.server status

At this point, the MySQL source code installation has been completed. You can start using MySQL for database development work.

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