mysql automatic installation

In the Internet era, data has become one of the most important resources for enterprises, and databases are increasingly used. As one of the most popular relational database management systems in the Internet field, the MySQL database system has become the preferred tool for data processing by many enterprises and institutions.

However, for beginners or non-professional technical personnel, the installation and configuration of MySQL has always been a more difficult problem. Because for these people, they often need to understand relevant basic knowledge, be familiar with the system environment, master some instructions, etc.

In order to simplify the installation of MySQL, automatically installing MySQL has become a very convenient and efficient solution. Next, we will introduce the installation method of MySQL from the perspective of automatic installation.

There are two ways to automatically install MySQL, one is through a script, and the other is through an installation package. Before installation, you need to prepare the download and installation package of MySQL. Download link: https://dev.mysql.com/downloads/mysql/.

Script automatic installation

Script automatic installation is relatively simple. You only need to prepare the script file. Most systems support script automatic installation.

The steps are as follows:

1. Open an editor, create a file named install_mysql.sh, add at the beginning:

#!/bin/bash

2. Set the version and download of mysql Link, as follows:

MYSQL_VERSION=5.7.27
MYSQL_URL=https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-$MYSQL_VERSION.tar.gz

3. Install the necessary software packages:

yum install -y libaio-devel numactl

4. Download and decompress the installation package, as follows:

wget $MYSQL_URL -O mysql.tar.gz
tar zxvf mysql.tar.gz

5. Create mysql user and user group, and set the user's password:

groupadd mysql
useradd -g mysql mysql
echo "123456" | passwd --stdin mysql

6. Create the MySQL installation directory, as follows:

mkdir -p /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql

7. Configure and compile MySQL, as follows:

cd mysql-$MYSQL_VERSION
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/data/mysql -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 -DENABLED_LOCAL_INFILE=1 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
make && make install

8. Initialize MySQL:

mkdir -p /var/run/mysqld
chown -R mysql:mysql /var/run/mysqld
cd /usr/local/mysql
scripts/mysql_install_db --user=mysql --datadir=/usr/local/data/mysql

9. Set the MySQL configuration file:

cp support-files/my-default.cnf /etc/my.cnf
sed -i 's,^log-error.*,log-error=/var/run/mysqld/mysqld.log,g' /etc/my.cnf
sed -i 's,^pid-file.*,pid-file=/var/run/mysqld/mysqld.pid,g' /etc/my.cnf

10. Start MySQL:

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

In this way, the automatic installation of MySQL is completed. In order for MySQL to start automatically after the system restarts, mysqld_safe needs to be added to the system startup script.

Automatic installation of installation packages

Automatic installation of installation packages is relatively complicated, but it is also more common, because many people like to install software programs through installation packages.

The steps are as follows:

1. Download the MySQL installation package.

2. Unzip the installation package and enter the unzipped folder. Execute the command:

rpm -ivh mysql57-community-release-el7-x.rpm

3. Update the software package warehouse and install the MySQL server:

yum update
yum install mysql-server

4. Set MySQL to start automatically and start MySQL:

systemctl enable mysqld
systemctl start mysqld

5. Set root User's password:

/usr/bin/mysql_secure_installation

Follow the prompts step by step to set the MySQL root password, delete anonymous users and test libraries, etc.

In this way, the process of automatically installing MySQL using the installation package is completed.

Conclusion

Automatically installing MySQL can make it easier for beginners or non-professional technical personnel to install MySQL. Most systems support automatic script installation and automatic installation of installation packages. Before performing any operation, download the appropriate version of the MySQL installation package, select the appropriate installation method according to your actual situation, and install it.

During the installation process, be sure to pay attention to the installation steps and check each step one by one to ensure the smooth progress of the installation. Finally, automating the installation of MySQL can not only simplify the operation process, but also ensure the quality and reliability of the installation.

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