重装MySQL在start service卡死以及The user specified as a definer (''admin@'%') does not exist 问题
来源:互联网 发布:考勤机更改下载数据 编辑:程序博客网 时间:2024/06/16 00:28
重装MySQL在start service卡死以及The user specified as a definer (”admin@’%’) does not exist 问题
重装mysql卡死一般都是卸载不干净导致的,卸载后删除安装目录的文件夹啊,然后打开注册表,ctrl+f查询mysql,删除所有的相关项,然后还有最关键的一步,一般在C盘,ProgramData文件夹里面有,mysql的data信息,一定要删除
报错问题:是因为权限的问题
新建用户
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'admin' WITH GRANT OPTION;
设置权限
grant all privileges on *.* to admin@”%” identified by “.”;
刷新权限相关表
flush privileges;
0 0
- 重装MySQL在start service卡死以及The user specified as a definer (''admin@'%') does not exist 问题
- mysql 1449 : The user specified as a definer ('admin'@'%') does not exist 解决方法
- The user specified as a definer (''@'%') does not exist问题
- mySql问题:The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql权限问题_mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- Unable to post the review. &&The user specified as a definer ('admin'@'localhost') does not exist
- [Err] 1449 - The user specified as a definer ('admin'@'%') does not exist
- The user specified as a definer (@'''') 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 ('XXXXX'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('monitor'@'%') does not exist
- The user specified as a definer (''@'') does not exist
- The user specified as a definer ('montor'@'%') does not exist
- The user specified as a definer ('test'@'%') does not exist
- 排序(一)——排序的分类及比较
- windows remote login linux encounter black screen
- bootstrap轮播控件不自动播放
- 用命令行运行python所有的unittest文件
- app 的内存优化
- 重装MySQL在start service卡死以及The user specified as a definer (''admin@'%') does not exist 问题
- 暑假训练round2 D: 好序列(Manacher)
- 统计学笔记
- HDU 5728 PowMod
- hdu 5569(二维dp,水题)
- PAT(A) - 1027. Colors in Mars (20)
- 斐波那契查找
- js回调函数
- 云即服务