一、为了提高安装速度,建议修改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 --reload2.数据库函数创建失败
错误提示: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=ON4.mysql启动、关闭、重启方式
service mysqld stop
service mysqld start
service mysqld restart
service mysqld statussystemctl restart mysqld
systemctl status mysqld