Difference between revisions of "Change the MYSQL password"

From IVS Wiki
Jump to: navigation, search
(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...")
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
−
==VALT 5.4 and Below==
+
__TOC__
−
====Update parameters.yml====
+
{{Article | content =
 +
==VALT 5.5 and Above==
 +
====Update .env.local====
 
# Connect to the server via SSH.
 
# Connect to the server via SSH.
−
# 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/.env.local</code>
−
# Locate the line for database_password:
+
# Locate the line for DATABASE_PASSWORD:
−
#: [[File:password2.png]]
+
#: {{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>
−
#: [[File:password3.png]]
+
#: {{img | file = password3.png}}
 
# Enter the current password for the ivsadmin account.
 
# Enter the current password for the ivsadmin account.
−
#: [[File:password4.png]]
+
#: {{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 17: Line 19:
 
# Enter the following command and press enter. <code>sudo /var/www/v3/assets.sh</code>
 
# Enter the following command and press enter. <code>sudo /var/www/v3/assets.sh</code>
 
# If prompted, enter the password for the ivsadmin account.
 
# If prompted, enter the password for the ivsadmin account.
−
==VALT 5.5 and Above==
+
 
−
====Update .env.local====
+
<hr>
 +
 
 +
==VALT 5.4 and Below==
 +
====Update parameters.yml====
 
# Connect to the server via SSH.
 
# Connect to the server via SSH.
−
# 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/app/config/parameters.yml</code>
−
# Locate the line for DATABASE_PASSWORD:
+
# Locate the line for database_password:
−
#: [[File:password5.png]]
+
#: {{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>
−
#: [[File:password3.png]]
+
#: {{img | file = password3.png}}
 
# Enter the current password for the ivsadmin account.
 
# Enter the current password for the ivsadmin account.
−
#: [[File:password4.png]]
+
#: {{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 35: Line 40:
 
# Enter the following command and press enter. <code>sudo /var/www/v3/assets.sh</code>
 
# Enter the following command and press enter. <code>sudo /var/www/v3/assets.sh</code>
 
# If prompted, enter the password for the ivsadmin account.
 
# If prompted, enter the password for the ivsadmin account.
 +
}}

Latest revision as of 10:53, 10 October 2023

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.
Retrieved from "https://ipivs.info/wiki/index.php?title=Change_the_MYSQL_password&oldid=12146"