how to create database and table by MySQL 
=========================================
 

1. create the database

mysql -u root -p

CREATE DATABASE pureFTPdDatabase;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureFTPdDatabase.* TO 'pureFTPdUser'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureFTPdDatabase.* TO 'pureFTPdUser'@'localhost.localdomain' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

USE pureFTPdDatabase;


2. create the table


CREATE TABLE ftpdTable (
User varchar(16) NOT NULL default '',
status enum('0','1') NOT NULL default '0',
Password varchar(64) NOT NULL default '',
Uid varchar(11) NOT NULL default '-1',
Gid varchar(11) NOT NULL default '-1',
Dir varchar(128) NOT NULL default '',
ULBandwidth smallint(5) NOT NULL default '0',
DLBandwidth smallint(5) NOT NULL default '0',
comment tinytext NOT NULL,
ipaccess varchar(15) NOT NULL default '*',
QuotaSize smallint(5) NOT NULL default '0',
QuotaFiles int(11) NOT NULL default 0,
PRIMARY KEY (User),
UNIQUE KEY User (User)
) TYPE=MyISAM;


quit;