Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Either remove the DEFINER=.. statement from your sqldump file, or replace the user values with CURRENT_USER.

The MySQL server provided by RDS does not allow a DEFINER syntax for another user (in my experience).

You can use a sed script to remove them from the file:

sed 's/\sDEFINER=`[^`]*`@`[^`]*`//g' -i oldfile.sql

Related Posts:

  1. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  2. Column count doesn’t match value count at row 1
  3. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  4. MySQL string replace
  5. Access denied for user ‘root@localhost’ (using password:NO)
  6. Which MySQL data type to use for storing boolean values
  7. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  8. Cannot delete or update a parent row: a foreign key constraint fails
  9. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  10. Your password does not satisfy the current policy requirements
  11. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  12. What is the definition of cardinality in SQL
  13. How to restart remote MySQL server running on Ubuntu linux?
  14. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  15. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  16. Selecting data from two different tables without using joins
  17. Difference between VARCHAR and TEXT in MySQL
  18. MySQL: Invalid use of group function
  19. How can I loop through all rows of a table? (MySQL)
  20. Simple Random Samples from a Sql database
  21. What does SQL clause “GROUP BY 1” mean?
  22. LAST_INSERT_ID() MySQL
  23. MySQL foreach loop
  24. MySQL IF NOT NULL, then display 1, else display 0
  25. MySQL date format DD/MM/YYYY select query?
  26. MySQL Calculate Percentage
  27. Repair all tables in one go
  28. Error: select command denied to user ‘‘@’‘ for table ‘‘
  29. Get the new record primary key ID from MySQL insert query?
  30. #1214 – The used table type doesn’t support FULLTEXT indexes
  31. How to change collation of database, table, column?
  32. Failed building wheel for mysql-python
  33. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  34. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  35. Remove Primary Key in MySQL
  36. How to use the keyword ‘references’ in MySQL?
  37. How to get the max of two values in MySQL?
  38. mysql: connection refused when trying to connect to localhost using remote IP
  39. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  40. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  41. What are the recommended database permissions for WordPress?
  42. Complex meta query with 3 keys
  43. How can I find the source of slow queries in WordPress?
  44. How to log mysql errors from wordpress core?
  45. Fulltext search in posts sorted by relevancy
  46. wpdb Custom Meta Data with 2 conditions
  47. query to create woocommerce products from images
  48. Configure WordPress to connect to Mysql DB using SSH tunneling
  49. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  50. Rewrite database urls
  51. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  52. Migrating from Existing MySQL Setup to WordPress
  53. How to split the a table in database?
  54. Can I restart MySQL engine when WordPress website is live?
  55. Why my wordpress loopback traffic while socket is setup?
  56. How do I join a $wpdb query with user meta using default value if not exist?
  57. mySQL statment count of post in each category and sub category
  58. Paypal Post IPN handeling nightmare
  59. Update or insert meta key value – On Duplicate key update
  60. Connect to MySQL using Windows Authentication
  61. Is there a page length limit?
  62. WordPress tables and aliases?
  63. What’s the sql for this condition?
  64. Create a form with custom autocomplete address field and CSV import values
  65. WordPress insert query is not working : Showing no Error
  66. How to get INSERT errors from $wpdb?
  67. Copy usermeta value where ID matches in the same table
  68. Export Yoast Keywords from MySQL/phpMyAdmin
  69. Same database; different WordPress
  70. Some Post Content Does Not Show Up In DB Search
  71. How can I write a formal sql query to get data from a custom table
  72. How can I view my site directly from WordPress dashboard?
  73. (WP List Table) How to sort by SKU and Custom Fields?
  74. Word Press and database from another server sync
  75. User set date and time from frontend doesn’t get stored into database
  76. get posts whether meta_key exists or not
  77. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  78. How to bulk delete a certain part of all wordpress posts
  79. When I add metadata, metavalue length is added in to the value in some cases
  80. Changes not being reflected on new server
  81. update_option returns false in AJAX, how to debug?
  82. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  83. WordPress database error Duplicate entry for key ‘slug’
  84. Query does not filter duplicate _sku numbers
  85. MySQL – How to combine data from two tables into one?
  86. Stop my loop to register data twice
  87. `#1215 – Cannot add foreign key constraint
  88. How to restore: Database intact but folders deleted
  89. wp_postmeta – lot of meta fields
  90. XML RPC post produces immediate revision with odd post_date_gmt
  91. Woocommerce: Grab total revenue of a product over all orders
  92. MySQL: get post_tag items that are tags (not SEO keywords)
  93. $wpdb->get_var returns 0
  94. cannot log in to the mysql server (wamp and wordpress)
  95. SQL Database Lost
  96. Where other than wp-config can database access details be defined?
  97. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  98. How can I show user’s privileges in MySQL?
  99. Changing host permissions for MySQL users
  100. AWS RDS connection limits

Leave a Comment