RockyLinux 9.5 MySQL5.7_二进制方式+jdk1.8+tomcat9+jpress

安装MySQL 5.7

# cd /opt
# yum install -y wget
# wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.10-linux-glibc2.5-x86_64.tar.gz
# tar -xvf mysql-5.7.10-linux-glibc2.5-x86_64.tar.gz
-bash: tar: command not found
# yum install -y tar
# tar -xvf mysql-5.7.10-linux-glibc2.5-x86_64.tar.gz
# mv mysql-5.7.10-linux-glibc2.5-x86_64 /usr/local/mysql
# cd /usr/local/mysql
# mkdir data
# groupadd mysql
# useradd -g mysql mysql
# cd ..
# chown -R mysql.mysql /usr/local/mysql/
# cd mysql

初始化，获得数据库密码
# ./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize

2025-01-03T05:44:51.316127Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2025-01-03T05:44:51.553889Z 0 [Warning] InnoDB: New log files created, LSN=45790
2025-01-03T05:44:51.580244Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2025-01-03T05:44:51.589440Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: d9f67bf9-c995-11ef-b98c-000c29e70719.
2025-01-03T05:44:51.590236Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2025-01-03T05:44:51.592125Z 1 [Note] A temporary password is generated for root@localhost: r.Lftrpee2S0

编辑配置文件
# vi /etc/my.cnf

[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
socket = /usr/local/mysql/mysql.sock
character-set-server=utf8
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
socket = /usr/local/mysql/mysql.sock
default-character-set=utf8
# cp -a /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql
# chmod +x /etc/rc.d/init.d/mysql
# cd /etc/rc.d/init.d/
# vi mysql

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

# yum install -y chkconfig

添加mysql服务
# chkconfig --add mysql
# chkconfig --list mysql

编辑全局环境配置

# vi /etc/profile

export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib
export PATH

# source /etc/profile

设置开机自启
# systemctl enable mysql
mysql.service is not a native service, redirecting to systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install enable mysql

查看服务状态
# systemctl status mysql
○ mysql.service - LSB: start and stop MySQL
Loaded: loaded (/etc/rc.d/init.d/mysql; generated)
Active: inactive (dead)
Docs: man:systemd-sysv-generator(8)
开启服务
# systemctl start mysql
# systemctl status mysql
● mysql.service - LSB: start and stop MySQL
Loaded: loaded (/etc/rc.d/init.d/mysql; generated)
Active: active (running) since Fri 2025-01-03 14:05:23 CST; 3s ago
Docs: man:systemd-sysv-generator(8)
Process: 25458 ExecStart=/etc/rc.d/init.d/mysql start (code=exited, status=0/SUCCESS)
Tasks: 28 (limit: 10874)
Memory: 347.1M
CPU: 685ms
CGroup: /system.slice/mysql.service
├─25469 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/localhost.localdoma>
└─25657 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plug>

Jan 03 14:05:22 localhost.localdomain systemd[1]: Starting LSB: start and stop MySQL...
Jan 03 14:05:23 localhost.localdomain mysql[25458]: Starting MySQL. SUCCESS!
Jan 03 14:05:23 localhost.localdomain systemd[1]: Started LSB: start and stop MySQL.

# reboot
# systemctl status mysql
& running状态 &

登录mysql修改密码
# mysql -uroot -p
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
解决办法：
# find / -name 'libncurses*'
/usr/lib64/libncurses.so.6
/usr/lib64/libncurses.so.6.2
/usr/lib64/libncursesw.so.6
/usr/lib64/libncursesw.so.6.2

# cd /usr/lib64
# ln -s libncurses.so.6.2 libncurses.so.5

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

设置mysql远程登录
mysql> use mysql;
mysql> update user set host='%' where user='root' limit 1;
mysql> flush privileges;
mysql> quit

放开防火墙
# firewall-cmd --zone=public --add-port=3306/tcp --permanent
# firewall-cmd --reload

数据库管理工具连接，成功。

安装JDK

访问官网，登录，下载jdk，上传到opt目录下
# cd /opt
# tar -xvf jdk-8u431-linux-x64.tar.gz
# mv jdk1.8.0_431/ /usr/local/java
# vi /etc/profile
export JAVA_HOME=/usr/local/java
export CLASSPATH=.:$JAVA_HOME/jre/lib/rt.jar:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export PATH=$PATH:$JAVA_HOME/bin
# source /etc/profile
验证
# java --version
# javac
# java

安装tomcat

cd /opt
下载tomcat
# wget https://dlcdn.apache.org/tomcat/tomcat-9/v9.0.98/bin/apache-tomcat-9.0.98.tar.gz
# tar -xvf apache-tomcat-9.0.98.tar.gz
# mv apache-tomcat-9.0.98 /usr/local/

设置开机自启
# vi /etc/rc.d/rc.local
export JAVA_HOME=/usr/local/java
/usr/local/apache-tomcat-9.0.98/bin/startup.sh
# chmod +x /etc/rc.d/rc.local

防火墙放开8080端口
# firewall-cmd --zone=public --add-port=8080/tcp --permanent
# firewall-cmd --reload

重启
# reboot

宿主机浏览器访问http://192.168.139.131:8080/

部署jpress

# cd /usr/local/apache-tomcat-9.0.98/webapps/
拖入jpress的war包，自动解压，改名为jpress。

连接数据库，新建名为jpress数据库。
宿主机浏览器访问http://192.168.139.131:8080/jpress/，填写数据库名：jpress,数据库用户密码，主机和端口号，下一步，填写网站标题等，完成，退回到后台登录页面。