1. mkdir /usr/set-up-pack

1.Java

  1. # 下载
  2. https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
  3. # 解压
  4. tar -xf jdk-8u251-linux-x64.tar.gz
  5. # 移到你想安装的地方，并重命名
  6. mv jdk1.8.0_251 /usr/local/java
  7. # 修改配置文件
  8. vi /etc/profile
  9. # 光标最后一行
  10. G
  11. # 进入插入模式
  12. i
  13. # 添加
  14.  # ↓这个路径要改，其余不需要改
  15. export JAVA_HOME=/usr/local/java
  16. export JRE_HOME=$JAVA_HOME/jre
  17. export CLASSPATH=$JAVA_HOME/lib:$JRE_HOME/lib:$CLASSPATH
  18. export PATH=$JAVA_HOME/bin:$JRE_HOME/bin:$PATH
  20. # 保存
  21. :wq
  22. # 刷新环境变量
  23. source /etc/profile
  24. # 验证安装
  25. java -version

2.Nginx

安装

  1. # 解压
  2. tar -zxf nginx-1.18.0.tar.gz
  3. # 安装c语言编译依赖
  4. yum -y install gcc zlib zlib-devel pcre-devel openssl openssl-devel
  5. # 进入解压得文件夹下
  6. cd nginx-1.18.0
  7. # 因为是C语言开发的，所以要先编译一下
  8. ./configure --prefix=/usr/local/nginx --with-http_stub_status_module --with-http_ssl_module
  9. make
  10. # 执行安装->默认安装到/usr/local/nginx
  11. make install
  12. # 默认安装路径/usr/local/nginx
  13. cd /usr/local/nginx
  14. ll
  15. # 进入有二进制执行文件的文件夹中
  16. cd sbin/
  18. # 启动
  19. ./nginx
  20. # 重载配置
  21. ./nginx -s reload
  22. # 以指定配置文件启动nginx
  23. ./nginx -c /usr/local/nginx/conf/aaa-nginx.conf
  24. # 停止运行
  25. ./nginx -s stop
  26. ln -s ./nginx /usr/sbin/
  27. # 查找进程
  28. ps -ef | grep "nginx"
  29. ln -s /usr/local/nginx/sbin/nginx /usr/sbin/

日志配置

  1. # 分发网站配置
  2. mkdir /usr/local/nginx/conf-web/
  3. # https证书
  4. mkdir /usr/local/nginx/conf-ssl/
  6. # /usr/local/nginx/conf/nginx.conf
  7. vim /usr/local/nginx/conf/nginx.conf
  8. ...
  9. use epoll;
  10. ...
  11. log_format main 'IP：$remote_addr/$http_x_forwarded_for - 用户：$remote_user [$time_local] 请求内容:"$request" '
  12. ...
  13. include /usr/local/nginx/conf-web/*.conf;
  14. ...
  1. mkdir /usr/local/nginx/logs/halo-blog/
  2. touch /usr/local/nginx/conf-web/kuxiaoxin.com.conf
  3. vim /usr/local/nginx/conf-web/kuxiaoxin.com.conf
  4. # 分发案例
  5. server {
  6.   listen 80;
  7.   server_name kuxiaoxin.com www.kuxiaoxin.com;
  8.   access_log logs/halo-blog/halo-blog.nginx.access.log main;
  9.   error_log  logs/halo-blog/halo-blog.nginx.error.log;
  10.   #将http请求转发到https上
  11.   #rewrite ^(.*)$ https://$host$1 permanent;
  12.   location / {
  13.     proxy_pass http://127.0.0.1:9999;
  14.   }
  15. }

3.MySql

  1. tar -xf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
  2. mv mysql-5.7.31-linux-glibc2.12-x86_64 /usr/local/mysql/
  3. groupadd mysql
  4. useradd -M -g mysql -s /sbin/nologin mysql
  5. mkdir /usr/local/mysql-data/
  6. yum install -y libaio
  7. cd /usr/local/mysql/bin/
  8. ./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql-data/
  9. # 此处记录临时root密码-MTyOdeEc.3RU
  11. mkdir /usr/local/mysql/log/
  12. touch /usr/local/mysql/log/mysql.errlog
  13. # 修改配置
  14. vi /etc/my.cnf
  15. [mysqld]
  16. datadir=/usr/local/mysql-data
  17. socket=/tmp/mysql.sock
  18. symbolic-links=0
  19. [mysqld_safe]
  20. log-error=/usr/local/mysql/log/mysql.errlog
  21. pid-file=/usr/local/mysql-data/$hostname.pid
  23. # 给mysql用户设于权限
  24. chown -R mysql:mysql /usr/local/mysql/ /usr/local/mysql-data/
  26. # 启动：
  27. /usr/local/mysql/support-files/mysql.server start
  28. # 关闭：
  29. /usr/local/mysql/support-files/mysql.server stop
  30. # 登录
  31. /usr/local/mysql/bin/mysql -uroot -p
  32. # 修改密码
  33. set password for 'root'@'localhost'=password('xiaoxin');
  34. # 刷新mysql设置
  35. flush privileges;
  37. # 拷贝Mysql程序至服务文件夹中，并命名为mysql
  38. cp -a /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql
  39. vim /etc/init.d/mysql
  40. basedir=/usr/local/mysql/
  41. datadir=/usr/local/mysql-data/
  43. # 添加mysql服务
  44. chkconfig --add mysql
  45. # 查看mysql服务状态
  46. chkconfig --list mysql
  47. mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
  48. chkconfig命令主要用来更新（启动或停止）和查询系统服务的运行级信息
  49. 等级0表示：表示关机
  50. 等级1表示：单用户模式
  51. 等级2表示：无网络连接的多用户命令行模式
  52. 等级3表示：有网络连接的多用户命令行模式
  53. 等级4表示：不可用
  54. 等级5表示：带图形界面的多用户模式
  55. 等级6表示：重新启动
  56. 使用mysql服务的方式操作启停mysql服务：
  57. service mysql start #启动mysql服务器
  58. service mysql stop #关闭mysql服务器
  59. service mysql restart #重启mysql服务器
  61. # 将mysql可执行命令软连接到系统执行文件夹中，类似环境变量
  62. ln -s /usr/local/mysql/bin/* /usr/sbin/

Navcat 连接：https://www.cnblogs.com/blogforly/p/5997553.html、https://blog.csdn.net/qq_20143059/article/details/89642284

  1. # 方式一：指定用户授权（推荐）
  2. use mysql;
  3. show tables;
  4. select user, host from user;
  5. +---------------+-----------+
  6. | user          | host      |
  7. +---------------+-----------+
  8. | mysql.session | localhost |
  9. | mysql.sys     | localhost |
  10. | root          | localhost |
  11. +---------------+-----------+
  13. update user set host ='%' where user ='root';
  15. # 方式二：全局通过全IP（不推荐）
  16. GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;

分用户连接：https://www.cnblogs.com/faberbeta/p/mysql002.html
https://www.cnblogs.com/liuhaidon/archive/2019/09/12/11511129.html