- 安装nginx(1.1.16.1)
1.添加nginx地址
vim /etc/yum.repos.d/nginx.repo
2.然后把下面的内容添加进入
[nginx]
name=nginx repo
baseurl=http://nginx.org/packages/centos/$releasever/$basearch/
gpgcheck=0
enabled=1
3.然后可以看到已经存在nginx了
yum list |grep nginx
4.安装 ,下图为安装完成
yum install nginx
5.设置开机启动
systemctl enable nginx
7.nginx.conf位置
【nginx配置信息】 里面涵盖了 连接后台。前台的地址。
# For more information on configuration, see:
# * Official English Documentation: http://nginx.org/en/docs/
# * Official Russian Documentation: http://nginx.org/ru/docs/
user nginx;
worker_processes auto;
error_log /var/log/nginx/error.log;
pid /run/nginx.pid;
# Load dynamic modules. See /usr/share/nginx/README.dynamic.
include /usr/share/nginx/modules/*.conf;
events {
worker_connections 1024;
}
http {
log_format main '$remote_addr - $remote_user [$time_local] "$request" '
'$status $body_bytes_sent "$http_referer" '
'"$http_user_agent" "$http_x_forwarded_for"';
access_log /var/log/nginx/access.log main;
sendfile on;
tcp_nopush on;
tcp_nodelay on;
keepalive_timeout 65;
types_hash_max_size 2048;
client_max_body_size 500M;
gzip on;
gzip_disable "msie6";
gzip_proxied any;
gzip_min_length 1k; #最小压缩文件大小
gzip_comp_level 9; #压缩比率1--9
gzip_buffers 4 512k; #压缩缓冲区
gzip_types text/xml text/plain text/css application/javascript application/x-javascript application/rss+xml;
gzip_vary on; #前端服务缓存压缩
output_buffers 4 512k; #输出缓冲区
postpone_output 5460; #输出缓冲区
include /etc/nginx/mime.types;
default_type application/octet-stream;
# Load modular configuration files from the /etc/nginx/conf.d directory.
# See http://nginx.org/en/docs/ngx_core_module.html#include
# for more information.
include /etc/nginx/conf.d/*.conf;
server {
listen 80 default_server;
listen [::]:80 default_server;
server_name ms.shiyucapital.com;
root /usr/share/nginx/html;
# Load configuration files for the default server block.
# 引入其他的配置文件
include /etc/nginx/default.d/*.conf;
# 后台访问
location /test {
proxy_pass http://127.0.0.1:8082 ;
}
# 前台访问
location / {
alias D:/java/nginx-1.19.10/html/fundinvest;
try_files $uri $uri/ /index.html;
}
#前台页面
location /fundinvest {
alias D:/java/nginx-1.19.10/html/fundinvest;
try_files $uri $uri/ /fundinvest/index.html;
}
#配置文件服务器
location /file {
alias /home/test/; # 这里配置目录
autoindex on; ##显示索引
autoindex_exact_size off; ##显示大小
autoindex_localtime on; ##显示时间
}
error_page 404 /404.html;
location = /40x.html {
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
}
}
# Settings for a TLS enabled server.
#
# server {
# listen 443 ssl http2 default_server;
# listen [::]:443 ssl http2 default_server;
# server_name _;
# root /usr/share/nginx/html;
#
# ssl_certificate "/etc/pki/nginx/server.crt";
# ssl_certificate_key "/etc/pki/nginx/private/server.key";
# ssl_session_cache shared:SSL:1m;
# ssl_session_timeout 10m;
# ssl_ciphers HIGH:!aNULL:!MD5;
# ssl_prefer_server_ciphers on;
#
# # Load configuration files for the default server block.
# include /etc/nginx/default.d/*.conf;
#
# location / {
# }
#
# error_page 404 /404.html;
# location = /40x.html {
# }
#
# error_page 500 502 503 504 /50x.html;
# location = /50x.html {
# }
# }
}
- 安装mysql(5.7.27) 注意当前系统是Centos7
1.下载地址源
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
2.安装rpm -ivh mysql80-community-release-el7-3.noarch.rpm
3.进入yum路径
cd /etc/yum.repos.d/
4.修改5.7源,5.7改为1, 8.0的改为0
vi mysql-community.repo
5.查看服务器已经变更为5.7.27 (如果未看到server的话,报错的话,请看 第6点中的错误信息)
6.安装服务 ()
yum install mysql-community-server
6.1## 如果执行失败,提示下面的错误,则执行 yum module disable mysql 然后在执行安装
[root@iZ8vb2qq48tw3ansr77wrjZ yum.repos.d]# yum install mysql-community-server
Last metadata expiration check: 0:02:08 ago on Thu 24 Dec 2020 11:02:32 AM CST.
All matches were filtered out by modular filtering for argument: mysql-community-server
Error: Unable to find a match: mysql-community-server
7.mysql初始化
mysqld --initialize --user=mysql
注意:如果是mysql8的话 ,请勿执行上面的,需要执行下面的这个 。
mysqld --initialize --user=mysql --lower-case-table-names=1
mysql8中执行完毕之后,还必须要在配置文件中加上lower-case-table-names=1 才能启动服务。
vim /etc/my.cnf 加在【mysqld】下面
8.查看密码位置
vi /var/log/mysqld.log
9.启动mysql
systemctl start mysqld
10.配置mysql开机启动
命令:systemctl enable mysqld
命令:systemctl daemon-reload
11.登陆mysql
Mysql -uroot -p输入密码
12.修改密码
ALTER USER USER() IDENTIFIED BY '新密码';
13.修改mysql的配置文件中信息
命令:vim /etc/my.cnf
加入如下配置信息:
[mysqld]
character_set_server = utf8
max_allowed_packet=500M
max_connections=1000
#加入下面一行会不分库名的大小写
lower_case_table_names=1
#下面的这个需要写,不然mysql5.7中排序会报错
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO
注意:如果是mysql8中 sqlmodel中 已经取消了 下面这两个属性,则需要删除
"NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
因此在mysql8 中不能加入这两个参数属性。
plugin-load=validate_password.so
validate_password_policy=0
validate-password=FORCE_PLUS_PERMANENT
14重启mysql
Systemctl restart mysqld
15、如果远程链接提示x下图 ,则登录mysql后,执行
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'asd!@123';
FLUSH PRIVILEGES;
#创建数据库
CREATE DATABASE `数据库名称` CHARACTER SET utf8 COLLATE utf8_general_ci;
创建用户
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
#授权用户
GRANT ALL privileges ON 数据库名称.表 TO 'user'@'%'
重置密码
set password for root@localhost = password('123456);
15.mysql的配置文件中数据存储路径已经改为了(如果不更改mysql存储位置,则安装完成了。此步骤可以跳过
如果mysql的存储位置要更改的话,更改路径之后,要给所在路径给mysql用户授权。如果再次启动mysql提示sock问题,则请断开xshell设备,重新连接,在启动mysql即可,如果还不行,在请reboot一下服务器即可。)
#datadir=/var/lib/mysql
datadir=/data/mysql/mysql
#socket=/var/lib/mysql/mysql.sock
socket=/data/mysql/mysql/mysql.sock
执行授权
chmod -R 777 /data/mysql
16.注意,如果平常mysql突然停机的时候造成无法启动
请在 /etc/my.cnf中 增加如下配置。
[mysqld]
innodb_force_recovery = 1
然后重新启动mysql。启动完成之后,需要把这个配置删除,然后重新再次启动mysql
17、mysql开启备份 ,用shell脚本
#!/bin/sh
filename=`date +%Y%m%d%H%M`
base_dir=/home/liuxiaodian
mysqldump -u root -p12312312 mydatabase >>$base_dir/database_$filename.sql
echo "$(date '+%Y-%m-%d %H:%M:%S') 备份完成" >> $base_dir/test.log
tar -zcvf $base_dir/database_$filename.tar.gz $base_dir/database_$filename.sql $base_dir/test.log
rm -rf $base_dir/database_$filename.sql $base_dir/test.log
find $base_dir -name "database_*" -type f -mtime +30 -exec rm {} \;
执行 contab -e (每天凌晨3点备份)
0 3 * * * /home/backup/shell/backup.sh
比如说需要复制到另外的一个位置 【yes命令会把后面的都设置为yes】
不然cp命令会询问是否覆盖
yes | cp -rf /data/backup/databases/data /data/databaseBackup
创建用户并授权
CREATE USER 'user'@'%' IDENTIFIED BY '密码';
GRANT ALL ON 数据库名.* TO 'user'@'%';
- 安装jdk 1.7 80
1.新建文件夹路径
mkdir /usr/local/jdk
2.然后把包上传到这个位置,进行解压
tar -xvf jdk-7u80-linux-x64.tar.gz
3.解压后的文件夹如下
4、配置环境变量
vi /etc/profile
增加如下代码
export JAVA_HOME=/usr/local/jdk/jdk1.7.0_80
export PATH=$JAVA_HOME/bin:$PATH
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export JRE_HOME=$JAVA_HOME/jre
5.保存退出
:wq
6.配置文件生效
source /etc/profile
7.输入 java -version如图则完成
- 安装tomcat
1.新建文件夹路径
mkdir /usr/local/tomcat7
2.把tomcat上传到此位置,解压
tar -xvf apache-tomcat-7.0.96.tar.gz
3.将文件传到如下路径
/usr/local/tomcat7/apache-tomcat-7.0.96/webapps
4.启动
sh /usr/local/tomcat7/apache-tomcat-7.0.96/bin/startup.sh
5.查看启动情况
tail -f /usr/local/tomcat7/apache-tomcat-7.0.96/logs/catalina.out
- 安装openoffice
1.创建文件夹
mkdir /usr/local/openoffice
2.上传安装文件到这里,并解压
tar zxvf openoffice.tar.gz
3.进入文件夹
cd zh-CN/RPMS
4.安装
yum localinstall *.rpm
5.进入子文件夹,继续安装
cd desktop-integration
yum localinstall *.rpm
安装完毕,
后台启动
nohup /opt/openoffice4/program/soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;" -nofirststartwizard &
查看服务是否启动(端口8100是否被soffice占用):
netstat -lnp |grep 8100
tcp 0 0 127.0.0.1:8100 0.0.0.0:* LISTEN 28871/soffice.bin
完成!
设置开机自启
vim /opt/openoffice4/start.sh
#!/bin/bash
nohup /opt/openoffice4/program/soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;" -nofirststartwizard &
vim /etc/rc.local
/opt/openoffice4/start.sh