当前位置：网站首页>mysql5.7 installation and deployment - yum installation

mysql5.7 installation and deployment - yum installation

2022-08-10 10:53:00 【InfoQ】


1. mysql installation method

In the centos environment, the mysql installation and deployment is mainly yum or binary package installation, and there are similar installation methods in other linux distributions, through the package managerInstallation is relatively easy.If it is a simple test, it can also be configured through docker, which is simpler.
To sum up, there are mainly the following installation and deployment methods
1. Package manager installation, yum or apt, etc.
2. Binary package installation
div>
3. Source code compilation and installation
4. Docker pulls the image for configuration
The following mainly introduces some simple configurations using yum to install in the centos environment

2. Installation package download

Configure yum repository download
Reference: https://dev.mysql.com/downloads/repo/yum/
Download the rpm package on the mysql official website, download address:
https://dev.mysql.com/downloads/mysql/
The above address can only see the latest stable version, the 5.7 version we want to download belongs to the old version, we need to find it in the historical archive
https://downloads.mysql.com/archives/community/
null
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.37-1.el7.x86_64.rpm-bundle.tar
tar -xvf mysql-5.7.37-1.el7.x86_64.rpm-bundle.tar
yum localinstall -y ./mysql-community-*.rpm

3. Simple configuration and initialization

rpm package is installedAfter that, the configuration file is in /etc/my.cnf, and the service configuration file is in /usr/lib/systemd/system/mysqld.service.

Modify the /etc/my.cnf configuration file
[[email protected]]
# This configuration section configures the parameters of the mysql instance of 3306, ifThere are multiple instances, such as adding a 3307 mysql, and adding a configuration section, refer to the following configuration and change it slightly

innodb_buffer_pool_size = 5000M

# The value of server_id, LANInside, the value of different instances should be set to different
server_id=106
#log_slave_updates=1

port = 3306
datadir=/home/my3306
socket=/home/my3306/mysql.sock
log-error=/home/my3306/mysqld.log
pid-file=/home/my3306/mysqld.pid
log_bin=mysql-201-binlog

# gitid is best to open
gtid_mode=ON
enforce-gtid-consistency=ON

max_connections=2048
slow_query_log=ON

binlog_format=row
skip-name-resolve

log-slave-updates=1
relay_log_purge=0
back_log=128
wait_timeout=60
interactive_timeout=7200
key_buffer_size=16M
#query_cache_size=64M
#query_cache_type=1
#query_cache_limit=50M
max_connect_errors=20
sort_buffer_size=2M
max_allowed_packet=32M
join_buffer_size=2M
thread_cache_size=200
innodb_buffer_pool_size=1024M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=32M
innodb_log_file_size=128M
innodb_log_files_in_group=3
binlog_cache_size=2M
max_binlog_cache_size=8M
max_binlog_size=512M
expire_logs_days=7
read_buffer_size=2M
read_rnd_buffer_size=2M
bulk_insert_buffer_size=8M
The data directory has been set up, the following is the new directory, authorization
mkdir -pv /home/my3306
chown -R mysql.mysql /home/my3306
start mysql
systemctl start [email protected]
# Note, not systemctl start mysqld, because mysql multi-instance should be considered later
Get initial password
cd /home/my3306
grep pass mysqld.log
Log in with the initial password, modify the root password, and authorize the user
mysql -uroot -S /home/my3306/mysql.sock -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '[email protected]';
New User Authorization
use mysql;
create user [email protected]'172.16.0.%' identified by '[email protected]';
grant all privileges on *.* to [email protected]'10.91.0.%' with grant option;
# or
grant all privileges on *.* to 'user02'@'172.16.0.%'identified by '[email protected]' with grant option;
grant all privileges on test.* to 'user03'@'172.16.0.%' identified by '[email protected]' with grant option;
grantselect on test.* to 'user04'@'172.16.0.%' identified by '[email protected]' with grant option;
You can authorize as needed
Note:The default password authentication encryption plugin for mysql 5.7 is still mysql_native_password.

The above completes the installation and deployment of mysql5.7.

mysql 3306 service management method is as follows
# Set the service to start up
systemctl enable [email protected]

# Restart the service
systemctl restart [email protected]

# Start
systemctl start [email protected]

# Stop
systemctl stop [email protected]
原网站

版权声明
本文为[InfoQ]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/222/202208101020461004.html

边栏推荐

猜你喜欢

随机推荐