Question
How to setup FTP and Database user for our wordpress site admin
Hi,
I want to know the steps/commands to setup FTP and Database access (should be limited to wordpress install directory only) for our wordpress site admin. I cannot give him root details, that is obvious, so I need details to how to do this.
Please advise.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×
For read-only mysql access -
Or for full access to that specific wordpress schema only:
In general, I am not sure I would recommend FTP access as it requires a separate service to be installed (vsftpd, for example) and is not encrypted. Instead, I would recommend creating a local account on the Linux server that the wordpress admin can use sftp for to upload his files (such as via WinSCP). SFTP should use the already installed SSH, and also provides some kind of data encryption. You would have to ensure that the user has the proper privileges to upload to the directory that the wordpress install is at however, which may be at /var/www/html but it could be on a different directory according to your setup.
Hello SC,
Thanks for your response. I have installed vsftpd and configured server as per this guide- www.digitalocean.com/community/tutorials/how-to-configure-vsftpd-to-use-ssl-tls-on-an-ubuntu-vps
But I get this error- Connection attempt failed with ECONNREFUSED - Connection refused by server.
I am not sure where I am doing wrong. Below is my vsftpd.conf file(I have removed all settings which came as default after installation)
Any advise on this will be helpful.
One thing I have noticed after I run
I get following-
Not sure if that is correct.
I was able to login via ftp, had to change this in the default config -