mysql> create database vsftpd;
mysql> grant
select
on vsftpd.* to ftpuser@localhost identified by
'jason11'
;
mysql> grant
select
on vsftpd.* to ftpuser@127.0.0.1 identified by
'jason11'
;
mysql> grant
select
on vsftpd.* to ftpuser@‘192.168.%.%’ identified by
'jason11'
;
mysql> flush privileges;
mysql> use vsftpd;
mysql> create table
users
(
->
id
int AUTO_INCREMENT NOT NULL,
-> name char(20) binary NOT NULL,
-> password char(48) binary NOT NULL,
-> primary key(
id
)
-> );
mysql> insert into
users
(name,password) values(
'tom'
,
'magedu'
);
mysql> insert into
users
(name,password) values(
'jerry'
,
'magedu'
);