Change the MYSQL password

From IVS Wiki
Jump to: navigation, search

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:
    Password5.png
  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
    Password3.png
  3. Enter the current password for the ivsadmin account.
    Password4.png
  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:
    Password2.png
  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
    Password3.png
  3. Enter the current password for the ivsadmin account.
    Password4.png
  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.