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: 35508
Joined: 2004-02-23 20:49
First name: Tim
Last name: Kosse

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: 26913
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).
No support requests over PM! You will NOT get any reply!!!
FTP connection problems? Please read Network Configuration.
FileZilla connection test: https://filezilla-project.org/conntest.php
FileZilla Pro support: https://customerforum.fileZilla-project.org

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: 26913
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.
No support requests over PM! You will NOT get any reply!!!
FTP connection problems? Please read Network Configuration.
FileZilla connection test: https://filezilla-project.org/conntest.php
FileZilla Pro support: https://customerforum.fileZilla-project.org

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