在Amazon RDS中创建MySQL事件 [英] Creating MySQL Events in Amazon RDS

问题描述

我正在尝试在RDS数据库上创建MySQL事件.我花了一点时间才弄清楚，我需要更改数据库参数并启动调度程序.但是，即使正在运行调度程序(我看到它正在SHOW PROCESSLIST中运行)，在创建事件时，我仍然会收到错误1044(42000):用户的访问被拒绝..."消息.我尝试在AWS讨论板上发帖，但什么也没有.

I'm trying to create a MySQL Event on an RDS database. It took me a bit to figure out that I needed to change the DB Parameters and get the scheduler started. However, even with the scheduler running (I see is running in SHOW PROCESSLIST), I am still getting "ERROR 1044 (42000): Access denied for user..." when I create an event. I tried posting on the AWS discussion boards, but nothing.

有人在AWS RDS实例中创建MySQL事件吗?如果是这样，我是不是在做什么，或者我缺少什么才能创建它?

Has anyone created a MySQL event in an AWS RDS instance? If so, what I am not doing, or what am I missing to get it created?

我正在使用主用户帐户，因此我怀疑它必须是我尚未设置的另一个数据库参数(我怀疑).

I'm using the Master User account so I suspect it has to be another DB Parm I havent set (I suspect).

推荐答案

您必须为实例创建一个参数组.

You have to create a parameter group for your instance.

转到RDS信息中心，然后单击左侧的参数.

Go to your RDS Dashboard and click parameters on the left.

您应该看到参数组列表，如果仅看到默认"组，则需要创建一个新组. (请参见1a).如果您已经有一个自定义参数组，请跳至1b.

You should see a list of parameter groups, if you only see "default" groups, then you need to create a new group. (see 1a). If you already have a custom parameter group, skip to 1b.

1a..单击顶部的create参数，确保选择数据库正在使用的合适的MySql版本(在实例仪表板上找到).给它起一个名字，然后单击是，创建". (也执行1c).

1a. Click create parameter at the top, make sure you select the appropriate MySql version you're DB is using (found on the instances dashboard). Give it a name and click "yes, create". (also do 1c).

1b..单击参数组所在行中的放大镜，它将带您进入详细信息页面.

1b. Click the magnifying glass in the row where your parameter group is and it will take you to the details page.

在详细信息页面上的底部，您将在搜索框中键入事件"，看到过滤器:".让表格进行过滤，然后单击编辑参数".在下面的列表中，您要更改"event_scheduler"的"values"列，然后在框中键入"ON".

On the details page look at the bottom and you will see "Filter:" in the search box type "Event". Let the table filter and then click "Edit Parameters". In the list below you want to change the "values" column for "event_scheduler" and type "ON" in the box.

如果最初使用参数组是个不错的选择，那么您可以转到实例仪表板，看看它正在应用您的参数组更改.如果您创建了参数组，请继续.

If you originally started with a parameter group you're good to go, you can head over to your instances dashboard to see that it's applying your parameter group changes. If you created your parameter group, continue on.

警告！！下一步需要重新启动！

Warning! The next step requires a reboot!

1c..您需要将参数组应用于数据库实例.单击左侧的实例，然后选择要将参数组应用于的数据库.您要在顶部单击实例操作"，然后单击修改".

1c. You need to apply your parameter group to your DB instance. Click instances on the left and then select the DB you want to apply the parameter group to. At the top you want to click "Instance Actions" and then "Modify".

将参数组"选择更改为您创建的新参数组.单击页面底部的继续，然后在下一页上修改数据库实例.现在，您需要重新启动服务器，选择实例操作"，然后选择重新启动".

Change the "Parameter Group" selection to be the new parameter group you created. Click continue at the bottom of the page, then modify db instance on the next page. You now need to reboot your server, select "Instance Actions" then "Reboot".

这篇关于在Amazon RDS中创建MySQL事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！