在服务器重启时启用 mysql 事件调度程序

2022-01-05 00:00:00 scheduling mysql phpmyadmin

我正在运行 phpmyadmin 并在我的个人计算机上安装了 apache 服务器.我的问题是我试图将 MySQL event_scheduler 设置为即使服务器重新启动也始终启用.我通过在服务器配置文件(my.cnf 或 my.ini)中设置以下命令行来阅读它应该可以工作:event_scheduler=DISABLED.但是，我在哪里可以找到这个 my.cnf 或 my.ini 文件，并且命令行也应该是 event_scheduler=DISABLED 或 >event_scheduler=ENABLED 看到我希望它总是被启用?

 解决方案 你应该设置 'ON' 值(不是 ENABLED).
在[mysqld]部分的配置文件中指定'event-scheduler'选项(不是event_scheduler).
此外，您可以使用--event-scheduler"选项启动您的 MySQL 服务器，例如-
shell> mysqld --event-scheduler=ON
更多信息 - event_scheduler 系统变量.>
I am running phpmyadmin and installed apache server on my personal computer. My problem is that I am trying to set MySQL event_scheduler to always be enabled even when the server restarts. I was reading that by setting the following command line in the server configuration file (my.cnf or my.ini) it should work: event_scheduler=DISABLED. However, where do I locate this my.cnf or my.ini file, and also should the command line be event_scheduler=DISABLED or event_scheduler=ENABLED seeing that I want it to always be enabled?
 解决方案 You should set 'ON' value (not ENABLED).

In the configuration file in [mysqld] section specify 'event-scheduler' option (not event_scheduler).

Also, you can start your MySQL server with '--event-scheduler' option, e.g. -

shell> mysqld --event-scheduler=ON

More information - event_scheduler system variable.


	
		相关文章