• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

MySQL database prefix is always "admin_"

B

benr77

Guest
Hi,

First post on the forum. Hello everyone.

I've got Plesk 9 up and running. I have a problem with creating MySQL databases. Whenever I try to create a database for a domain account, it forces me to have the prefix "admin_" rather than the name of the domain account?

How do I configure Plesk so that it allows me to create DB's for my domain accounts with the correct prefix?

Is this because they are domain accounts and not client accounts?

Thanks
Ben
 
Hello benr77,

First of all check 'Database hosting preferences' regarding allowed prefixes.
Also you can check 'misc' table in psa database for 'force_db_prefix' parameter.
I hope it will help.
 
You must log in or register to reply here.

Similar threads

M
Issue Outgoing Mail Control is always 0
Replies
1
Views
361
MarketPC
M
G
Issue restore database to mariadb 11.7.2 (Docker) create 500 exception
Replies
1
Views
381
gbailey123
G
M
Issue Database Connection Refused 10 mins after Deploy
Replies
1
Views
406
scsa20
scsa20
H
Resolved PostgreSQL Installed in Plesk but Not Selectable for Database Creation
Replies
1
Views
531
Sebahat.hadzhi
Sebahat.hadzhi
T
Issue mysqldump: Got error: 1932: "Table 'psa.WebsitesDiagnostic' doesn't exist in engine" when using LOCK TABLES
Replies
6
Views
624
TrevorM
T
Back
Top