Search

Language:  

Available article translations:

How to change admin password for POA-managed database server

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: Deployment Director > Server Manager > Hardware Nodes

    2. VPS: Service Director > Virtuozzo Manager > 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: Deployment Director > Server Manager > Hardware Nodes

    2. VPS: Service Director > Virtuozzo Manager > 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'




FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No