Question 1

我有一个PHP脚本,它调用 MySQL s LOAD Data INFILE 从 CSV 文件装入数据。然而,在生产服务器上,我最后出错如下:

用户拒绝访问...(使用密码:是)

作为快速的变通,我将命令改为有效操作的 LOAD DATA LOCAL INFILE 。但是,客户端服务器上的同一命令因此消息而失败 :

此 MySQL 版本不允许使用已使用的命令

我想这跟服务器变量有关:local_infiles = off

Answer

撞到了和根一样的问题把我扔了一会儿

您的服务器设置设置可能存在问题, 设置为编译

要测试登录以使用同一用户来控制控制台并尝试您的负载数据命令

如果发生相同的错误,请尝试关闭控制台并运行

mysql -u USER -p --local-infile=1 DATABASE

现在尝试再次运行装入数据命令

如果有效的话, 您需要用命令行选项重新启动 Mysqld, 或者用配置选项重新安装

(参考文献是5.0,但我用5.5有效):

http://dev.mysql.com/doc/refman/5.0/en/mysql-comman-comman-options.html#option_mysql_local-infile

Answer

我发现我需要像这样连接到数据库:

$dbh=mysql_connect($server,$dbuser,$dbpass,false,128);

在国旗参数中通过 128 是关键。

见http://www.php.net/manual/en/mysql.constats.php#mysql.costants.php#mysql.clients-flags' rel=“不跟随 nofollown noreferrer>>http://www.php.net/manual/en/mysql.constants.php#mysql.clients-flags ,以了解更多关于国旗的信息。

Answer

查看此权限列表, 您可以单独添加它们, IE 。您可以插入但不更新, 或者删除但不选择, 等等...

ALL [PRIVILEGES]    Grant all privileges at specified access level except GRANT OPTION
ALTER   Enable use of ALTER TABLE
ALTER ROUTINE   Enable stored routines to be altered or dropped
CREATE  Enable database and table creation
CREATE ROUTINE  Enable stored routine creation
CREATE TEMPORARY TABLES     Enable use of CREATE TEMPORARY TABLE
CREATE USER     Enable use of CREATE USER, DROP USER, RENAME USER, and REVOKE ALL PRIVILEGES
CREATE VIEW     Enable views to be created or altered
DELETE  Enable use of DELETE
DROP    Enable databases, tables, and views to be dropped
EVENT   Enable use of events for the Event Scheduler
EXECUTE     Enable the user to execute stored routines
FILE    Enable the user to cause the server to read or write files
GRANT OPTION    Enable privileges to be granted to or removed from other accounts
INDEX   Enable indexes to be created or dropped
INSERT  Enable use of INSERT
LOCK TABLES     Enable use of LOCK TABLES on tables for which you have the SELECT privilege
PROCESS     Enable the user to see all processes with SHOW PROCESSLIST
REFERENCES  Not implemented
RELOAD  Enable use of FLUSH operations
REPLICATION CLIENT  Enable the user to ask where master or slave servers are
REPLICATION SLAVE   Enable replication slaves to read binary log events from the master
SELECT  Enable use of SELECT
SHOW DATABASES  Enable SHOW DATABASES to show all databases
SHOW VIEW   Enable use of SHOW CREATE VIEW
SHUTDOWN    Enable use of mysqladmin shutdown
SUPER   Enable use of other administrative operations such as CHANGE MASTER TO, KILL, PURGE BINARY LOGS, SET GLOBAL, and mysqladmin debug command
TRIGGER     Enable trigger operations
UPDATE  Enable use of UPDATE
USAGE   Synonym for “no privileges”

我觉得你有选择,删除,插入,更新, 但不做其他事情,

使用此命令 :

SHOW GRANTS

以我为例,他将展示你的能力。

jcho360> show grants;
+-------------------------------------------------------+
| Grants for jbolivar@localhost                         |
+-------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO  jbolivar @ localhost  |
+-------------------------------------------------------+
1 row in set (0.00 sec)

Question 2