生産環境安裝mysql5.7和redis4.0

mysql5.7安裝

1:安裝  
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
yum -y install mysql-server
systemctl start mysqld


2:找初始密碼：
# grep "temporary password" /var/log/mysqld.log 
2020-07-01T01:37:50.408894Z 1 [Note] A temporary password is generated for root@localhost: (<Cxcy</i3Wa


3:更改密碼：
[root@dev-base1  /root]
# mysql -u root -p
Server version: 5.7.30
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '3333333333';
Query OK, 0 rows affected (0.01 sec)


4:開啟遠端連接配接：
show databases;
use mysql;
show tables;
update user set Host='%' where User='root';
grant all privileges on *.* to root@"192.168.%" identified by "3333333333";
flush privileges;


5:配置預設編碼為utf8,忽略大小寫
vi /etc/my.cnf
# 添加 [mysqld] 
character_set_server=utf8 
init_connect='SET NAMES utf8'
lower_case_table_names=1


6:更改mysql安裝目錄：
先建立目錄
[root@dev-base1  /data]
# cd /data
# mkdir MySQLData
# chmod 777 /data/MySQLData
停止資料庫
# systemctl stop mysqld
複制資料目錄 & 備份原有資料目錄
# cp -R /var/lib/mysql /data/MySQLData
# mv /var/lib/mysql /var/lib/mysql_bak
# chown -R mysql:mysql /data/MySQLData
修改配置檔案：
# vim /etc/my.cnf
添加配置：
datadir=/data/MySQLData/mysql
socket=/data/MySQLData/mysql.sock
log-error=/data/MySQLData/mysql/mysqld.log
啟動資料庫&設定開機自啟
# systemctl restart mysqld
# systemctl enable mysqld



7:檢視啟動程序：
[root@dev-base1  /data/MySQLData]
# ps -ef |grep mysql
mysql     1183     1  1 10:06 ?        00:00:00 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
root      1213 62664  0 10:07 pts/0    00:00:00 grep --color=auto mysql



8:登入測試：
[root@dev-base1  /data/MySQLData]
# mysql -u root -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
解決mysql.sock問題：
[root@dev-base1  /data/MySQLData]
# mkdir -p /var/lib/mysql
[root@dev-base1  /data/MySQLData]
# ln -s /data/MySQLData/mysql.sock /var/lib/mysql/mysql.sock
[root@dev-base1  /data/MySQLData]
# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.30 MySQL Community Server (GPL)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>            

redis4.0安裝

1:安裝
[root@dev-base1  /root]
# wget http://download.redis.io/releases/redis-4.0.6.tar.gz
# tar xzf redis-4.0.6.tar.gz -C /usr/local/
# cd /usr/local
# mv redis-4.0.6 redis


2:編譯
# cd redis && make


3:軟連接配接執行指令
[root@dev-base1  /usr/local/redis/src]
# ln -s /usr/local/redis/src/redis-server /usr/local/bin/redis-server
[root@dev-base1  /usr/local/redis/src]
# ln -s /usr/local/redis/src/redis-cli /usr/local/bin/redis-cli


4:配置資料和日志目錄：
# mkdir -p /data/redis/{data,logs}


5:拷貝配置檔案模闆
[root@dev-base1  /usr/local/redis]
# cp redis.conf /data/redis/



6:更改配置檔案：
修改綁定位址和日志目錄，資料目錄
[root@dev-base1  /data/redis]
# vim redis.conf 
 bind 192.168.15.253
 logfile "/data/redis/logs/redos.log"
 dir /data/redis/data
 daemonize yes
 requirepass  3333333333


7:啟動redis
[root@dev-base1  /data/redis]
# redis-server redis.conf



8:加入開機自啟動
[root@dev-base1 /data/redis] vim /lib/systemd/system/redis.service
=========================
# 内容
[Unit]
Description=Redis persistent key-value database
After=network.target
After=network-online.target
Wants=network-online.target
[Service]
ExecStart=/usr/local/bin/redis-server /data/redis/redis.conf --supervised systemd
ExecStop=/usr/libexec/redis-shutdown
Type=notify
User=root
Group=root
RuntimeDirectory=redis
RuntimeDirectoryMode=0755
[Install]
WantedBy=multi-user.target
==========================
[root@dev-base1 /data/redis] systemctl daemon-reload
[root@dev-base1 /data/redis] systemctl start redis
[root@dev-base1 /data/redis] systemctl enable redis