XServer VPSにredmine5.1.0を動かす方法

sudo dnf -y install httpd httpd-tools httpd-devel httpd-manual

sudo chown -R apache:apache /var/log/httpd/

sudo systemctl enable --now httpd

httpd -v
sudo systemctl status httpd

sudo dnf install https://dev.mysql.com/get/mysql80-community-release-el9-5.noarch.rpm
sudo dnf -y install mysql-community-server

sudo dnf install -y mysql-devel

dnf list installed | grep mysql

sudo touch /var/log/mysqld.log

sudo systemctl enable --now mysqld

mysql --version
sudo systemctl status mysqld

sudo grep 'temporary password' /var/log/mysqld.log
2024-03-30T06:41:02.125365Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: +kodwa!-&6Fj

sudo mysql_secure_installation
Enter password for user root: 
The existing password for the user account root has expired. Please set a new password.
New password: redMine,616
Re-enter new password: redMine,616
The 'validate_password' component is installed on the server.
The subsequent steps will run with the existing configuration
of the component.
Using existing password for root.
Change the password for root ? ((Press y|Y for Yes, any other key for No) : N
 ... skipping.
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
eload privilege tables now? (Press y|Y for Yes, any other key for No) : y
All done! 

mysql -uroot -p
Enter password: redMine,616

create database redmine default character set utf8;

show databases;

CREATE USER 'redmine'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Redmine616,r';
GRANT ALL ON redmine.* TO 'redmine'@'localhost';
exit