jellyfina/lnmp repository overview

Linux alpine：3.19.1
Nginx：1.24.0
MySQL（MariaDB）：10.11.6
PHP（php-fpm）：8.2.18
phpMyAdmin：5.2.1

docker run -it --name lnmp -p 3306:3306  -p 8080:80 -v $pwd/mysql:/app/mysql jellyfina/lnmp

 http://ip:端口/phpmyadmin/ 或者 http://域名:端口/phpmyadmin/

docker exec -it lnmp sh

mysqladmin -u root password "123456"

mysql -h localhost -u root -p

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

CREATE DATABASE test1;

GRANT ALL PRIVILEGES ON test.* TO 'newuser'@'localhost';

GRANT ALL PRIVILEGES ON test.* TO 'newuser'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';

FLUSH PRIVILEGES;

mysqldump -u root -p test > test_backup.sql

mysql -u root -p test < test_backup.sql