agi

Ok, thanks anyway...

Yes, I was logged in with the cpanel user. The tables themselves could be imported, but there are also some stored procedures, functions and triggers I want to import, and the problem is with the triggers. For example, when a row gets inserted into a table, I want a procedure to run automatically, that's what I need the triggers for. I tried to import a table with a trigger: the table was created and all the rows were imported but the trigger couldn't be created, I saw the error message instead.

Hi, I'm trying to use triggers in mysql which require the "super" privilege. In cpanel there's no option to grant this privilege to a user (I gave all privileges to the user in cpanel but that doesn't include the super privilege.) So when I try to import my database in phpmyadmin it gives this error: "#1227 - Access denied; you need the SUPER privilege for this operation ". So I tried this: GRANT ALL PRIVILEGES ON database. * TO 'username'@'localhost' IDENTIFIED BY 'password', it gives this error: #1044 - Access denied for user 'user'@'localhost' to database 'database'. Can someone help me with this? Many thanks, Agi

Many thanks to both of you! I'll try these ip addresses, hopefully it'll be ok now.

Hi, I just registered my first domain (shopaholix.net) at marcaria.com and I'm trying to 'link' it somehow to my heliohost account but there seems to be a problem... I've received this email from marcaria: Please notice that provided DNS servers were not responding in an authoritative way, so in order to complete registration we have declared our own DNS servers in it's place. Once you have corrected the problem on your DNS servers, you can then log into your Marcaria.com account and re-enter the information of your DNS servers. Originally I provided the followings: First DNS: ns1.heliohost.org IP number: 65.19.143.3 Second DNS: ns2.heliohost.org IP number: 65.19.143.3 All the 4 fields were mandatory, but I couldn't find any information at helionet about the ip addresses, so I just went through the posts here on the forum and found this ip address... I hope someone can help me correct this! Thanks in advance!