ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'oph5E3,jaud(';
sudo apt-get remove vim-common
sudo apt-get install vim
set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
sudo apt remove libcurl4
1. 安装 redis oph5E3,jaud(
2. 安装 mysql wrjPp2!cWO=!
3. 安装 clickhouse dd75e46256809c51583b
sudo service redis-server start
systemctl status mysql.service
USE mysql;
ALTER USER 'root'@'%' IDENTIFIED BY 'wrjPp2!cWO=!';
CREATE USER 'dianwo'@'localhost' IDENTIFIED BY 'wrjPp2!cWO=!';
GRANT ALL ON _._ TO 'dianwo'@'localhost';
FLUSH PRIVILEGES;
show variables like '%max_connect_errors%';
set global max_connect_errors=1000;
set global max_connections=1000;
set global interactive_timeout=300;
set global wait_timeout =300;
Start clickhouse-server with:
sudo clickhouse start
Start clickhouse-client with:
clickhouse-client --password
安装 jdk 17
安装 nginx
nohup java -jar --add-opens java.base/java.text=ALL-UNNAMED --add-opens java.base/java.io=ALL-UNNAMED --add-opens java.base/java.net=ALL-UNNAMED --add-opens java.base/java.lang=ALL-UNNAMED --add-opens java.base/java.math=ALL-UNNAMED --add-opens java.base/java.util=ALL-UNNAMED --add-opens java.base/java.util.concurrent=ALL-UNNAMED --add-opens java.sql/java.sql=ALL-UNNAMED -Xms2048m -Xmx2048m cv-dianwopt-web-6.0.0-SNAPSHOT.jar &
nohup java -jar --add-opens java.base/java.text=ALL-UNNAMED --add-opens java.base/java.io=ALL-UNNAMED --add-opens java.base/java.net=ALL-UNNAMED --add-opens java.base/java.lang=ALL-UNNAMED --add-opens java.base/java.math=ALL-UNNAMED --add-opens java.base/java.util=ALL-UNNAMED --add-opens java.base/java.util.concurrent=ALL-UNNAMED --add-opens java.sql/java.sql=ALL-UNNAMED -Xms2048m -Xmx2048m cv-socket-6.0.0-SNAPSHOT.jar &
wget http://nginx.org/keys/nginx_signing.key
sudo apt-key add nginx_signing.key
sudo sh -c 'echo "deb http://nginx.org/packages/mainline/ubuntu/ $(lsb_release -cs) nginx" >> /etc/apt/sources.list.d/nginx.list'
sudo apt-get update
sudo apt-get install nginx
sudo systemctl start nginx