Facebook
Twitter- Server operating system version
- Alma Linux 9.7
- Plesk version and microupdate number
- Obisidian 18.0.79 Update #4
We have a user account "website_AAA" and the site uses SQL database.
The SQL database that is used is named "dataBase_AAA" this works fine. this was imported from an old server.
We are trying to create a second database for the same account, but the Plesk GUI only allows "website_" as the database prefix.
We need the database prefix to be consistent, we need an ability to change the Prefix for this specific database.
Things tried:
1) We have tried to generate a placeholder database and then rename it in PhpMyAdmin, this fails as the user (who can work with "all" databases under the account according to Plesk GUI) can't access the renamed database:
2) We can find no other way of renaming specific databases under the account. And given the gaps in Plesk documentation on everything we really don't want to risk the system "renaming" the currently operational DB that exists.
So;
How do we rename the prefix for a specific database inside Plesk ?
The SQL database that is used is named "dataBase_AAA" this works fine. this was imported from an old server.
We are trying to create a second database for the same account, but the Plesk GUI only allows "website_" as the database prefix.
We need the database prefix to be consistent, we need an ability to change the Prefix for this specific database.
Things tried:
1) We have tried to generate a placeholder database and then rename it in PhpMyAdmin, this fails as the user (who can work with "all" databases under the account according to Plesk GUI) can't access the renamed database:
2) We can find no other way of renaming specific databases under the account. And given the gaps in Plesk documentation on everything we really don't want to risk the system "renaming" the currently operational DB that exists.
So;
How do we rename the prefix for a specific database inside Plesk ?
