Skip to content
  • Solutions
    By Role
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    By Infrastructure
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
  • Product
    • Plesk Features
    • Plesk Editions
    • What’s new
    • Pricing
    • Roadmap
    • Lifecycle Policy
    • Extensions Catalogue
  • Pricing
  • Extensions
    Featured Extensions
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    Bundles and packs:
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack

    See all Extensions

  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
Plesk 360 login
Free Trial

Knowledge Base

How to switch the main (primary) IP address in the psa database on a Linux server that runs Plesk?

 
backupdatabaseiplinuxlinux server

Question

  • How to change the main (primary) IP address on a Plesk for Linux server?
  • Can I switch the IP address that is displayed in the System Overview section in Plesk for Linux?
  • Is it possible to adjust the IP address that is displayed in the System Overview section of the Plesk dashboard?

Answer

The IP address displayed in the System Overview section of the Plesk GUI is marked as the primary IP address in the Plesk database (psa).

Currently, a way to change what IP address is shown is not available via the Plesk GUI, however if you wish to have such a feature in Plesk in the future, you may vote for this feature suggestion on the following link:

Ability to set IP address on Plesk home page – Your Ideas for Plesk

For the moment, the only way to change the visible IP address is to update the corresponding database entries by following these steps:

1. Log into your server via SSH as the root user

Note: As a precaution, make a backup of the Plesk database (psa) by executing the following command:

# plesk db dump > /root/psa_dump"$(date -I)".sql

2. Access the Plesk database (psa):

# plesk db

3. Get a list of Plesk server IP addresses and their IDs:

# MariaDB [psa]> SELECT id, ip_address, main FROM IP_Addresses;
+----+-----------------------+-------+
| id | ip_address | main |
+----+-----------------------+-------+
| 1 | 203.0.113.2 | true |
| 2 | 2001:db8:f61:a1ff:0:0:0:80 | false |
+----+-----------------------+-------+

4. Change the main value of the current main IP address to false:

# MariaDB [psa]> UPDATE IP_Addresses SET main = 'false' WHERE id = '1';
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0

5. Set the main value of the new IP address that you wish to display in its place to true:

# MariaDB [psa]> UPDATE IP_Addresses SET main = 'true' WHERE id = '2';
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0

6. Check the IP addresses were updated correctly:

# MariaDB [psa]> SELECT id, ip_address, main FROM IP_Addresses;
+----+-----------------------+-------+
| id | ip_address | main |
+----+-----------------------+-------+
| 1 | 203.0.113.2 | false |
| 2 | 2001:db8:f61:a1ff:0:0:0:80 | true |
+----+-----------------------+-------+
2 rows in set (0.000 sec)

7. Exit the Plesk database editing screen:

# MariaDB [psa]> exit

Tweet
Share
Share
Email
0 Shares
Read the full article
Related Posts

How to Check Open Ports in Linux (Simple Commands & Tools)

Read More »

Linux Logs Explained

Read More »

How to Secure Your Linux Server: A Detailed Guide

Read More »
Knowledge Base

 An operation fails in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘X’ for key ‘PRIMARY’

Read More »

Plesk and websites are inaccessible after updating Plesk to Obsidian 18.0.43 on RHEL 8-based OS: DB query failed: SQLSTATE[HY000] [2002] No such file or directory

Read More »

Plesk Update fails: Table ‘mysql.innodb_index_stats’ doesn’t exist in engine

Read More »

Cannot remove IP address from Plesk server: The IP address 203.0.113.2 is already used for hosting

Read More »

Hosting Wiki

  • Server Redundancy
  • Linux Containers
  • Bare Metal Server
  • Backup
  • Oracle VM Server
  • Server Virtualization Software
  • Windows Server
  • Linux
  • JavaScript
  • Plesk
  • SQL database
  • NoSQL Database
  • Web Server
  • DNS Server
  • IPv6
  • IPv4
  • SIP
  • SSH
  • UDP/IP
  • TCP/IP
X-twitter Linkedin Youtube Reddit Github
  • Product
  • Login
  • Pricing
  • Editions
  • For Partners
  • Partner Program
  • Contributor Program
  • Affiliate Program
  • Plesk University
  • Company
  • Blog
  • Careers
  • Events
  • About Plesk
  • Our Brand
  • Resources
  • User and Admin guides
  • Help Center
  • Migrate to Plesk
  • Contact Us
  • Hosting Wiki
  • Forum
  • Legal
  • Legal
  • Privacy Policy
  • Imprint

© 2025 WebPros International GmbH

Part of the WebPros®  Family