MySQL Connection

[GoogleCodeExporter]

What is the problem?
I am using godaddy to host my database and it says i need Super privilege. I 
can write the original row of data but i cant overwrite it. i.e. it allows my 
to connect and have my uid, rpname, salary, and wallet but when i set my money 
to 5000 as an example, my console spams me with an error about the super 
privilege needed and it doesnt overwrite it.

What steps will reproduce the problem?
Modifying the code to where it can save it properly

Do you have any errors? serverside or clientside? If you do, which ones?
Access denied; you need the SUPER privilege for this operation

Are you using the downloaded version or an SVN revision (if SVN, which
revision number)?
2.4.2

Please provide any additional information below.
I know that it might simply be impossible to do this without Super privilege 
but i was wondering if it was impossible to overwrite could we just set it up 
to where it would remove and create a new one with the new money?

Original issue reported on code.google.com by nyne...@gmail.com on 17 Jun 2012 at 8:50

[GoogleCodeExporter]

Weird, does godaddy know what exactly is not allowed? 

Original comment by fpeijnen...@gmail.com on 17 Jun 2012 at 9:06

[GoogleCodeExporter]

i called godaddy and they said that since each webhosting account is hooked up 
with others i cant have super access since i might mess with them

Original comment by nyne...@gmail.com on 17 Jun 2012 at 9:54

[GoogleCodeExporter]

any ideas?

Original comment by nyne...@gmail.com on 18 Jun 2012 at 1:07

[GoogleCodeExporter]

Godaddy is the worst for webhosting, especially for mySQL. They outsource their 
hosting... I use A2Hosting for webhosting and for the most part I'm pleased 
with them.

Original comment by chaosity...@gmail.com on 18 Jun 2012 at 5:52

[GoogleCodeExporter]

I think it might have something to do with the triggers. 

Original comment by fpeijnen...@gmail.com on 18 Jun 2012 at 6:03

[GoogleCodeExporter]

Go to your MySQL phpmyadmin page
Go to the SQL tab
Enter this:
SHOW PRIVILEGES

Run it
Give me output.

Original comment by fpeijnen...@gmail.com on 18 Jun 2012 at 3:21

[GoogleCodeExporter]

i bought different webhosting that works, i can still send you the stuff if u 
want me to though

Original comment by nyne...@gmail.com on 20 Jun 2012 at 3:58

[GoogleCodeExporter]

If you don't mind

Original comment by fpeijnen...@gmail.com on 22 Jun 2012 at 2:01

[GoogleCodeExporter]

Alter   Tables  To alter the table
Alter routine   Functions,Procedures    To alter or drop stored functions/procedures
Create  Databases,Tables,Indexes    To create new databases and tables
Create routine  Databases   To use CREATE FUNCTION/PROCEDURE
Create temporary tables Databases   To use CREATE TEMPORARY TABLE
Create view Tables  To create new views
Create user Server Admin    To create new users
Delete  Tables  To delete existing rows
Drop    Databases,Tables    To drop databases, tables, and views
Execute Functions,Procedures    To execute stored routines
File    File access on server   To read and write files on the server
Grant option    Databases,Tables,Functions,Procedures   To give to other users those 
privileges you posses...
Index   Tables  To create or drop indexes
Insert  Tables  To insert data into tables
Lock tables Databases   To use LOCK TABLES (together with SELECT privilege...
Process Server Admin    To view the plain text of currently executing quer...
References  Databases,Tables    To have references on tables
Reload  Server Admin    To reload or refresh tables, logs and privileges
Replication client  Server Admin    To ask where the slave or master servers are
Replication slave   Server Admin    To read binary log events from the master
Select  Tables  To retrieve rows from table
Show databases  Server Admin    To see all databases with SHOW DATABASES
Show view   Tables  To see views with SHOW CREATE VIEW
Shutdown    Server Admin    To shut down the server
Super   Server Admin    To use KILL thread, SET GLOBAL, CHANGE MASTER, etc...
Update  Tables  To update existing rows
Usage   Server Admin    No privileges - allow connect only

Original comment by nyne...@gmail.com on 23 Jun 2012 at 7:55

[GoogleCodeExporter]

Yeah, you don't have the trigger privilege.

Original comment by fpeijnen...@gmail.com on 23 Jun 2012 at 9:59

[GoogleCodeExporter]

The trigger privilege looks like this:
Trigger    Tables    To use triggers

Original comment by fpeijnen...@gmail.com on 23 Jun 2012 at 12:03

[GoogleCodeExporter]

awwww, that sucks

Original comment by nyne...@gmail.com on 23 Jun 2012 at 10:35

[GoogleCodeExporter]

Original comment by fpeijnen...@gmail.com on 28 Jun 2012 at 2:40

• Changed state: Accepted

[GoogleCodeExporter]

Original comment by fpeijnen...@gmail.com on 29 Jun 2012 at 10:02

• Changed state: Fixed