Database Password

1. Log in to the Database

To apply changes, you must first log in to the database. Use the appropriate command for your database:

docker exec -it marzneshin-db-1 mariadb -u root -p

docker exec -it marzneshin-db-1 mysql -u root -p

2. Change the Database Password

To change the password, run the following command:

ALTER USER 'root'@'%' IDENTIFIED BY 'NEW PASSWORD';
FLUSH PRIVILEGES;

3. Exit the Database

To exit the database, run the following command twice:

exit

4. Edit the Docker File

To change the password in the Docker file, run the following command:

nano /etc/opt/marzneshin/docker-compose.yml

Then, edit the following values:

SQLALCHEMY_DATABASE_URL: "mariadb+pymysql://root:NEWPASSWORD@127.0.0.1/marzneshin"
MARIADB_ROOT_PASSWORD: "NEW PASSWORD" 

SQLALCHEMY_DATABASE_URL: "mysql+pymysql://root:NEWPASSWORD@127.0.0.1/marzneshin"
MYSQL_ROOT_PASSWORD: "NEW PASSWORD" 

5. Restart Marzneshin

To apply the changes, restart Marzneshin using the following command:

marzneshin restart

Once you complete these steps, your database password will be changed.