INSERT command denied??

Discussion in 'Free Hosting' started by 1337scape, Nov 13, 2007.

Thread Status:
Not open for further replies.
  1. 1337scape

    1337scape New Member

    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.
  2. Blazer9131

    Blazer9131 New Member

    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*
  3. 1337scape

    1337scape New Member

    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: Nov 13, 2007
  4. Blazer9131

    Blazer9131 New Member

    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?
  5. 1337scape

    1337scape New Member

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

    Blazer9131 New Member

    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...
  7. 1337scape

    1337scape New Member

    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! :)
Thread Status:
Not open for further replies.

Share This Page