Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > mysql > answers

Error while restoring TRIGGERS

Member
  
Join Date: Feb 2009
Posts: 57
#1: Aug 31 '09
Hi,
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?

TIA....
Lauren
mwasif's Avatar
Moderator
  
Join Date: Jul 2006
Location: Pakistan
Posts: 718
#2: Aug 31 '09

re: Error while restoring TRIGGERS

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.
Member
  
Join Date: Feb 2009
Posts: 57
#3: Aug 31 '09

re: Error while restoring TRIGGERS

I am able to restore tables,procedures and functions.... the error only occurs while restoring triggers.

Thanks,
Lauren
Reply

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,272 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved