Ubuntu system establishes MySQL authenticated FTP user and virtual host extensions

Ubuntu System establishes FTP virtual user and http://www.aliyun.com/zixun/aggregation/14840.html through MySQL database "> extension of virtual host

This is vsftpd.

sudo apt install vsftpd

To create a database for VSFTPD virtual users, this database is to store login FTP username and password, the database name called Vsftpd good.
Login Database Management

Mysql-u root-p

Create a database vsftpd and configure its permissions

CREATE DATABASE vsftpd;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP on vsftpd.* to ' vsftpd ' @ ' localhost ' identified by ' ftpdpass ';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP on vsftpd.* to ' vsftpd ' @ ' localhost.localdomain ' identified by ' Ftpdpass ' ;
FLUSH privileges;

For the above paragraph, notice to change the ftpdpass to your own password, altogether 2
Use the VSFTPD database and create a table
Use VSFTPD;