Unable to rename database or create a new one

Hosting Support
1

Website url

Error

Nothing happens when I click “Go”.

Other Information

I have tried to rename the database and create a new one in two ways, neither of which work,

  1. cPanel > MYSQL Databases
  2. Navigating to server via phpmyadmin
2

Please show screenshot how you are going to implement it

3

Thank you for replying so quickly KangJL. I want to have two databases as shown below.

image

4

Databases have to be in useraccount_whatevername format.
‘glenpark’ is definitely not a user account

5 Likes
5

Thank you again KangJL. I have been unclear. The screenshot above is from the phpadmin site that I am duplicating. I have the screenshot below currently. Is this the same database setup as the previous screenshot?

Is it possible to rename a database?

Thanks

6

You can create a database, however it has to be this format

2 Likes
7

I didn’t upload the screenshot.

Screenshot 2023-08-03 165540
Screenshot 2023-08-03 1655401124×243 11.7 KB

8

How do I rename please?

9

Hi there,
I don’t think that we allow renaming the databases. All SQL queries related to DATABASE isn’t permitted. Please only use control panel to create/delete databases.

4 Likes
10

Thank you. I appreciate your help.

11

Frank419 is right. Are you trying to rename the table prefix?

2 Likes
12

Hi Frank419. No, just the suffix.

13

Not possible either.

But there’s a work around:

  1. Export your existing database.
  2. Create a new database.
  3. Delete the old database.
  4. Import exported data to the new database.
4 Likes
14

Wonderful :grinning:

Thanks Frank419 for your help

2 Likes
15

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.