Got error: 1449: The user specified as a definer ('root'@'%') does not exist
来源:互联网 发布:php记事源码 编辑:程序博客网 时间:2024/06/01 14:10
是由于root用户对全局host无访问权限。因此只要给root用户添加一个访问权限即可。
1,用cmd命令链接MySQL数据库
可以通过找到 mysqld所在的路径(复制mysqld.exe所在路径)
使用cd切换到msyqld.exe路径下,然后输入mysql连接命令如下图
格式是:
Mysql.exe -P 端口号 -h mysql主机名\ip -u root (用户) -p
按回车键
Enter passeord:
回车键
登录成功
授权 给 root 所有sql 权限
输入命令:
mysql> grant all privileges on *.* to root@"%" identified by ".";
放回结果:
Query OK, 0 rows affected (0.00 sec)
输入刷新命令:
mysql >flush privileges;
放回结果:
Query OK, 0 rows affected (0.00 sec)
通过上述操作就可以解决问题
阅读全文
0 0
- Got error: 1449: The user specified as a definer ('root'@'%') does not exist
- Got error: 1449: The user specified as a definer ('root'@'%') does not exist
- Got error: 1449: The user specified as a definer ('root'@'%') does not exist
- Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TAB
- ERROR 1449 (HY000): The user specified as a definer ('root'@'%') does not exist
- ERROR 1449 (HY000): The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist。
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist。 .
- The user specified as a definer ('root'@'%') does not exist。
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- 2017.10.12,开启我的博客之旅!
- Linux 查看服务器开放的端口号
- 第7周 【项目一】 建立顺序环形队列算法库
- Maven的本地仓库、中心仓库、私服
- idea创建maven项目
- Got error: 1449: The user specified as a definer ('root'@'%') does not exist
- LeetCode-95. Unique Binary Search Trees II
- 算法第四版入门:牛顿迭代法
- java使用正则去除html标签
- 设计模式之组合模式
- Qt,Qt Creator,minGW,VS关系
- 第四周项目一 建立单链表
- 你会使用Quick BI 制作企业数据分析报表吗?
- jetpack