Change the MYSQL password

VALT 5.5 and Above

Update .env.local

1. Connect to the server via SSH.
2. Enter the following command and press enter. nano /var/www/v3/.env.local
3. Locate the line for DATABASE_PASSWORD:

   

4. Change the password to the new password.

Update MYSQL User

1. Connect to the server via SSH.
2. Enter the following command and press enter. mysql -u ivsadmin -p

   

3. Enter the current password for the ivsadmin account.

   

4. At the mysql prompt enter the following command and press enter. ALTER USER 'ivsadmin'@'localhost' IDENTIFIED BY 'enteryournewpasswordhere';

Run assets.sh

1. Connect to the server via SSH.
2. Enter the following command and press enter. sudo /var/www/v3/assets.sh
3. If prompted, enter the password for the ivsadmin account.

---

VALT 5.4 and Below

Update parameters.yml

1. Connect to the server via SSH.
2. Enter the following command and press enter. nano /var/www/v3/app/config/parameters.yml
3. Locate the line for database_password:

   

4. Change the password to the new password.

Update MYSQL User

1. Connect to the server via SSH.
2. Enter the following command and press enter. mysql -u ivsadmin -p

   

3. Enter the current password for the ivsadmin account.

   

4. At the mysql prompt enter the following command and press enter. ALTER USER 'ivsadmin'@'localhost' IDENTIFIED BY 'enteryournewpasswordhere';

Run assets.sh

1. Connect to the server via SSH.
2. Enter the following command and press enter. sudo /var/www/v3/assets.sh
3. If prompted, enter the password for the ivsadmin account.