php配置:mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $Directive Local Value Master Value mysql.allow_local_infile On On mysql.allow_persistent On On mysql.connect_timeout 60 60 mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited mysql.trace_mode Off Offmysqli MysqlI Support enabled Client API library version mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $ Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0Directive Local Value Master Value mysqli.allow_local_infile On On mysqli.allow_persistent On On mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.max_persistent Unlimited Unlimited mysqli.reconnect Off Offmysqlnd mysqlnd enabled Version mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $ Compression supported SSL supported Command buffer size 4096 Read buffer size 32768 Read timeout 31536000 Collecting statistics Yes Collecting memory statistics No Tracing n/a 更新的时候只提示这样的出错: Query: UPDATE category SET `ParentId` = '2' ,`CategoryStatus` = '1' WHERE CategoryId = 20 limit 1 failed. 0: 没有明显的错误,这SQL放在MYSQL的客户端是没有问题的
不能update、insert、delete。报的是什么错误
报错是这个 Query: UPDATE category SET `ParentId` = '2' ,`CategoryStatus` = '1' WHERE CategoryId = 20 limit 1 failed. 其实也不知道错在哪里 0:
不能update、insert、delete,是不是权限问题。
执行 show grants 然后贴出结果
CategoryId 有可能重吗 ? 把limit去掉试试
GRANT USAGE ON *.* TO ''@'localhost'好像是没有权限,对不?但用的就root
php配置:mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $Directive Local Value Master Value
mysql.allow_local_infile On On
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Offmysqli
MysqlI Support enabled
Client API library version mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Offmysqlnd
mysqlnd enabled
Version mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $
Compression supported
SSL supported
Command buffer size 4096
Read buffer size 32768
Read timeout 31536000
Collecting statistics Yes
Collecting memory statistics No
Tracing n/a
更新的时候只提示这样的出错:
Query: UPDATE category SET `ParentId` = '2' ,`CategoryStatus` = '1' WHERE CategoryId = 20 limit 1 failed.
0: 没有明显的错误,这SQL放在MYSQL的客户端是没有问题的
报错是这个
Query: UPDATE category SET `ParentId` = '2' ,`CategoryStatus` = '1' WHERE CategoryId = 20 limit 1 failed.
其实也不知道错在哪里
0:
把limit去掉试试
GRANT USAGE ON *.* TO ''@'localhost'好像是没有权限,对不?但用的就root