MariaDB [(none)]> CREATE DATABASE ftpdb;
MariaDB [ftpdb]> CREATE TABLE
users
(
id
int AUTO_INCREMENT PRIMARY KEY,name char(30) NOT NULL,password char(48));
MariaDB [ftpdb]> INSERT INTO
users
(name,password) VALUES (
'tom'
,password(
'tom'
));
MariaDB [ftpdb]> INSERT INTO
users
(name,password) VALUES (
'jerry'
,password(
'jerry'
));
MariaDB [ftpdb]> SELECT * FROM
users
;
+----+-------+-------------------------------------------+
|
id
| name | password |
+----+-------+-------------------------------------------+
| 1 | tom | *71FF744436C7EA1B954F6276121DB5D2BF68FC07 |
| 2 | jerry | *09FB9E6E2AA0750E9D8A8D22B6AA8D86C85BF3D0 |
+----+-------+-------------------------------------------+
MariaDB [(none)]> GRANT ALL ON ftpdb.* TO vsftpuser@
'172.18.%.%'
IDENTIFIED BY
'vsftpuser'
;
MariaDB [ftpdb]> FLUSH PRIVILEGES;