Page 1 of 1

How to allow a developer FTP access to a database?

Posted: 2019-12-15 22:53
by Mark2577
Help, please: As instructed, I've already read the FAQs and Wiki and searched.
Cannot find how to do this simple task:
I created an FTP user (user941) and he can use Filezilla to access public_html.
In Cpanel > Databases > MySqlDatabases, I added that user to the database (db11) and made him a "privileged user".
Still, cannot see how that user can get to accessing / updating the database.
Thanks.
Mark2577

Re: How to allow a developer FTP access to a database?

Posted: 2019-12-16 07:20
by botg
The database user you created is for accessing the database with database tools, such as the mysql client.

Depending on the database configuration, the database may or may not be reachable over the Internet.

Re: How to allow a developer FTP access to a database?

Posted: 2019-12-16 11:48
by boco
Databases cannot be maintained using FileZilla, as they are generally not exposed as files.

If the database is configured to be reachable over the Internet (not recommended really), the user might use a tool such as the MySQL client (command line only) or phpMyAdmin (either provided by your hoster or by yourself).

Re: How to allow a developer FTP access to a database?

Posted: 2019-12-17 17:54
by Mark2577
Thanks for the replies, people.
OK, then, is there a way to allow him to edit the database, without giving him complete Cpanel access?
How to do that?
I'm sure this is a common occurance; many people hire developers like this. :?

Re: How to allow a developer FTP access to a database?

Posted: 2019-12-18 10:50
by boco
You need to ask your hoster, as it's them running the server infrastructure.

Re: How to allow a developer FTP access to a database?

Posted: 2019-12-18 21:31
by Mark2577
OK. Thanks, Boco, for the info.