Hi,

a. To access cpanel i use http:www.xxx.com/cpanel.

b. I enter the un and pw given when we set up the site.

c. I then choose mysql dbs and then add/delete dbs .

d. I also have an option to add users other than the user who has logged in.

e. My question : how can this specific user access a specific mysql db without getting access to all the dbs ?

f. I also wish this specfic user to be able to ftp php files that will feed this specific db so how can that happen without giving the primary un and pw ?

g. Also, how does one rename a db (not just rename a table but a full db consisting of 16 tables and data)

Thanks,
s ananf

You can create a database user and add it to your database in Cpanel->MySQL databases. This database user will be able to connect remotely only to this specific database


Do you want to have a separate ftp user who can upload files to your account so you can later import them to your database? You can create a ftp user in Cpanel->FTP manager and give this user access to a specific folder where you want to keep your files.


You can backup your original database, then create a new one in Cpanel and import your backup via phpMyAdmin.

Hope this will help