How to add an existing database to a users cPanel?

[jerrek71]

Hi there,
I have a user who's moved to me from a different provider. He has a database which is not of the format username_database (just database) but I need to be able to give him access to this database from his cPanel account - how can I add that database so that he can administer it himself from his cPanel account?

Cheers,
Steve

 

[RickG]

My preference:

1) Create the database while logged into the client's cPanel account. This will establish permissions etc. should they want to access it in their control panel using phpMyAdmin, change database passwords, users, etc.

2) Yes ... this will name the database in the "username_database" format, but the name of the database is usually defined once in a script configuration file and should be a very simple change on their end.

3) If you've already imported their SQL dump as root, I would export it (so it is current), create the database as in step #1, and then import it back in.

 

[Divino]

No add an existing database to a users cPanel

ok perfect