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.

Subscribe
Share

I was able to login via ftp, had to change this in the default config -

pam_service_name=ftp

One thing I have noticed after I run

sudo service vsftpd restart

I get following-

stop: Unknown instance:
vsftpd stop/waiting

Not sure if that is correct.

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)

local_enable=YES
write_enable=YES
chroot_local_user=YES
chroot_list_enable=NO
allow_writeable_chroot=YES
anonymous_enable=NO
rsa_cert_file=/etc/ssl/private/vsftpd.pem
rsa_private_key_file=/etc/ssl/private/vsftpd.pem
ssl_enable=YES
allow_anon_ssl=NO
force_local_data_ssl=YES
force_local_logins_ssl=YES
ssl_tlsv1=YES
ssl_sslv2=NO
ssl_sslv3=NO
require_ssl_reuse=NO
ssl_ciphers=HIGH

Any advise on this will be helpful.

For read-only mysql access -

grant select, show view on `<wordpress_schema_here>.* to `<your_user>`@'%';

Or for full access to that specific wordpress schema only:

GRANT Create Temporary Tables, Trigger, References, Insert, Update, Create Routine, Alter, Create View, Event, Lock Tables, Drop, Execute, Alter Routine, Create, Index, Delete, Select, Show View ON `<wordpress_schema_here>`.* TO `<your_user>`@`%`;

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.


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

This question was answered by @LakshmanS:

I was able to login via ftp, had to change this in the default config -

pam_service_name=ftp

View the original comment

This comment has been deleted