安装mysql数据库

  1. # 下载mysql源安装包
  2. wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
  4. # 安装mysql源
  5. yum localinstall mysql57-community-release-el7-8.noarch.rpm -y 
  7. # 检查mysql源是否安装成功
  8. yum repolist enabled | grep "mysql.*-community.*"
  10. # 安装MySQL
  12. yum install mysql-community-server -y 
  15. # 3、启动MySQL服务
  16. systemctl start mysqld
  18. # 查看MySQL的启动状态
  19. systemctl status mysqld
  22. #4、开机启动
  23. systemctl enable mysqld
  24. systemctl daemon-reload
  26. # 5、修改root本地登录密码
  27. # mysql安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码，然后登录mysql进行修改：
  28. grep 'temporary password' /var/log/mysqld.log
  29. mysql -uroot -p
  31. # mysql5.7默认安装了密码安全检查插件(validate_password)，默认密码检查策略要求密码必须包含：大小写字母、数字和特殊符号，
  32. # 并且长度不能少于8位。否则会提示ERROR 1819 (HY000): Your password does not satisfy the current policy requirements错误
  34. # 如果不需要密码策略，添加my.cnf文件中添加如下配置禁用即可：
  35. # 配置默认编码为utf8
  36. # 关闭客户端dns反解
  38. echo -e "validate_password = off\ncharacter_set_server=utf8\ninit_connect='SET NAMES utf8'\nskip-name-resolve\n" >> /etc/my.cnf 
  39. systemctl restart mysqld 
  41. mysql -uroot -p 
  47. ## 授权
  48. alter user 'root'@'localhost' identified by '123123';
  50. grant all privileges on *.* to root@'%' identified by '123123' with grant option;
  51. flush privileges;

安装Redis

  1. yum 安装redis 3.2
  3. yum -y install redis
  1. 文档 https://redis.io/download
  2. 编译安装redis-6.2.1
  6. yum install -y gcc gcc-c++ tcl
  8. wget  -O /opt/tgzs/redis-6.2.1.tar.gz https://download.redis.io/releases/redis-6.2.1.tar.gz
  9. cd /opt/tgzs/
  12. #解压redis
  13. tar xf redis-6.2.1.tar.gz
  14. #进入解压后的目录
  15. cd redis-6.2.1
  16. #分配器allocator，如果有MALLOC  这个 环境变量， 会有用这个环境变量的 去建立Redis。
  18. #而且libc 并不是默认的分配器， 默认的是 jemalloc, 因为 jemalloc 被证明 有更少的 fragmentation problems 比libc。
  20. #但是如果你又没有jemalloc而只有 libc 当然 make 出错。 所以加这么一个参数,运行如下命令：
  22. make MALLOC=libc -j 20
  24. #编译
  26. # make -j 20
  27. #创建redis安装目录，主要用于存放redis所需bin文件
  28. mkdir -p /usr/local/redis
  29. #安装redis并指定安装目录
  30. make PREFIX=/usr/local/redis/ install
  32. # 设置path
  33. export PATH=$PATH:/usr/local/redis/bin
  36. #复制默认配置文件到/etc
  37. egrep -v  "^$|#" redis.conf   > redis_sample.conf
  38. #修改配置文件监听IP为0.0.0.0，否则只能本地登录
  39. sed -i s/bind\ 127.0.0.1/bind\ 0.0.0.0/g redis_sample.conf
  40. #修改运行方式为后台运行
  41. sed -i s/daemonize\ no/daemonize\ yes/g redis_sample.conf
  44. /bin/cp -f redis_sample.conf /etc/redis_6379.conf 
  45. /bin/cp -f redis_sample.conf /etc/redis_6479.conf 
  47. #设置日志文件路径
  48. sed -i s@logfile\ \"\"@logfile\ \"/opt/logs/redis_6379.log\"@g /etc/redis_6379.conf 
  49. sed -i s@logfile\ \"\"@logfile\ \"/opt/logs/redis_6479.log\"@g /etc/redis_6479.conf 
  51. #设置数据目录
  52. sed -i s@dir\ \./@dir\ /var/lib/redis_6379@g /etc/redis_6379.conf 
  53. sed -i s@dir\ \./@dir\ /var/lib/redis_6479@g /etc/redis_6479.conf 
  55. # 修改port
  56. sed -i 's/port 6379/port 6379/g' /etc/redis_6379.conf 
  57. sed -i 's/port 6379/port 6479/g' /etc/redis_6479.conf 
  59. mkdir  /var/lib/redis_6379
  60. mkdir  /var/lib/redis_6479
  61. mkdir  /opt/logs
  63. cat <<EOF > /etc/systemd/system/redis_6379.service 
  64. [Unit]
  65. Description=The redis-server Process Manager
  66. After=syslog.target network.target
  68. [Service]
  69. Type=forking
  70. ExecStart=/usr/local/redis/bin/redis-server /etc/redis_6379.conf
  71. #ExecStop=/usr/local/redis/bin/redis-shutdown
  73. [Install]
  74. WantedBy=multi-user.target
  75. EOF
  77. cat <<EOF > /etc/systemd/system/redis_6479.service 
  78. [Unit]
  79. Description=The redis-server Process Manager
  80. After=syslog.target network.target
  82. [Service]
  83. Type=forking
  84. ExecStart=/usr/local/redis/bin/redis-server /etc/redis_6479.conf
  85. #ExecStop=/usr/local/redis/bin/redis-shutdown
  87. [Install]
  88. WantedBy=multi-user.target
  89. EOF
  91. systemctl daemon-reload
  92. #设置redis开机自启
  93. system enable redis_6379
  94. system enable redis_6479
  95. #启动redis
  96. systemctl restart redis_6379
  97. systemctl restart redis_6479
  98. #查看redis状态
  99. systemctl status redis_6379
  100. systemctl status redis_6479