By the sounds of it, I don't think you'll be able to connect directly from processing, since even when you do it by hand, the access to the database is from the server itself, not actually from your computer.

You might be able to get around this by having some PHP that does the database work, and get your processing sketch to read the data via the PHP files.

hi, i was trying with the library sftp, but no luck i can connect to the ftp server but when it tries to connect to the mysql server i get an error message:
Attempting to connect.
Logging in.
Connected, session started.
SQL.connect(): Could not connect to the database ( jdbc:mysql://zotaplex.zotaplex.net/nusixride ).

java.sql.SQLException: Access denied for user 'zotaplex'@'200.37.161.41' (using password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)


Do anybody have any idea?


here is the code:



import de.bezier.mysql.*;
import sftp.*;

Sftp sftp;

MySQL msql;
   // replace --username--, --password-- with your mysql-account.
   //
   String user     = "zotaplex";
   String pass     = "comaku";

   // name of the database to use
   //
   String database = "nusixride";

   // name of the table that will be created
   //
   String table    = "d";

void setup()
{
   size( 100, 100 );
   
     sftp = new Sftp("pangosus.dreamhost.com","zotaplex", true);
  sftp.setPassword("3fasfsCM");
 sftp.start(); // start the thread

 noLoop();

}

void draw()
{
   // i know this is not really a visual sketch ...
}
void mousePressed() {

  msql = new MySQL( "zotaplex.zotaplex.net", database, user, pass, this );
   
   if ( msql.connect() )
   {  
       // create a table with an id and a word
       //
       msql.execute( "CREATE TABLE IF NOT EXISTS " + table + " ("+
                         "id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,"+
                         "word VARCHAR( 255 )"+
                     ")"
                   );
                 
   }
   else
   {

   }
}