错误代码： 1449 The user specified as a definer ('root'@'%') does not exist

1. 错误描述

1 queries executed, 0 success, 1 errors, 0 warnings

查询：call analyse_use('20150501','20150601')

错误代码： 1449
The user specified as a definer ('root'@'%') does not exist

执行耗时   : 0 sec
传送时间   : 0 sec
总耗时      : 0.003 sec

2. 错误原因

在存储过程里，我用的用户是root，而实际的是skyusers

3. 解决办法

将以下代码

CREATE DEFINER=`localhost`@`%` PROCEDURE `analyse_use`(IN `startDate` VARCHAR(20),IN `endDate` VARCHAR(20))

修改成

CREATE DEFINER=`skyusers`@`%` PROCEDURE `analyse_use`(IN `startDate` VARCHAR(20),IN `endDate` VARCHAR(20))

<script type="text/javascript"> $(function () { $('pre.prettyprint code').each(function () { var lines = $(this).text().split('\n').length; var $numbering = $('<ul/>').addClass('pre-numbering').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i <= lines; i++) { $numbering.append($('<li/>').text(i)); }; $numbering.fadeIn(1700); }); }); </script>