473,324 Members | 2,257 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Error while restoring TRIGGERS

60
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
Aug 31 '09 #1
2 1774
mwasif
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
SLauren
60
I am able to restore tables,procedures and functions.... the error only occurs while restoring triggers.

Thanks,
Lauren
Aug 31 '09 #3

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

Similar topics

2
by: robert | last post by:
i've found the solution threads on changing a column on insert. works fine. question: - will one package serve for all such triggers, or does there need to be a package defined to support...
5
by: Bruce | last post by:
I have several user defined functions which are referenced in triggers and views. For software upgrades, I need to be able to drop the triggers and views which reference these user defined...
2
by: Karl | last post by:
Exception EDBEngineError in module Cserv.exe at 0013E2C8. General SQL error. SQL0727N An error occurred during implicit system action type "1". Information returned for the error includes SQLCODE...
1
by: den 2005 | last post by:
Hi everybody, I am problem with restoring data of byte type to be loaded on an Ink object. The data was earlier converted to byte then finally to hexadecimal data and store on a text file. Is...
0
by: Dennis Gearon | last post by:
If I have all sorts of triggers and constraints, The only way to have them applied incrementally to the data during restore or bulk load is to do the bulk load via individual INSERT statements,...
4
by: Együd Csaba | last post by:
Hi, the restoration of a dump stops at the line above. The dump was created with pgsql 7.3.2 and I need to pump it into a 7.4.3 one. Should anybody tell me what the problem can be and how I can...
0
by: Chinns Arumugam | last post by:
Hello folks, I'm getting following error message in the reference.vb (created using add web feature of VS.Net) when invoking the our vendor web service which was created using Soap Toolkit 1.0. ...
5
by: Troels Arvin | last post by:
Hello, Every so often, I'm asked to help people recover data from tables that were either dropped or where to much data was DELETEed. The complications related to restoring data are a problem....
4
neo008
by: neo008 | last post by:
Hi all, Finally gave up and putting it here. I am new to visual basic stucked up with an error- Run time errors.'-2147217887 (8004021)': Multiple-step operation generated errors. check each...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.