472,129 Members | 1,598 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,129 software developers and data experts.

Error while restoring TRIGGERS

I am getting the following error while restoring triggers from one db to another db in Windows XP using Mysql Administrator GUI Tool:
Access denied for user 'User1'@'%' to database 'TestDB1'.

Can anyone please suggest me what i have to do?

Aug 31 '09 #1
2 1692
802 Expert 512MB
Does User1 has access to DB? If your DB is on the same machine where you are using GUI tool then you should GRANT priviliges to User1 to access from localhost.
Aug 31 '09 #2
I am able to restore tables,procedures and functions.... the error only occurs while restoring triggers.

Aug 31 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by robert | last post: by
2 posts views Thread by Karl | last post: by
reply views Thread by Dennis Gearon | last post: by
4 posts views Thread by Együd Csaba | last post: by
5 posts views Thread by Troels Arvin | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.