sqlyog导入数据库数据
sql文件中包含数据和表结构,具体出错信息为(sqlyog.err文件中):
Error occured at:2009-10-20 16:24:44
Line no.:1243
Error Code: 1044 - Access denied for user 'root'@'%' to database 'sisemanagerdevnew'
Query:
/*!50003 CREATE DEFINER=`root`@`%` FUNCTION `funcConvertAlarmDataAttributeName`(paramAttributeID INT(10),paramCollectName VARCHAR(200)) RETURNS varchar(200) CHARSET utf8
BEGIN
DECLARE strAttributeName VARCHAR(200);
SELECT `Name` INTO strAttributeName FROM AM_MONITOR_ITEM_ATTRIBUTE WHERE ID = paramAttributeID;
IF strAttributeName <> paramCollectName THEN
SET strAttributeName = CONCAT(strAttributeName,"(",paramCollectName,")");
ELSE
SET strAttributeName = paramCollectName;
END IF;
RETURN strAttributeName;
END */
Error occured at:2009-10-20 16:26:16
Line no.:1243
Error Code: 1044 - Access denied for user 'root'@'%' to database 'sisemanagerdevnew'
请大家说明下原因,另如果能找到sqlyog的使用指南就更好啦~