centos安装redis、mysql、jdk，以及常见问题解决

一、为了提高安装速度，建议修改yum源

mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo_bak
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo
yum makecache
#yum -y update

二、安装redis

1.安装wget
    yum install wget -y
2.下载redis
    wget http://download.redis.io/releases/redis-7.2-rc2.tar.gz
3.解压并移动目录
    tar -zxvf redis-7.2-rc2.tar.gz
    mv redis-7.2-rc2 /usr/local/redis
4.编译安装Redis
    cd /usr/local/redis
    yum install gcc automake autoconf libtool make -y
    make distclean&make
    make install
5.修改配置文件密码
    vim /usr/local/redis/redis.conf
    requirepass 123456
    daemonize yes
6.配置开机启动
    echo "/usr/local/bin/redis-server /usr/local/redis/redis.conf &" >> /etc/rc.local
7.启动，测试
    /usr/local/bin/redis-server /usr/local/redis/redis.conf

 三、安装mysql，需要卸载系统自带的mariadb

rpm -qa | grep mariadb    #centos7默认安装了mariadb数据库
rpm -e mariadb-libs --nodeps  #卸载mariadb以免与MySQL冲突
yum -y install gcc gcc-c++ libaio-devel openssl openssl-devel m4 #安装编译器和依赖库

        #官网下载文件并上传
tar zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql
vim /etc/profile
        #最后添加

        #export PATH=$PATH:/usr/local/mysql/bin
source /etc/profile
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
chown -R mysql:mysql /usr/local/mysql
mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --pid-file=/usr/local/mysql/data/mysql.pid --tmpdir=/tmp
        #记住临时密码

        #A temporary password is generated for root@localhost: kk.BruS>Q6J#
vi /etc/my.cnf

        #添加以下内容

[mysqld]
port=3306
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
user=mysql
max_connections=200
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# 设置忽略大小写 
lower_case_table_names = 1
# 指定编码 
character-set-server=utf8
collation-server=utf8_general_ci
# 开启ip绑定 
bind-address = 0.0.0.0
default-storage-engine=INNODB
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER"
log_bin_trust_function_creators=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#指定客户端连接mysql时的socket通信文件路径
[client]
socket=/usr/local/mysql/mysql.sock
default-character-set=utf8

service mysqld start    
    #Centos7.9，需要执行以下命令，安装mysql服务，否则无法启动
    # cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
    # chkconfig --add mysqld
    # systemctl start mysqld
    # systemctl status mysqld

 四、安装jdk

        #官网下载文件并上传

tar  -zxvf  jdk-8u191-linux-x64.tar.gz
vim /etc/profile

        #最后添加以下内容
        export JAVA_HOME="/opt/jdk1.8.0_191"
        export PATH=$PATH:$JAVA_HOME/bin
source /etc/profile

 五、常见问题处理

1.添加防火墙端口

        firewall-cmd --list-ports

        firewall-cmd --zone=public --add-port=3306/tcp --permanent
        firewall-cmd --reload

2.数据库函数创建失败

        错误提示：This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

        临时解决办法：set global log_bin_trust_function_creators=TRUE;

        永久解决办法：在配置文件/etc/my.cnf的[mysqld]配置log_bin_trust_function_creators=1

3.事件不执行

        use mysql
        SELECT @@event_scheduler;
        SET GLOBAL event_scheduler = ON;
        永久生效：配置文件的[mysqld]部分加上event_scheduler=ON

4.mysql启动、关闭、重启方式

        service mysqld stop
        service mysqld start
        service mysqld restart
        service mysqld status

        systemctl restart mysqld
        systemctl status mysqld