【已解决】请问哪里错误了。谢谢。关于pureftp

jesseprince

-- This mysql script is made by M.Mastenbroek 2002 - 2005
-- For more info look at http://machiel.generaal.net
-- Version 2.0
--
-- You don't need this script when you already have the database
-- or when you use the install.php configuration script successfully.
--
-- Example how to execute this script from command line:
--
-- mysql -u root -ppassword -h 127.0.0.1 < script.mysql
--
--
--
-- Host: localhost    Database: ftpusers
---------------------------------------------------------
-- Server version       3.23 or 4.x
-- Script version       1.4.0
--
--
--
-- Create MySQL user called 'ftp'
-- Login = ftp
-- Password = tmppasswd
-- Host = 127.0.0.1
--

INSERT INTO mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES('localhost','ftp',PASSWORD('passwd'),'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N');

FLUSH PRIVILEGES;

CREATE DATABASE ftpusers;

USE ftpusers;

--
-- Table structure for table 'admin'
--

CREATE TABLE admin (
  Username varchar(35) NOT NULL default '',
  Password char(32) binary NOT NULL default '',
  PRIMARY KEY  (Username)
)
-- TYPE=MyISAM;

--
-- Data for table 'admin'
--


INSERT INTO admin VALUES ('admin',MD5('passwd'));

--
-- Table structure for table 'users'
--

CREATE TABLE `users` (
  `User` varchar(16) NOT NULL default '',
  `Password` varchar(32) binary NOT NULL default '',
  `Uid` int(11) NOT NULL default '14',
  `Gid` int(11) NOT NULL default '5',
  `Dir` varchar(12 NOT NULL default '',
  `QuotaFiles` int(10) NOT NULL default '500',
  `QuotaSize` int(10) NOT NULL default '30',
  `ULBandwidth` int(10) NOT NULL default '80',
  `DLBandwidth` int(10) NOT NULL default '80',
  `Ipaddress` varchar(15) NOT NULL default '*',
  `Comment` tinytext,
  `Status` enum('0','1') NOT NULL default '1',
  `ULRatio` smallint(5) NOT NULL default '1',
  `DLRatio` smallint(5) NOT NULL default '1',
  PRIMARY KEY  (`User`),
  UNIQUE KEY `User` (`User`)
)
-- TYPE=MyISAM;

--
-- Data for table 'users'
"pureftp.sql" 79L, 2113C written
[root@localhost pureftp]#
[root@localhost pureftp]#
[root@localhost pureftp]#
[root@localhost pureftp]#
[root@localhost pureftp]#
[root@localhost pureftp]#
[root@localhost pureftp]#
[root@localhost pureftp]# mysql -u root -p <pureftp.sql
Enter password:
ERROR 1064 (42000) at line 15: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-------------------------------------------------------

chinafenghao

@jesseprince
看报错确实没看出问题.不过不知道你这个sql文件里面貌似没有创建database的语句,导致你后面的create table会失败。
也可能是--的注释符号你的mysql不支持.sql注释可以考虑用 /* xxxxxxxxxxx */

另外,你可以把你的sql直接拷贝到一个GUI工具区执行试试。

jesseprince

注释全去掉了，还是会报错。



INSERT INTO mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES('localhost','ftp',PASSWORD('passwd'),'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N');

FLUSH PRIVILEGES;

CREATE DATABASE ftpusers;

USE ftpusers;



CREATE TABLE admin (
  Username varchar(35) NOT NULL default '',
  Password char(32) binary NOT NULL default '',
  PRIMARY KEY  (Username)
)



INSERT INTO admin VALUES ('admin',MD5('passwd'));


CREATE TABLE `users` (
  `User` varchar(16) NOT NULL default '',
  `Password` varchar(32) binary NOT NULL default '',
  `Uid` int(11) NOT NULL default '14',
  `Gid` int(11) NOT NULL default '5',
  `Dir` varchar(12 NOT NULL default '',
  `QuotaFiles` int(10) NOT NULL default '500',
  `QuotaSize` int(10) NOT NULL default '30',
  `ULBandwidth` int(10) NOT NULL default '80',
  `DLBandwidth` int(10) NOT NULL default '80',
  `Ipaddress` varchar(15) NOT NULL default '*',
  `Comment` tinytext,
  `Status` enum('0','1') NOT NULL default '1',
  `ULRatio` smallint(5) NOT NULL default '1',
  `DLRatio` smallint(5) NOT NULL default '1',
  PRIMARY KEY  (`User`),
  UNIQUE KEY `User` (`User`)
)

报错如下：===============================
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NSERT INTO mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_pr' at line 1




回复 2# chinafenghao


   

a.a

@chinafenghao 现在的问题帖子，只要有回复都加上了【已解决】，实际并不一定解决，是否产生一些误导。

jesseprince

解决不了啊。。。。回复 4# a.a


   

a.a

回复 5# jesseprince


     最简单的办法，忽略注释 将执行语句（主要的）手动执行看下。