MySQL/Amazon RDS错误:“您没有SUPER特权..." [英] MySQL/Amazon RDS error: "you do not have SUPER privileges..."
问题描述
我正在尝试将mysql数据库从Amazon EC2复制到RDS:
I'm attempting to copy my mysql database from an Amazon EC2 to an RDS:
我成功使用以下方法将数据库的mysqldump
放入根文件夹中:
I successfully did a mysqldump
of my database into my root folder using this:
root@ip-xx-xx-xx-xx:~# mysqldump my_database -u my_username -p > my_database.sql
然后,我尝试将此.sql文件传输到我的新RDS数据库中:
Then I tried to transfer this .sql file to my new RDS database:
root@ip-xx-xx-xx-xx:~# mysql my_database -u my_username -p -h
my_new_database.xxxxxxxxx.us-east-1.rds.amazonaws.com < my_database.sql
不幸的是,我收到以下错误消息:
Unfortunately, I get following error message:
You do not have the SUPER privilege and binary logging is enabled
(you *might* want to use the less safe log_bin_trust_function_creators variable)
我尝试了多种方式GRANT SUPER..
,但是当我尝试这样做时也遇到了错误.键入mysql > FLUSH privileges;
也不起作用.
I tried to GRANT SUPER..
in a variety of ways but I'm getting errors when I try to do that too. Typing mysql > FLUSH privileges;
doesn't work either.
我是mysql的初学者,非常抱歉遇到这样一个简单的问题.有想法吗?
I'm a mysql beginner so sorry for such an easy question. Thoughts?
推荐答案
每 http://getasysadmin .com/2011/06/amazon-rds-super-privileges/,则需要在
Per http://getasysadmin.com/2011/06/amazon-rds-super-privileges/, you need to set log_bin_trust_function_creators
to 1 in AWS console, to load your dump file without errors.
如果要忽略这些错误,并加载其余的转储文件,则可以使用-f
选项:
If you want to ignore these errors, and load the rest of the dump file, you can use the -f
option:
mysql -f my_database -u my_username -p -h
my_new_database.xxxxxxxxx.us-east-1.rds.amazonaws.com < my_database.sql
-f
将报告错误,但将继续处理转储文件的其余部分.
The -f
will report errors, but will continue processing the remainder of the dump file.
这篇关于MySQL/Amazon RDS错误:“您没有SUPER特权..."的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!