Resolved How to rename database prefix for a single database on a user account

[MHC_1]

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:

#1044 - Access denied for user 'acct_tester'@'localhost' to database 'database_test'

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 ?

 

[MHC_1]

FURTHER UPDATE:

Renaming the database in PhpMyAdmin using the root SQL access, does work, but now means that the account can't see the renamed database and so can't add / edit users for this database. How do we make the Plesk Database GUI associate certain database with certain accounts?

 

[scsa20]

Plesk keeps tracks with it's own database, so if you manually renamed the database outside of Plesk, Plesk will not see the new name. You will need to update Plesk database with the change.

mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "SHOW DATABASES;" #Shows the databases that's there so you can confirm the name
plesk db dump psa > psa_backup.sql #For making a backup in case anything got screwed up
plesk db #To get into the SQL console
SELECT id, name, dom_id FROM data_bases; # Find the incorrect name and update it:
UPDATE data_bases SET name='actual_db_name' WHERE id=DB_ID; # Replace DB_ID with the ID of the database you want to rename
\q # To quit out of the SQL console

Steps above should fix it.

 

[MHC_1]

Fantastic, @scsa20 that's sorted it ! Thank you!