备忘：mysql数据库建库及tomcat一些设置

>mysql -u root -p

>show databases;

--若没有新建一个
>CREATE DATABASE db1;

--使用数据库
>use library;

# 允许在172.16.0.1上登录
>create user 'alex'@'172.16.0.1' identified by 'password';

# 允许在172.16.0.X上登录
>create user 'alex'@'172.16.0.%' identified by 'password';

# 允许在任何ip上用户登录
>create user 'alex'@'%' identified by 'password';


# 指定任何ip的用户登录
grant all privileges on db1.t1 to "alex"@'%';

# 用户对db1数据库中的文件执行任何操作
grant all privileges on db1.* to "alex"@'%';

# 用户对所有数据库中文件有任何操作
grant all privileges on *.* to "alex"@'%';

# 刷新权限
>flush privileges;

 

=======================================================

# Set Java Envirement
export JAVA_HOME=/usr/lib/jvm/java-11-openjdk-amd64

# set Tomcat Envirement
export TOMCAT_HOME=/usr/local/tomcat

 

# 显示验证码

修改tomcat的bin目录下的catalina.sh文件

修改 line:252的

JAVA_OPTS="$JAVA_OPTS $JSSE_OPTS"

为下列内容（增加  -Djava.awt.headless=true）

JAVA_OPTS="$JAVA_OPTS $JSSE_OPTS -Djava.awt.headless=true"

 

===============================================================

Nignx上http自动跳转到https

适用于 80端口和443 配置在同一个 server{}内

if ($server_port = 80) {
    rewrite ^(.*)$ https://$host$1 permanent;
}

 

配置示例：

server {
    listen       80;
    server_name  www.test.com;
    rewrite ^ https://$http_host$request_uri? permanent;
}

server {
    listen 443;
    server_name www.22.cn;  

    ssl on;
    ssl_certificate /etc/ssl/cacert.pem;
    ssl_certificate_key /etc/ssl/privkey.pem;

    server_tokens off;
    location / {
        fastcgi_param   HTTPS               on;
        fastcgi_param   HTTP_SCHEME         https;
    }
}