Results 1 to 7 of 7
Like Tree2Likes
  • 1 Post By 1337scape
  • 1 Post By 1337scape

Thread: INSERT command denied??

  1. #1
    1337scape is offline x10Hosting Member
    Join Date
    Oct 2007
    Posts
    81

    INSERT command denied??

    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.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'mining'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'prayer'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'ranged'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'magic'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'runecraft'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'herblore'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'crafting'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'slayer'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'smithing'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'fishing'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'cooking'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'firemaking'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'woodcutting'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'farming'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'fletching'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'overall'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'attack'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'strength'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'defence'
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: INSERT command denied to us
    er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
    table 'agility'
    dinomirt96 likes this.

  2. #2
    Blazer9131 is offline x10 Lieutenant
    Join Date
    Oct 2007
    Posts
    411

    Re: INSERT command denied??

    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*
    If you like my posts, or if they help you, Please click the next to it. Thanks =D



  3. #3
    1337scape is offline x10Hosting Member
    Join Date
    Oct 2007
    Posts
    81

    Re: INSERT command denied??

    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 by 1337scape; 11-13-2007 at 07:51 PM. Reason: Automerged Doublepost

  4. #4
    Blazer9131 is offline x10 Lieutenant
    Join Date
    Oct 2007
    Posts
    411

    Re: INSERT command denied??

    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?
    If you like my posts, or if they help you, Please click the next to it. Thanks =D



  5. #5
    1337scape is offline x10Hosting Member
    Join Date
    Oct 2007
    Posts
    81

    Re: INSERT command denied??

    if I host the Database on my computer, how would i get it online if it's on localhost?
    karimirt47 likes this.

  6. #6
    Blazer9131 is offline x10 Lieutenant
    Join Date
    Oct 2007
    Posts
    411

    Re: INSERT command denied??

    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...
    If you like my posts, or if they help you, Please click the next to it. Thanks =D



  7. #7
    1337scape is offline x10Hosting Member
    Join Date
    Oct 2007
    Posts
    81

    Re: INSERT command denied??

    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!

Similar Threads

  1. Enabling IP addresses in your firewall.
    By 1337scape in forum Free Hosting
    Replies: 32
    Last Post: 11-15-2007, 01:40 PM
  2. How to insert ads in phpBB3
    By Christopher in forum Tutorials
    Replies: 0
    Last Post: 09-07-2007, 05:17 PM
  3. Need help to insert x10hosting ads in my website.
    By blitzkrieg in forum Scripts, 3rd Party Apps, and Programming
    Replies: 3
    Last Post: 12-24-2006, 01:09 PM
  4. mysql cc
    By chrisosx in forum Free Hosting
    Replies: 7
    Last Post: 07-06-2005, 01:22 PM
  5. Mod Help
    By Ericsson in forum Free Hosting
    Replies: 4
    Last Post: 03-04-2005, 03:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
dedicated servers