logo
publist
写文章

简介

该用户还未填写简介

擅长的技术栈

可提供的服务

暂无可提供的服务

解决MySQL的“Access denied; you need (at least one of) the SUPER privilege(s) for this operation”报错

今天在用Navicat for MySQL执行sql文件导入数据库的操作时出现了 “[Err] 1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation” 的报错提示,经过仔细检查发现在sql文件中的存储过程增加了 DEFINER=`root`@`localhost` 如图所

解决MySQL的“Access denied; you need (at least one of) the SUPER privilege(s) for this operation”报错

今天在用Navicat for MySQL执行sql文件导入数据库的操作时出现了 “[Err] 1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation” 的报错提示,经过仔细检查发现在sql文件中的存储过程增加了 DEFINER=`root`@`localhost` 如图所

解决MySQL的“Access denied; you need (at least one of) the SUPER privilege(s) for this operation”报错

今天在用Navicat for MySQL执行sql文件导入数据库的操作时出现了 “[Err] 1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation” 的报错提示,经过仔细检查发现在sql文件中的存储过程增加了 DEFINER=`root`@`localhost` 如图所

到底了