Article ID: 116445, created on Jul 15, 2013, last review on Nov 13, 2014

  • Applies to:
  • Operations Automation 5.5
  • Operations Automation 5.4

Symptoms

Provider wants to change admin password on a POA-managed Microsoft SQL, MySQL or PostgreSQL server without affecting customers' service provisioning on a server.

Resolution

Follow the steps below to change password of admin user on database server and in POA.

Microsoft SQL server

Just change password of the 'sa' user using MS SQL Server native tools like MS SQL Server Management Studio. POA does not use the 'sa' user for service provisioning purposes.

MySQL server

Change password of the 'root' MySQL user on database server and then update it in POA Provider Control Panel:

  1. Open list of servers registered in POA depending on the type of database server:

    1. Physical server: 5.4: Deployment Director > Server Manager > Hardware Nodes 5.5: Infrastructure > Hardware Nodes
    2. VPS: 5.4: Service Director > Virtuozzo Manager > VPSs 5.5: Services > Cloud Infrastructure > VPSs
  2. Click on the needed MySQL server

  3. Switch to the 'Applications' tab

  4. Click on the MySQL5 (or MySQL4) application

  5. Switch to the 'General' tab

  6. Click 'Edit'

  7. Enter the new MySQL root password twice

  8. Click 'Submit'

PostgreSQL server

Change password of the PostgreSQL admin user 'postgres' on a database server and then update it in POA Provider Control Panel:

  1. Open list of servers registered in POA depending on the type of database server:

    1. Physical server: 5.4: Deployment Director > Server Manager > Hardware Nodes 5.5: Infrastructure > Hardware Nodes
    2. VPS: 5.4: Service Director > Virtuozzo Manager > VPSs 5.5: Services > Cloud Infrastructure > VPSs
  2. Click on the needed PostgreSQL server

  3. Switch to the 'Applications' tab

  4. Click on the PgSQL or PgSQL9 application

  5. Switch to the 'General' tab

  6. Click 'Edit'

  7. Enter the new PostgreSQL admin password twice

  8. Click 'Submit'

Search Words

password

change mysql root password

PostgreSQL

change mysql system password

mysql

Error Host #441 does not exist.

MSSSQL

MySQL

SQL

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 5b048d9bddf8048a00aba7e0bdadef37 2554725ed606193dd9bbce21365bed4e ac82ce33439a9c1feec4ff4f2f638899

Email subscription for changes to this article
Save as PDF