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

Database Hosting Preferences

 
administrator guidedatabase serversdatabasehostinglinux

Configuring Database and Database Users Prefixes

Whenever a Plesk user creates a new database, you can have Plesk
automatically add a prefix to the database name that will make it easier
to find databases owned by that user. The same is true for database user
names. You can have Plesk apply the prefix only to the database names,
only to the database user names, or to both. If you enable database name
or database user name prefixes, Plesk users will not be able to remove
them.

Note: After you make a change to these settings, the new settings are only
applied to databases and database users created after you make the
change. They are not applied retroactively to objects created
earlier.

To enable database name prefixes:

  1. Go to Tools & Settings > Database Hosting Preferences (under
    “Applications & Databases”).
  2. Select the radio button corresponding to the prefix you want to add:
    • Username adds the user’s login used to access Plesk followed
      by the underscore symbol as the prefix (for example, admin_ or
      johndoe_).
    • External ID of a subscription adds a special external ID as
      the prefix. The external ID must be configured beforehand,
      otherwise no prefix is added. You can assign an external ID to a
      subscription when you create
      it

      or change its
      settings

      via the API. Use the optional gen_setup > external-id
      node.
  3. Click OK.

To enable database user name prefixes:

  1. Go to Tools & Settings > Database Hosting Preferences (under
    “Applications & Databases”).
  2. Select the Add username and underscore to the beginning of database
    user names
     checkbox, and then click OK.

This will add the user’s login used to access Plesk followed by the
underscore symbol as the prefix (for example, admin_ or
johndoe_).

Configuring the Default Remote Access Policy for MySQL Database Users

You can also configure the default remote access policy for MySQL
database users (this setting does not affect PostgreSQL or Microsoft SQL
database users). The chosen value will be used for all newly created
MySQL users, but will not affect existing MySQL users. Note that
customers whose subscriptions are granted the “Remote access for
database users” permission will be able to change this setting on a
per-user basis.

image 74989

Note: (Plesk for Linux) The selected “Allow remote connections from any host”
option affects only the users’ permissions and
does not enable remote access to the local MySQL server.
To enable remote access to the local MySQL server,
click the “Local MySQL Settings” link,
select the “Allow local MySQL server to accept external connections”
checkbox, and then click OK.

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

Securing the WordPress Frontier with WP Guardian

Read More »

Introducing WP Guardian Vulnerability Protection: Now available for WP Toolkit

Read More »

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

Read More »
Knowledge Base

The Plesk Firewall (Linux)

Read More »

(Plesk for Linux) Mailbox Quota Notifications

Read More »

Greylisting (Linux)

Read More »

(Plesk for Linux) Cgroups Manager – Configuring the Cgroups Manager

Read More »

Hosting Wiki

  • Server Redundancy
  • Linux Containers
  • PostgreSQL
  • Bare Metal Server
  • MySQL
  • Oracle VM Server
  • Server Virtualization Software
  • Windows Server
  • Linux
  • MSSQL
  • SQL
  • Hosting Control Panel
  • SQL database
  • NoSQL Database
  • Web Server
  • DNS Server
  • Colocation Hosting
  • Reseller Hosting
  • Cloud Hosting
  • VPS Hosting
  • Dedicated Hosting
  • Shared Hosting
  • Free Hosting
  • Managed Hosting
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