起因：从本地迁移到线上时发生报错
原因
排查后发现是本地导出sql时创建view表语句的原因
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `x_jeeinn_table_view`
AS SELECT
...;
- 本地使用的是root测试帐号
- 线上使用的是xxx帐号
解决
将建表语句用户名root批量改为xxx重新导入即可
积跬步，至千里
起因：从本地迁移到线上时发生报错
排查后发现是本地导出sql时创建view表语句的原因
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `x_jeeinn_table_view`
AS SELECT
...;
将建表语句用户名root批量改为xxx重新导入即可
Copyright © 2024 JeeInn的技术分享 | 冀ICP备2023009855号-2
Hi there i am kavin, its my first occasion to
commenting anywhere, when i read this article i thought i could also create
comment due to this good article.