Thursday, 27 October 2016

Mysql Database Import fails in AWS RDS : ERROR 1449 (HY000) at line 27101: The user specified as a definer ('dbadmin'@'%') does not exist

Mysql Database Import fails in AWS RDS 

Error message :

ERROR 1449 (HY000) at line 27101: The user specified as a definer ('dbadmin'@'%') does not exist


Syntax :

[ec2-user@ip-*******~]$ mysql -u***** -p***** PROD_DATABASE < PROD_DATABASE.SQL


Solution:

The AWS RDS doesnt store the 'localhost' term in the backed-up mysql dump.
localhost is replaced with '%'. Hence the dump file needs to be updated with localhost in all places it exists with username@'%'.


Update the dump file with 'localhost' to resolve.





Posted by at
Labels:

15 comments:

  1. Unknown7 November 2016 at 04:26

    I have own car so now I am back out there trying to show him how to do car repairs. Your blog is an excellent source of info, thanks.

    home spa services in mumbai

    ReplyDelete
  2. Unknown10 November 2016 at 08:38

    Appreciate your work, very informative blog on Oracle EBS. I just wanted to share information about Oracle EBS Training. Hope it helps community here.

    ReplyDelete
  3. Unknown10 November 2017 at 03:16

    Thank you for the Article, Your Blog is having Lotzz of Stuff about Oracle... Here i am also Sharing Information on Oracle EBS Training. It will Definately useful for Everyone.

    ReplyDelete
  4. Ancy merina23 February 2018 at 23:51

    This comment has been removed by the author.

    ReplyDelete
  5. Unknown4 April 2018 at 23:13

    Very nice Blog on Oracle Applications DBA. Worth Sharing... I just want to Share you some thing on Oracle Data Integration.

    This Oracle Data Integrator (ODI training) provides experience in configuring and administering the ODI environment. Learn methods and techniques of data integration among various platforms. This course also covers advanced techniques for developing data integration applications. You learn how to create an integration environment along with advanced methods and techniques.

    ReplyDelete
  6. svrtechnologies14 April 2018 at 01:39

    Good Work.Very Thankful For Posting The Content In your Blog.Can you please post About AWS DatBase Migration Concept In your Upcoming Blog Post

    ReplyDelete
  7. miaavery9924 June 2018 at 23:11

    Hello,

    Appreciate your work, very informative blog on Oracle Apps DBA. I just wanted to share information about Oracle Apps DBA Online Training. Hope it helps the community here.

    ReplyDelete
  8. bhanupratap10 August 2018 at 03:05

    I Really appreciate your work,Amazing blog,it is really helped me a lot.Thanks for sharing. Best software Training institute in Bangalore

    ReplyDelete
  9. Unknown30 October 2018 at 23:45

    I really impressed with your interesting blog and found some information DevOps Online Training

    ReplyDelete
  10. supreet6 November 2018 at 04:00

    I just see the post i am so happy the post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be subscribing to your feed and I hope you post again soon.

    best selenium training institute in hyderabad
    best selenium online training institute in hyderabad
    best institute for selenium training in hyderabad
    best software testing training institute in hyderabad

    ReplyDelete
  11. Sanvi12 February 2019 at 23:45

    Great Article, Thank you for sharing this useful information!!

    CEH Training In Hyderbad


    ReplyDelete
  12. Krish20 January 2020 at 03:21

    great very informative....

    Interview Question for CTS Placement
    Cognizant Interview Questions For Fresher
    Cognizant Interview Questions
    Resume Coustomer Service Executive
    Resume For Bank Job
    Resume Cyber security Engineer
    Resume Data Base Developer
    Resume DeputyManager
    Resume Design Engineer
    Resume Desktop Support Engineer

    ReplyDelete
  13. vijay6 August 2020 at 07:45

    Thanks for spending your valuable time to Create such a Thoughtful Post...It's Really useful for Now and my feature reference...Keep Updating Ever...
    Salesforce Training in Chennai

    Salesforce Online Training in Chennai

    Salesforce Training in Bangalore

    Salesforce Training in Hyderabad

    Salesforce training in ameerpet

    Salesforce Training in Pune

    Salesforce Online Training

    Salesforce Training

    ReplyDelete
  14. laxmi14 October 2020 at 22:48

    Testing tools online training
    VM Ware online training
    Windows server online training
    Pega online training
    Php online training

    ReplyDelete
  15. MY PET CLINIC VIZAG16 February 2022 at 22:29

    I am really happy with your blog because your article is very unique and powerful for new. . I want share about Best Veterinary Doctor in Vizag

    ReplyDelete

Subscribe to: Post Comments (Atom)