Unable to rename database or create a new one

[s3666910]

Website url

http://gpcc.infinityfreeapp.com/?i=1

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

[KangJL]

Please show screenshot how you are going to implement it

[s3666910]

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

[KangJL]

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

[s3666910]

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

[KangJL]

@s3666910

Is it possible to rename a database?

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

@KangJL

Databases have to be in useraccount_whatevername format.

[s3666910]

I didn’t upload the screenshot.

[s3666910]

How do I rename please?

[Frank419]

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.

[s3666910]

Thank you. I appreciate your help.

[KangJL]

@Frank419

I don’t think that we allow renaming the databases

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

[s3666910]

Hi Frank419. No, just the suffix.

[Frank419]

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.

[s3666910]

Wonderful

Thanks Frank419 for your help