INSERT command denied??

Status
Not open for further replies.

1337scape

New Member
Messages
78
Reaction score
0
Points
0
Ok so a mod/Senior Member enabled the IP for me in the firewall but now look at this error and read below. http://1337scape.exofire.net/highscores.php Still aint working, look at the error.


OK here is our new problem. For some reason Your MySQL denies the "INSERT" command. May I know why. Because when I run my java server, it connects fine to MySQL but MySQL denies the "INSERT" command. I know this because I get this error on my java server.
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'mining'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'prayer'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'ranged'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'magic'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'runecraft'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'herblore'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'crafting'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'slayer'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'smithing'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'fishing'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'cooking'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'firemaking'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'woodcutting'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'farming'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'fletching'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'overall'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'attack'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'strength'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'defence'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'agility'
 

Blazer9131

New Member
Messages
411
Reaction score
0
Points
0
Umm. This is X10's Database, or yours? If its yours, add the username:pclipse_main on grant all access o.o.. If its x10's, Go to Cpanel, and database manager, and make sure you have added pclipse_main to the database your trying to connect to, and that he has the access needed, *insert command in this case*
 

1337scape

New Member
Messages
78
Reaction score
0
Points
0
X10Hosting (or it's cPanel) does not allow you to add custom privelages to each MySQL Database. The only way you can setup privlages is through the MySQL Databases manager in cPanel and Remote MySQL. There are no seperate privelages per user, and the closest to privelages is to assign a user to a database. Maybe this is the problem, or I've overlooked something. So any ideas?
Edit:
I have granted ALL PRIVELAGES, and it still gives me the same error. An pclipse_main is the account assigned to pclipse_highscores
 
Last edited:

Blazer9131

New Member
Messages
411
Reaction score
0
Points
0
Ok.. Umm, Let me get this clear,

You're trying to connect to x10's database, from your computer.. Why not just host the script on x10, or host the DB on your computer?
 

1337scape

New Member
Messages
78
Reaction score
0
Points
0
if I host the Database on my computer, how would i get it online if it's on localhost?
 

Blazer9131

New Member
Messages
411
Reaction score
0
Points
0
umm.. Who's apache are you using? x10's or yours? If x10's I can help out, If your's its unsafe to have a server on your computer open to the net...
 

1337scape

New Member
Messages
78
Reaction score
0
Points
0
well, x10's...I can host stuff locally with x10 and put it online? Please tell me how. Because currently I am hosting locally with Xampp's Apache. Xampp is a program for this kind of stuff if you aren't familiar with it. And I use Xampp's phpmyadmin. So if I can do the same stuff with x10 please help! :)
 
Status
Not open for further replies.
Top