Difference between revisions of "Change the MYSQL password"
IVSWikiBlue (talk | contribs) (Created page with "==VALT 5.4 and Below== ====Update parameters.yml==== # Connect to the server via SSH. # Enter the following command and press enter. <code>nano /var/www/v3/app/config/paramete...") |
IVSWikiBlue (talk | contribs) |
||
| Line 4: | Line 4: | ||
# Enter the following command and press enter. <code>nano /var/www/v3/app/config/parameters.yml</code> | # Enter the following command and press enter. <code>nano /var/www/v3/app/config/parameters.yml</code> | ||
# Locate the line for database_password: | # Locate the line for database_password: | ||
| − | #: | + | #: {{img | file = password2.png}} |
# Change the password to the new password. | # Change the password to the new password. | ||
====Update MYSQL User==== | ====Update MYSQL User==== | ||
# Connect to the server via SSH. | # Connect to the server via SSH. | ||
# Enter the following command and press enter. <code>mysql -u ivsadmin -p</code> | # Enter the following command and press enter. <code>mysql -u ivsadmin -p</code> | ||
| − | #: | + | #: {{img | file = password3.png}} |
# Enter the current password for the ivsadmin account. | # Enter the current password for the ivsadmin account. | ||
| − | #: | + | #: {{img | file = password4.png}} |
# At the mysql prompt enter the following command and press enter. <code>ALTER USER 'ivsadmin'@'localhost' IDENTIFIED BY 'enteryournewpasswordhere';</code> | # At the mysql prompt enter the following command and press enter. <code>ALTER USER 'ivsadmin'@'localhost' IDENTIFIED BY 'enteryournewpasswordhere';</code> | ||
====Run assets.sh==== | ====Run assets.sh==== | ||
| Line 22: | Line 22: | ||
# Enter the following command and press enter. <code>nano /var/www/v3/.env.local</code> | # Enter the following command and press enter. <code>nano /var/www/v3/.env.local</code> | ||
# Locate the line for DATABASE_PASSWORD: | # Locate the line for DATABASE_PASSWORD: | ||
| − | #: | + | #: {{img | file = password5.png}} |
# Change the password to the new password. | # Change the password to the new password. | ||
====Update MYSQL User==== | ====Update MYSQL User==== | ||
# Connect to the server via SSH. | # Connect to the server via SSH. | ||
# Enter the following command and press enter. <code>mysql -u ivsadmin -p</code> | # Enter the following command and press enter. <code>mysql -u ivsadmin -p</code> | ||
| − | #: | + | #: {{img | file = password3.png}} |
# Enter the current password for the ivsadmin account. | # Enter the current password for the ivsadmin account. | ||
| − | #: | + | #: {{img | file = password4.png}} |
# At the mysql prompt enter the following command and press enter. <code>ALTER USER 'ivsadmin'@'localhost' IDENTIFIED BY 'enteryournewpasswordhere';</code> | # At the mysql prompt enter the following command and press enter. <code>ALTER USER 'ivsadmin'@'localhost' IDENTIFIED BY 'enteryournewpasswordhere';</code> | ||
====Run assets.sh==== | ====Run assets.sh==== | ||
Revision as of 10:01, 11 May 2022
Contents
VALT 5.4 and Below
Update parameters.yml
- Connect to the server via SSH.
- Enter the following command and press enter.
nano /var/www/v3/app/config/parameters.yml - Locate the line for database_password:
-
- Change the password to the new password.
Update MYSQL User
- Connect to the server via SSH.
- Enter the following command and press enter.
mysql -u ivsadmin -p -
- Enter the current password for the ivsadmin account.
-
- At the mysql prompt enter the following command and press enter.
ALTER USER 'ivsadmin'@'localhost' IDENTIFIED BY 'enteryournewpasswordhere';
Run assets.sh
- Connect to the server via SSH.
- Enter the following command and press enter.
sudo /var/www/v3/assets.sh - If prompted, enter the password for the ivsadmin account.
VALT 5.5 and Above
Update .env.local
- Connect to the server via SSH.
- Enter the following command and press enter.
nano /var/www/v3/.env.local - Locate the line for DATABASE_PASSWORD:
-
- Change the password to the new password.
Update MYSQL User
- Connect to the server via SSH.
- Enter the following command and press enter.
mysql -u ivsadmin -p -
- Enter the current password for the ivsadmin account.
-
- At the mysql prompt enter the following command and press enter.
ALTER USER 'ivsadmin'@'localhost' IDENTIFIED BY 'enteryournewpasswordhere';
Run assets.sh
- Connect to the server via SSH.
- Enter the following command and press enter.
sudo /var/www/v3/assets.sh - If prompted, enter the password for the ivsadmin account.
