How to allow a developer FTP access to a database?

Post all HTML related questions here. No support.

Moderator: Project members

Post Reply
Message
Author
Mark2577
500 Command not understood
Posts: 3
Joined: 2019-12-15 22:13
First name: Mark

How to allow a developer FTP access to a database?

#1 Post by Mark2577 » 2019-12-15 22:53

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

User avatar
botg
Site Admin
Posts: 33182
Joined: 2004-02-23 20:49
First name: Tim
Last name: Kosse
Contact:

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

#2 Post by botg » 2019-12-16 07:20

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.

User avatar
boco
Contributor
Posts: 25286
Joined: 2006-05-01 03:28
Location: Germany

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

#3 Post by boco » 2019-12-16 11:48

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).
### BEGIN SIGNATURE BLOCK ###
No support requests per PM! You will NOT get any reply!!!
FTP connection problems? Do yourself a favor and read Network Configuration.
FileZilla connection test: https://filezilla-project.org/conntest.php
### END SIGNATURE BLOCK ###

Mark2577
500 Command not understood
Posts: 3
Joined: 2019-12-15 22:13
First name: Mark

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

#4 Post by Mark2577 » 2019-12-17 17:54

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. :?

User avatar
boco
Contributor
Posts: 25286
Joined: 2006-05-01 03:28
Location: Germany

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

#5 Post by boco » 2019-12-18 10:50

You need to ask your hoster, as it's them running the server infrastructure.
### BEGIN SIGNATURE BLOCK ###
No support requests per PM! You will NOT get any reply!!!
FTP connection problems? Do yourself a favor and read Network Configuration.
FileZilla connection test: https://filezilla-project.org/conntest.php
### END SIGNATURE BLOCK ###

Mark2577
500 Command not understood
Posts: 3
Joined: 2019-12-15 22:13
First name: Mark

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

#6 Post by Mark2577 » 2019-12-18 21:31

OK. Thanks, Boco, for the info.

Post Reply