XY BLOG

XY的BLOG

mysql 1449 The user specified as a definer (‘root’@’%’) does not exist

Published on in Posts
Short link: https://b.xyzt07.cn/s/f
Share this post
A ⇄ 文
⚠️ This entry is already over one year old. It may no longer be up to date. Opinions may have changed.

1.登录mysql,执行命令,将权限赋给root

grant all privileges on *.* to 'root'@'%' identified by ".";

2.刷新设置

flush privileges;