2.导入pureftp.sql文件
[root@localhost ~]# vim pureftp.sql
由于mysql5.5之后不支持TYPE=MyISAM类型,需要做以下修改
[root@localhost ~]# mysql -u root -p <pureftp.sql 把pureftp.sql导入到msql中
输入密码123
[root@localhost ~]# mysql -u root –p 进入mysql 查看导入状态
mysql> use mysql;
Database changed
mysql> show tables;
mysql> select * from user; 我们导入的ftp帐号和密码
mysql> use ftpusers;
mysql> show tables;
mysql> select * from admin;
mysql> grant all privileges on ftpusers.* to ftp@localhost identified by 'tmppasswd'; 授权ftp账户
mysql> flush privileges; 刷新授权