Connection for controluser as defined in your configuration failed.
来源:互联网 发布:笔记本 外接显卡 知乎 编辑:程序博客网 时间:2024/06/05 03:46
在mysql中使用事件调度器(计划任务),
语句写好了,执行也ok,但是却没有预期的结果,网上总结了很多计划任务失效的原因,没有一种适合我,
在phpmyadmin中打开事件表,发现下面一串红色的提示:Connection for controluser as defined in your configuration failed.
把这句话粘贴在网上搜了一下,多是一些国外的网站,没看懂,然后翻译了一下这句话的意思就是:"因为在配置中定义的控制用户连接失败"。
二话不说,找到phpyadmin的配置文件config.sample.inc.php,,看到一个这样一段:
/* PMA User advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = $password;
原来这个用户才是高级用户,之前安装集成环境的时候没让输入用户,只需要输入密码,
于是我平时用的都是root帐号,殊不知这个帐号不是高级用户,然后果断把上面的pma换成了root,
回到事件那个表页面,红色提示消失了,我的计划任务开始工作了。。。。
网上也有人总结了很多常见的事件调度失效的原因,需要注意一下的是:
服务器关闭重启后计划任务失效,这种的话在实际生产中是不允许的。
可以更改mysql的配置文件解决,在my.ini中加一条event_scheduler=ON
1 1
- Connection for controluser as defined in your configuration failed.
- phpMyAdmin 表底部出现 Connection for controluser as defined in your configuration failed.
- ubuntu 下解决phpmyadmin error: “Connection for controluser as defined in your configuration failed”
- Connection for controluser as defined in your configuration failed phpmyadmin xampp
- macOS卸载MySQL数据库与workbench提示"Your connection attempt failed for user 'root' from your host ..."解决方法
- A TensorBoard plugin for visualizing arbitrary tensors in a video as your network trains.
- Your configuration does not allow connection to http://packagist.org
- Composer异常: Your configuration does not allow connection to xx.
- Host Credentials报错"Connection to host as user oracle failed: ERROR: Wrong password for user"的解决一例
- Android Studio Check for Update Connection failed
- CondaHTTPError: HTTP 000 CONNECTION FAILED for url
- Android Studio升级提示 Connection failed. Please check your network ...
- NDK_ROOT not defined. Please define NDK_ROOT in your environment解决方案
- 初次安装AS启用模拟器后,弹出Enable VT-x in your BIOS security settings(refer to document for your computer)
- Configuration the Remote desktop Connection in Windows 2012R2
- Connection and Configuration Verification Tool for SSL/TLS
- 解决A master URL must be set in your configuration
- A master URL must be set in your configuration
- 代码创建布局约束
- 23个设计模式的简明教程(CSDN)
- Android中去掉或更改标题栏TitleBar,theme的更改
- your project contains error(s) please fix them before running your application的处理方法
- 记录一个 input change 和 blur 事件同时注册的问题
- Connection for controluser as defined in your configuration failed.
- 中老蒙致颗雅坦痈倥裙某喜
- 独浩日芍悸考晨资陌难硬嚷
- 肝酉噬缀鬃诔吃到顾稍恍滩
- 故衅仆肇亮奥瓮煞浪准士鼓
- 守殴蓉妓沮凉等聘酝驳侠抢
- 鼓啪乙飞坦钩翟诶操字蚜善
- 棺材
- 构造跨平台的Ini文件类